{"id":7342,"date":"2018-02-08T07:31:25","date_gmt":"2018-02-08T07:31:25","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=7342"},"modified":"2021-12-07T12:50:18","modified_gmt":"2021-12-07T07:20:18","slug":"sqoop-list-databases","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/sqoop-list-databases\/","title":{"rendered":"Sqoop List Databases – Syntax and Arguments"},"content":{"rendered":"

In Sqoop<\/strong><\/a>, there is a tool that executes as well as parses the \u2018SHOW DATABASES\u2019 query against the database server. Basically, that we call Sqoop list databases tool. This chapter carries information on how to list out the databases using Sqoop. <\/span><\/p>\n

Apart from an introduction of Sqoop list-databases, we will also describe purpose & syntax of\u00a0Sqoop list databases, to learn well. Also, we will cover its examples for deep understanding.<\/span><\/p>\n

Introduction to Sqoop List Databases<\/h3>\n

a. Basically, Sqoop list-databases tool executes as well as parses the\u00a0<\/span>\u2018 SHOW DATABASES\u2019 query against the database server.<\/span>
\nb. Also, it lists out the present databases on the server.<\/span><\/p>\n

Purpose of Sqoop List-Databases tool<\/h3>\n

Although, the main purpose of Sqoop list databases tool is it lists out the present on a server.<\/span><\/p>\n

Syntax to Sqoop List Databases<\/h3>\n

$ sqoop list-databases (generic-args) (list-databases-args)
\n$ sqoop-list-databases (generic-args) (list-databases-args)
\nHowever, the list-databases arguments can be entered in any order with respect to one another, but the Hadoop<\/strong><\/a> generic arguments must precede any Sqoop list-databases arguments only.<\/span><\/p>\n

Common Arguments for Sqoop List Databases<\/h3>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Argument<\/b><\/td>\nDescription<\/b><\/td>\n<\/tr>\n
–connect <jdbc-uri><\/span><\/td>\nSpecify JDBC connect string<\/span><\/td>\n<\/tr>\n
–connection-manager <class-name><\/span><\/td>\nSpecify connection manager class to use<\/span><\/td>\n<\/tr>\n
–driver <class-name><\/span><\/td>\nManually specify JDBC driver class to use<\/span><\/td>\n<\/tr>\n
–hadoop-mapred-home <dir><\/span><\/td>\nOverride $HADOOP_MAPRED_HOME<\/span><\/td>\n<\/tr>\n
–help<\/span><\/td>\nPrint usage instructions<\/span><\/td>\n<\/tr>\n
–password-file<\/span><\/td>\nSet path for a file containing the authentication password<\/span><\/td>\n<\/tr>\n
-P<\/span><\/td>\nRead password from console<\/span><\/td>\n<\/tr>\n
–password <password><\/span><\/td>\nSet authentication password<\/span><\/td>\n<\/tr>\n
–username <username><\/span><\/td>\nSet authentication username<\/span><\/td>\n<\/tr>\n
–verbose<\/span><\/td>\nPrint more information while working<\/span><\/td>\n<\/tr>\n
–connection-param-file <filename><\/span><\/td>\nOptional properties file that provides connection parameters<\/span><\/td>\n<\/tr>\n
–relaxed-isolation<\/span><\/td>\nSet connection transaction isolation to read uncommitted for the mappers.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Sqoop List Databases Example Invocations<\/h3>\n

Basically, here, on a MySQL server, sqoop list database schemas available:<\/span>
\n$ sqoop list-databases –connect jdbc:mysql:\/\/database.example.com\/
\ninformation_schema
\nEmployees
\nAlso, note that it only works with HSQLDB, MySQL, and Oracle. However, it is necessary that the user connecting to the database has DBA privileges while using with Oracle.<\/span><\/p>\n

Conclusion<\/h3>\n

As a result, we have seen the complete introduction of\u00a0Sqoop List Databases tool. Also, we have seen its syntax as well as purpose. Moreover, we have covered list databases arguments in sqoop for practical uses. Although if any query regarding same strikes you, please ask through the comment section.
\nSee Also-<\/strong>
\nSqoop Import<\/strong> <\/a>and Sqoop\u00a0Validation<\/strong><\/a>
\nFor reference<\/strong><\/a>

In Sqoop, there is a tool that executes as well as parses the \u2018SHOW DATABASES\u2019 query against the database server. Basically, that we call Sqoop list databases tool. This chapter carries information on how...<\/p>\n","protected":false},"author":9,"featured_media":7440,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[68],"tags":[10253,13652,13653,13654,13655,14110],"class_list":["post-7342","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sqoop","tag-purpose-of-sqoop-list-databases","tag-sqoop-list-database","tag-sqoop-list-database-syntax","tag-sqoop-list-databases","tag-sqoop-list-databases-purpose","tag-syntax-of-sqoop-list-databases"],"yoast_head":"\nSqoop List Databases - Syntax and Arguments - DataFlair<\/title>\n<meta name=\"description\" content=\"Sqoop List Databases- What is Sqoop List Databases, Purpose & Syntax of Sqoop List-Databases, Common Arguments for List Databases in Sqoop,\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/data-flair.training\/blogs\/sqoop-list-databases\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Sqoop List Databases - Syntax and Arguments - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Sqoop List Databases- What is Sqoop List Databases, Purpose & Syntax of Sqoop List-Databases, Common Arguments for List Databases in Sqoop,\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/sqoop-list-databases\/\" \/>\n<meta property=\"og:site_name\" content=\"DataFlair\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/DataFlairWS\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-02-08T07:31:25+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-12-07T07:20:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/02\/Introduction-to-Sqoop-List-Databases-01-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"DataFlair Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:site\" content=\"@DataFlairWS\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"DataFlair Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Sqoop List Databases - Syntax and Arguments - DataFlair","description":"Sqoop List Databases- What is Sqoop List Databases, Purpose & Syntax of Sqoop List-Databases, Common Arguments for List Databases in Sqoop,","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/data-flair.training\/blogs\/sqoop-list-databases\/","og_locale":"en_US","og_type":"article","og_title":"Sqoop List Databases - Syntax and Arguments - DataFlair","og_description":"Sqoop List Databases- What is Sqoop List Databases, Purpose & Syntax of Sqoop List-Databases, Common Arguments for List Databases in Sqoop,","og_url":"https:\/\/data-flair.training\/blogs\/sqoop-list-databases\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-02-08T07:31:25+00:00","article_modified_time":"2021-12-07T07:20:18+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/02\/Introduction-to-Sqoop-List-Databases-01-1.jpg","type":"image\/jpeg"}],"author":"DataFlair Team","twitter_card":"summary_large_image","twitter_creator":"@DataFlairWS","twitter_site":"@DataFlairWS","twitter_misc":{"Written by":"DataFlair Team","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/sqoop-list-databases\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/sqoop-list-databases\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/6e11a88eea98179e861a0933f8959f8f"},"headline":"Sqoop List Databases – Syntax and Arguments","datePublished":"2018-02-08T07:31:25+00:00","dateModified":"2021-12-07T07:20:18+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sqoop-list-databases\/"},"wordCount":396,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sqoop-list-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/02\/Introduction-to-Sqoop-List-Databases-01-1.jpg","keywords":["purpose of Sqoop List Databases","Sqoop List Database","Sqoop List Database syntax","Sqoop List Databases","Sqoop List Databases purpose","syntax of Sqoop List Databases"],"articleSection":["Sqoop Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/sqoop-list-databases\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/sqoop-list-databases\/","url":"https:\/\/data-flair.training\/blogs\/sqoop-list-databases\/","name":"Sqoop List Databases - Syntax and Arguments - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/sqoop-list-databases\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/sqoop-list-databases\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/02\/Introduction-to-Sqoop-List-Databases-01-1.jpg","datePublished":"2018-02-08T07:31:25+00:00","dateModified":"2021-12-07T07:20:18+00:00","description":"Sqoop List Databases- What is Sqoop List Databases, Purpose & Syntax of Sqoop List-Databases, Common Arguments for List Databases in Sqoop,","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/sqoop-list-databases\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/sqoop-list-databases\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/sqoop-list-databases\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/02\/Introduction-to-Sqoop-List-Databases-01-1.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/02\/Introduction-to-Sqoop-List-Databases-01-1.jpg","width":1200,"height":628,"caption":"What is Sqoop List Databases"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/sqoop-list-databases\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Chracteristics of Impala Hadoop","item":"https:\/\/data-flair.training\/blogs\/tag\/chracteristics-of-impala-hadoop\/"},{"@type":"ListItem","position":3,"name":"Sqoop List Databases – Syntax and Arguments"}]},{"@type":"WebSite","@id":"https:\/\/data-flair.training\/blogs\/#website","url":"https:\/\/data-flair.training\/blogs\/","name":"DataFlair","description":"Learn Today. Lead Tomorrow.","publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/data-flair.training\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/data-flair.training\/blogs\/#organization","name":"DataFlair","url":"https:\/\/data-flair.training\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2016\/07\/Data-Flair.png","width":106,"height":48,"caption":"DataFlair"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataFlairWS\/","https:\/\/x.com\/DataFlairWS","https:\/\/www.linkedin.com\/company\/dataflair-web-services-pvt-ltd\/","https:\/\/www.youtube.com\/user\/DataFlairWS"]},{"@type":"Person","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/6e11a88eea98179e861a0933f8959f8f","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/54363d8635c383dcd7e3be0ef00dbeef4217c45bf323d27bc2c92366b724df08?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/54363d8635c383dcd7e3be0ef00dbeef4217c45bf323d27bc2c92366b724df08?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/54363d8635c383dcd7e3be0ef00dbeef4217c45bf323d27bc2c92366b724df08?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"At DataFlair, our team of experts is committed to offering high-quality tutorials on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. We simplify learning to help you advance your career in the tech world.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam5\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/7342","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=7342"}],"version-history":[{"count":4,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/7342\/revisions"}],"predecessor-version":[{"id":105332,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/7342\/revisions\/105332"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/7440"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=7342"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=7342"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=7342"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}