{"id":79724,"date":"2020-08-25T09:00:36","date_gmt":"2020-08-25T03:30:36","guid":{"rendered":"https:\/\/techvidvan.com\/tutorials\/?p=79724"},"modified":"2020-08-25T09:00:36","modified_gmt":"2020-08-25T03:30:36","slug":"apache-sqoop-list-tables","status":"publish","type":"post","link":"https:\/\/techvidvan.com\/tutorials\/apache-sqoop-list-tables\/","title":{"rendered":"List Tables in Apache Sqoop with Arguments"},"content":{"rendered":"<p>Sqoop List Tables is a tool for executing the \u2018SHOW TABLES\u2019 query against the particular database. In this Sqoop List Tables tutorial, you will learn what it is, purpose, syntax, arguments, and examples.<\/p>\n<p>So let&#8217;s start!!!<\/p>\n<p><a href=\"https:\/\/techvidvan.com\/tutorials\/wp-content\/uploads\/sites\/2\/2020\/08\/Sqoop-List-Tables-tv-1.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-79727\" src=\"https:\/\/techvidvan.com\/tutorials\/wp-content\/uploads\/sites\/2\/2020\/08\/Sqoop-List-Tables-tv-1.jpg\" alt=\"Sqoop- List Tables\" width=\"1200\" height=\"628\" \/><\/a><\/p>\n<h3>What is a Sqoop List Tables?<\/h3>\n<ul>\n<li>It is a tool that lists out all the tables of a particular database in the MySQL database server.<\/li>\n<li>This tool parses and executes \u2018SHOW TABLES\u2019 query against the particular database. Then it lists out all the present tables in a particular database.<\/li>\n<li>Its primary purpose is to list the tables present in a database.<\/li>\n<\/ul>\n<h3>Sqoop List Tables Syntax and Arguments<\/h3>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">$ sqoop list-tables (generic-args) (list-tables-args)\n$ sqoop-list-tables (generic-args) (list-tables-args)\n<\/pre>\n<p>We have to pass the Hadoop generic arguments before any list-tables arguments. But we can pass the arguments in any order with respect to each other.<\/p>\n<p>Common Arguments are:<\/p>\n<table>\n<tbody>\n<tr>\n<td><b>Argument<\/b><\/td>\n<td><b>Description<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">&#8211;connect &lt;jdbc-uri&gt;<\/span><\/td>\n<td><span style=\"font-weight: 400\">It will specify the JDBC connect string<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">&#8211;connection-manager &lt;class-name&gt;<\/span><\/td>\n<td><span style=\"font-weight: 400\">It will specify the connection manager class to be used<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">&#8211;driver &lt;class-name&gt;<\/span><\/td>\n<td><span style=\"font-weight: 400\">Manually specify JDBC driver class to use<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">&#8211;hadoop-mapred-home &lt;dir&gt;<\/span><\/td>\n<td><span style=\"font-weight: 400\">Override $HADOOP_MAPRED_HOME<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">&#8211;help<\/span><\/td>\n<td><span style=\"font-weight: 400\">Print usage instructions<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">&#8211;password-file<\/span><\/td>\n<td><span style=\"font-weight: 400\">It will set the path for the file containing authentication password<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">-P<\/span><\/td>\n<td><span style=\"font-weight: 400\">It will read the password from console<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">&#8211;password &lt;password&gt;<\/span><\/td>\n<td><span style=\"font-weight: 400\">Set authentication password<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">&#8211;username &lt;username&gt;<\/span><\/td>\n<td><span style=\"font-weight: 400\">Set authentication username<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">&#8211;verbose<\/span><\/td>\n<td><span style=\"font-weight: 400\">This option prints more information when working<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">&#8211;connection-param-file &lt;filename&gt;<\/span><\/td>\n<td><span style=\"font-weight: 400\">This argument specify the optional properties file which provides the connection parameters<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400\">&#8211;relaxed-isolation<\/span><\/td>\n<td><span style=\"font-weight: 400\">It will set the connection transaction isolation in order\u00a0 to read the uncommitted for the mappers.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h3>Sqoop List Tables Example Invocations<\/h3>\n<p><strong>Example 1:<\/strong> In this example, we are trying to present list tables in the database named &#8220;demo&#8221;:<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">$ sqoop list-tables --connect jdbc:mysql:\/\/localhost\/demo\n<\/pre>\n<p>The output of the above command will be:<br \/>\nemp_info<br \/>\ndept_info<br \/>\njob_descr<\/p>\n<p><strong>Example 2:<\/strong> In case of the postgresql, the list tables command with the common arguments retrieves &#8220;public&#8221; schema only. For the custom schema, we have to use &#8211;schema arguments for listing tables of the particular schema.<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"null\">$ sqoop list-tables --connect jdbc:postgresql:\/\/localhost\/demo  --username root -P root --schema payrolldept\n<\/pre>\n<h3>Summary<\/h3>\n<p>After reading this article, I hope you clearly understood how we can list all the tables in a particular database by using Sqoop.<\/p>\n<p>The Sqoop List Tables is a tool that lists out all the tables of a particular database in the MySQL database server. The article had explained its syntax and common argument with the help of example.<\/p>\n<p><strong>Do not forget to <a href=\"https:\/\/g.page\/techvidvan?gm\">share your experience<\/a> with us.<\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Sqoop List Tables is a tool for executing the \u2018SHOW TABLES\u2019 query against the particular database. In this Sqoop List Tables tutorial, you will learn what it is, purpose, syntax, arguments, and examples. So&#46;&#46;&#46;<\/p>\n","protected":false},"author":1,"featured_media":79727,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3163],"tags":[3208,3209,3210,3211],"class_list":["post-79724","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sqoop","tag-arguments-in-sqoop-list-tables","tag-examples-of-sqoop-list-tables","tag-list-tables-in-sqoop","tag-sqoop-list-tables"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>List Tables in Apache Sqoop with Arguments - TechVidvan<\/title>\n<meta name=\"description\" content=\"Sqoop List Tables is a tool that lists all tables of a particular database in the MySQL database server. Learn syntax &amp; arguments of Sqoop List Tables tool\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/techvidvan.com\/tutorials\/apache-sqoop-list-tables\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"List Tables in Apache Sqoop with Arguments - TechVidvan\" \/>\n<meta property=\"og:description\" content=\"Sqoop List Tables is a tool that lists all tables of a particular database in the MySQL database server. Learn syntax &amp; arguments of Sqoop List Tables tool\" \/>\n<meta property=\"og:url\" content=\"https:\/\/techvidvan.com\/tutorials\/apache-sqoop-list-tables\/\" \/>\n<meta property=\"og:site_name\" content=\"TechVidvan\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TechVidvan\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-08-25T03:30:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/techvidvan.com\/tutorials\/wp-content\/uploads\/2020\/08\/Sqoop-List-Tables-tv-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=\"TechVidvan Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@vidvantech\" \/>\n<meta name=\"twitter:site\" content=\"@vidvantech\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"TechVidvan 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":"List Tables in Apache Sqoop with Arguments - TechVidvan","description":"Sqoop List Tables is a tool that lists all tables of a particular database in the MySQL database server. Learn syntax & arguments of Sqoop List Tables tool","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:\/\/techvidvan.com\/tutorials\/apache-sqoop-list-tables\/","og_locale":"en_US","og_type":"article","og_title":"List Tables in Apache Sqoop with Arguments - TechVidvan","og_description":"Sqoop List Tables is a tool that lists all tables of a particular database in the MySQL database server. Learn syntax & arguments of Sqoop List Tables tool","og_url":"https:\/\/techvidvan.com\/tutorials\/apache-sqoop-list-tables\/","og_site_name":"TechVidvan","article_publisher":"https:\/\/www.facebook.com\/TechVidvan\/","article_published_time":"2020-08-25T03:30:36+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/techvidvan.com\/tutorials\/wp-content\/uploads\/2020\/08\/Sqoop-List-Tables-tv-1.jpg","type":"image\/jpeg"}],"author":"TechVidvan Team","twitter_card":"summary_large_image","twitter_creator":"@vidvantech","twitter_site":"@vidvantech","twitter_misc":{"Written by":"TechVidvan Team","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/techvidvan.com\/tutorials\/apache-sqoop-list-tables\/#article","isPartOf":{"@id":"https:\/\/techvidvan.com\/tutorials\/apache-sqoop-list-tables\/"},"author":{"name":"TechVidvan Team","@id":"https:\/\/techvidvan.com\/tutorials\/#\/schema\/person\/e9c26e74dd3d87421f7ada9433b8cd22"},"headline":"List Tables in Apache Sqoop with Arguments","datePublished":"2020-08-25T03:30:36+00:00","mainEntityOfPage":{"@id":"https:\/\/techvidvan.com\/tutorials\/apache-sqoop-list-tables\/"},"wordCount":404,"commentCount":0,"publisher":{"@id":"https:\/\/techvidvan.com\/tutorials\/#organization"},"image":{"@id":"https:\/\/techvidvan.com\/tutorials\/apache-sqoop-list-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/techvidvan.com\/tutorials\/wp-content\/uploads\/2020\/08\/Sqoop-List-Tables-tv-1.jpg","keywords":["Arguments in \ufeffSqoop List Tables","examples of Sqoop list tables","list tables in Sqoop","Sqoop list-tables"],"articleSection":["Sqoop Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/techvidvan.com\/tutorials\/apache-sqoop-list-tables\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/techvidvan.com\/tutorials\/apache-sqoop-list-tables\/","url":"https:\/\/techvidvan.com\/tutorials\/apache-sqoop-list-tables\/","name":"List Tables in Apache Sqoop with Arguments - TechVidvan","isPartOf":{"@id":"https:\/\/techvidvan.com\/tutorials\/#website"},"primaryImageOfPage":{"@id":"https:\/\/techvidvan.com\/tutorials\/apache-sqoop-list-tables\/#primaryimage"},"image":{"@id":"https:\/\/techvidvan.com\/tutorials\/apache-sqoop-list-tables\/#primaryimage"},"thumbnailUrl":"https:\/\/techvidvan.com\/tutorials\/wp-content\/uploads\/2020\/08\/Sqoop-List-Tables-tv-1.jpg","datePublished":"2020-08-25T03:30:36+00:00","description":"Sqoop List Tables is a tool that lists all tables of a particular database in the MySQL database server. Learn syntax & arguments of Sqoop List Tables tool","breadcrumb":{"@id":"https:\/\/techvidvan.com\/tutorials\/apache-sqoop-list-tables\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/techvidvan.com\/tutorials\/apache-sqoop-list-tables\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/techvidvan.com\/tutorials\/apache-sqoop-list-tables\/#primaryimage","url":"https:\/\/techvidvan.com\/tutorials\/wp-content\/uploads\/2020\/08\/Sqoop-List-Tables-tv-1.jpg","contentUrl":"https:\/\/techvidvan.com\/tutorials\/wp-content\/uploads\/2020\/08\/Sqoop-List-Tables-tv-1.jpg","width":1200,"height":628,"caption":"Sqoop- List Tables"},{"@type":"BreadcrumbList","@id":"https:\/\/techvidvan.com\/tutorials\/apache-sqoop-list-tables\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/techvidvan.com\/tutorials\/"},{"@type":"ListItem","position":2,"name":"List Tables in Apache Sqoop with Arguments"}]},{"@type":"WebSite","@id":"https:\/\/techvidvan.com\/tutorials\/#website","url":"https:\/\/techvidvan.com\/tutorials\/","name":"TechVidvan Blogs","description":"","publisher":{"@id":"https:\/\/techvidvan.com\/tutorials\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/techvidvan.com\/tutorials\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/techvidvan.com\/tutorials\/#organization","name":"TechVidvan","url":"https:\/\/techvidvan.com\/tutorials\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/techvidvan.com\/tutorials\/#\/schema\/logo\/image\/","url":"https:\/\/techvidvan.com\/tutorials\/wp-content\/uploads\/2024\/03\/techvidvan-logo-200x50-1.webp","contentUrl":"https:\/\/techvidvan.com\/tutorials\/wp-content\/uploads\/2024\/03\/techvidvan-logo-200x50-1.webp","width":200,"height":50,"caption":"TechVidvan"},"image":{"@id":"https:\/\/techvidvan.com\/tutorials\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TechVidvan\/","https:\/\/x.com\/vidvantech"]},{"@type":"Person","@id":"https:\/\/techvidvan.com\/tutorials\/#\/schema\/person\/e9c26e74dd3d87421f7ada9433b8cd22","name":"TechVidvan Team","description":"The TechVidvan Team delivers practical, beginner-friendly tutorials on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our experts are here to help you upskill and excel in today\u2019s tech industry."}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/techvidvan.com\/tutorials\/wp-json\/wp\/v2\/posts\/79724","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/techvidvan.com\/tutorials\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/techvidvan.com\/tutorials\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/techvidvan.com\/tutorials\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/techvidvan.com\/tutorials\/wp-json\/wp\/v2\/comments?post=79724"}],"version-history":[{"count":0,"href":"https:\/\/techvidvan.com\/tutorials\/wp-json\/wp\/v2\/posts\/79724\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/techvidvan.com\/tutorials\/wp-json\/wp\/v2\/media\/79727"}],"wp:attachment":[{"href":"https:\/\/techvidvan.com\/tutorials\/wp-json\/wp\/v2\/media?parent=79724"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/techvidvan.com\/tutorials\/wp-json\/wp\/v2\/categories?post=79724"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/techvidvan.com\/tutorials\/wp-json\/wp\/v2\/tags?post=79724"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}