{"id":12439,"date":"2018-04-07T09:58:35","date_gmt":"2018-04-07T09:58:35","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=12439"},"modified":"2021-05-09T13:11:08","modified_gmt":"2021-05-09T07:41:08","slug":"impala-show-statement","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/impala-show-statement\/","title":{"rendered":"Impala SHOW Statement – Listing the Tables using Hue"},"content":{"rendered":"

In our last Impala tutorial<\/strong>, we learned to create table statements, drop table statements in\u00a0Impala. in this\u00a0tutorial, we will discuss\u00a0Impala Show\u00a0Statements, i<\/span>s used to get information about different types of Impala objects. <\/span><\/p>\n

Moreover, we will discuss, how to get information with Impala SHOW Statement<\/strong>. Also, we will cover its syntax, usage as well as an example to understand it well.<\/span><\/p>\n

So, let’s start Impala Show Statements.<\/p>\n

How to use Impala SHOW Statement?<\/span><\/h2>\n

Basically, to get information about different types of Impala objects we use the Impala SHOW statement.<\/span>\u00a0In addition, it is a flexible way to do it.<\/p>\n

In other words, we can say to get the list of all the existing tables in the current database we use the show tables statement in Impala.<\/span><\/p>\n

a. Syntax of Show Statements in Impala<\/span><\/h3>\n

So, the syntax for using Impala SHOW Statement is-<\/span>
\n<\/span><\/b><\/p>\n

SHOW DATABASES [[LIKE] 'pattern']\nSHOW SCHEMAS [[LIKE] 'pattern'] - an alias for SHOW DATABASES\nSHOW TABLES [IN database_name] [[LIKE] 'pattern']\nSHOW [AGGREGATE | ANALYTIC] FUNCTIONS [IN database_name] [[LIKE] 'pattern']\nSHOW CREATE TABLE [database_name].table_name\nSHOW TABLE STATS [database_name.]table_name\nSHOW COLUMN STATS [database_name.]table_name\nSHOW PARTITIONS [database_name.]table_name\nSHOW FILES IN [database_name.]table_name [PARTITION (key_col=value [, key_col=value]]\nSHOW ROLES\nSHOW CURRENT ROLES\nSHOW ROLE GRANT GROUP group_name\nSHOW GRANT ROLE role_name<\/pre>\n
Also, to see the appropriate objects in the current database, issue a SHOW object_type statement, or to see objects in a specific database SHOW object_type IN database_name.<\/span>
\n<\/span>
\n<\/span>Moreover, using Unix-style * wildcards and allowing | for alternation, the optional pattern argument is a quoted string literal.<\/span> Also, the preceding LIKE keyword is optional. Although, make sure use all lowercase letters in the pattern string because all object names are stored in lowercase.<\/p>\n
For example:<\/span>
\n<\/span><\/p>\n
show databases 'a*';\nshow databases like 'a*';\nshow tables in some_db like '*fact*';\nuse some_db;\nshow tables '*dim*|*fact*';<\/pre>\n
b. Cancellation<\/span><\/h3>\n
 It is not possible to cancel it. That implies it Cannot be canceled.<\/span><\/p>\n
Example of SHOW Statements in Impala<\/span><\/h2>\n
Let us understand it with an example of the show tables statement. So, begin with changing the context to the required database if we want to get the list of tables in a particular database. Then using show tables statement we will get the list of tables in it.<\/span><\/p>\n
For Example,<\/span>
\n<\/span><\/p>\n
[quickstart.cloudera:21000] > use my_db;\nQuery: use my_db\n[quickstart.cloudera:21000] > show tables;<\/pre>\n
Moreover, Impala fetches the list of all the tables in the specified database, on executing the above query.<\/span>
\n<\/span><\/p>\n
Query: show tables\n+-----------+\n| name      |\n+-----------+\n| customers |\n| employee  |\n+-----------+\nFetched 2 row(s) in 0.10s<\/pre>\n
Listing the Tables using Hue<\/span><\/h2>\n
There are several steps you have to follow while Listing the Tables using Hue, such as:<\/span><\/p>\n
    \n
  • At first, select the context as my_db. Further, type the show tables statement in Impala Query editor then click on the execute button.<\/span><\/li>\n
  • Afterward, we can see the list of the tables if we scroll down and select the results tab just after executing the query.<\/span><\/li>\n<\/ul>\n
    So, this was all in the Impala SHOW Statements. Hope you like our explanation.<\/p>\n
    Conclusion – Impala SHOW Statements<\/span><\/h2>\n
    As a result, we have seen the whole concept of Impala SHOW Statement. Still, if any doubt occurs, feel free to ask in the comment section.<\/p>\n","protected":false},"excerpt":{"rendered":"
    In our last Impala tutorial, we learned to create table statements, drop table statements in\u00a0Impala. in this\u00a0tutorial, we will discuss\u00a0Impala Show\u00a0Statements, is used to get information about different types of Impala objects. Moreover, we...<\/p>\n","protected":false},"author":6,"featured_media":19092,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27],"tags":[4285,6560,12854,14051,14485,15762],"class_list":["post-12439","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-impala","tag-example-of-impala-show-statement","tag-impala-show-statement","tag-show-statement-in-impala","tag-syntax-of-impala-show-statements","tag-tables-using-hue","tag-what-is-impala-show-statement"],"yoast_head":"\nImpala SHOW Statement - Listing the Tables using Hue - DataFlair<\/title>\n<meta name=\"description\" content=\"Impala Show Statement- Syntax of Show Statement in impala, usage of Impala Show, How to List the Tables using Hue, Example of Impala Show Statement\" \/>\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\/impala-show-statement\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Impala SHOW Statement - Listing the Tables using Hue - DataFlair\" \/>\n<meta property=\"og:description\" content=\"Impala Show Statement- Syntax of Show Statement in impala, usage of Impala Show, How to List the Tables using Hue, Example of Impala Show Statement\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/impala-show-statement\/\" \/>\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-04-07T09:58:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-09T07:41:08+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Impala-SHOW-Statement-01-01.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=\"3 minutes\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Impala SHOW Statement - Listing the Tables using Hue - DataFlair","description":"Impala Show Statement- Syntax of Show Statement in impala, usage of Impala Show, How to List the Tables using Hue, Example of Impala Show Statement","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\/impala-show-statement\/","og_locale":"en_US","og_type":"article","og_title":"Impala SHOW Statement - Listing the Tables using Hue - DataFlair","og_description":"Impala Show Statement- Syntax of Show Statement in impala, usage of Impala Show, How to List the Tables using Hue, Example of Impala Show Statement","og_url":"https:\/\/data-flair.training\/blogs\/impala-show-statement\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-04-07T09:58:35+00:00","article_modified_time":"2021-05-09T07:41:08+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Impala-SHOW-Statement-01-01.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":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/data-flair.training\/blogs\/impala-show-statement\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/impala-show-statement\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Impala SHOW Statement – Listing the Tables using Hue","datePublished":"2018-04-07T09:58:35+00:00","dateModified":"2021-05-09T07:41:08+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/impala-show-statement\/"},"wordCount":434,"commentCount":1,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/impala-show-statement\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Impala-SHOW-Statement-01-01.jpg","keywords":["example of Impala Show statement","Impala SHOW Statement","Show Statement in impala","Syntax of impala Show statements","Tables using Hue","what is Impala show statement"],"articleSection":["Impala Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/impala-show-statement\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/impala-show-statement\/","url":"https:\/\/data-flair.training\/blogs\/impala-show-statement\/","name":"Impala SHOW Statement - Listing the Tables using Hue - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/impala-show-statement\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/impala-show-statement\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Impala-SHOW-Statement-01-01.jpg","datePublished":"2018-04-07T09:58:35+00:00","dateModified":"2021-05-09T07:41:08+00:00","description":"Impala Show Statement- Syntax of Show Statement in impala, usage of Impala Show, How to List the Tables using Hue, Example of Impala Show Statement","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/impala-show-statement\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/impala-show-statement\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/impala-show-statement\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Impala-SHOW-Statement-01-01.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Impala-SHOW-Statement-01-01.jpg","width":1200,"height":628,"caption":"Impala SHOW Statement"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/impala-show-statement\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog Home","item":"https:\/\/data-flair.training\/blogs\/"},{"@type":"ListItem","position":2,"name":"Impala Tutorials","item":"https:\/\/data-flair.training\/blogs\/category\/impala\/"},{"@type":"ListItem","position":3,"name":"Impala SHOW Statement – Listing the Tables using Hue"}]},{"@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\/2c58ecb4f73a39f0ef993f1ddfcd7b89","name":"DataFlair Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1ce4a0e3e542444fc73bbebf83e89e8b73e2d95ccb1fcee64da9945f078b97c5?s=96&d=mm&r=g","caption":"DataFlair Team"},"description":"The DataFlair Team provides industry-driven content on programming, Java, Python, C++, DSA, AI, ML, data Science, Android, Flutter, MERN, Web Development, and technology. Our expert educators focus on delivering value-packed, easy-to-follow resources for tech enthusiasts and professionals.","url":"https:\/\/data-flair.training\/blogs\/author\/dfteam2\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/12439","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\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/comments?post=12439"}],"version-history":[{"count":1,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/12439\/revisions"}],"predecessor-version":[{"id":94045,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/12439\/revisions\/94045"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/19092"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=12439"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=12439"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=12439"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}