{"id":11954,"date":"2018-03-29T04:54:35","date_gmt":"2018-03-29T04:54:35","guid":{"rendered":"https:\/\/data-flair.training\/blogs\/?p=11954"},"modified":"2021-05-09T13:11:17","modified_gmt":"2021-05-09T07:41:17","slug":"impala-select-a-database","status":"publish","type":"post","link":"https:\/\/data-flair.training\/blogs\/impala-select-a-database\/","title":{"rendered":"Impala Select a Database Using Hue Browser"},"content":{"rendered":"

While working on Impala<\/strong>, it is essential to select one database among the available databases. So, in this article \u201cIntroduction to Impala Select a Database\u201d, we will learn what we mean by Impala Select a Database. Afterward, we will learn its syntax, usage as well as an example to understand it well.<\/span><\/p>\n

So, let’s know how Impala Select a Database.<\/p>\n

How Impala Select a Database<\/span><\/h2>\n

The word \u201cSelect a Database\u201d, means we need to select one among the available databases, as soon as we get connected to Impala. So, in order to switch the current session to another database, we use The USE DATABASE Statement of Impala.<\/span><\/p>\n

Impala USE Statement<\/span><\/h2>\n

Basically, we begin in a database named default, whenever we connect to an Impala instance. In order to switch to another database within an impala-shell session, Issue the statement USE db_name. <\/span><\/p>\n

Wherever any CREATE TABLE, INSERT, SELECT, or other statements act when you specify a table without prefixing it with a database name, is the current database.<\/span><\/p>\n

i. Usage<\/strong>
\nThere are some suitable situations in which Switching the default database is convenient, such as:<\/span><\/p>\n

    \n
  • While we want to avoid qualifying each reference to a table with the database name like SELECT * FROM t1 JOIN t2 instead of SELECT * FROM db.t1 JOIN db.t2.<\/strong><\/span><\/li>\n
  • Also, in order to do a sequence of operations all within the same database. Like creating a table, inserting data, and querying the table.<\/span><\/li>\n<\/ul>\n

    Moreover, specify the option -d db_name for the impala-shell command, to issue a USE statement automatically or to start the impala-shell interpreter for a particular database. <\/span><\/p>\n

    However, \u00a0without hardcoding a USE statement into the SQL source, we can use the -d option to run SQL scripts. Like setup or test scripts, against multiple databases.<\/span><\/p>\n

    A Syntax of <\/span>Impala USE Statement<\/span><\/h2>\n

    Here, is the syntax of USE Statement, below;<\/span>
    \n<\/span><\/p>\n

    USE db_name;<\/pre>\n
     <\/p>\n
    Example of USE statement<\/span><\/h2>\n
    Now, let’s understand it with the following example of USE statement. <\/span>
    \nSo, create a database with the name sample_database, at first. Like below.<\/span>
    \nFor Example,<\/strong> <\/span>
    \n<\/span><\/p>\n
    > CREATE DATABASE IF NOT EXISTS sample_database;<\/pre>\n
    Hence, it will create a new database. Further, it provides the following output;<\/span>
    \n<\/span>
    \n<\/span>Query: create DATABASE IF NOT EXISTS my_db2<\/b>
    \n<\/b>
    \n<\/b>Fetched 0 row(s) in 2.73s
    \n<\/b>
    \nThen, we can observe the name of the newly created database, through SHOW DATABASES statement, \u00a0while verifying the list of databases.<\/span>
    \n<\/span><\/b><\/p>\n
    > SHOW DATABASES;\n<\/b><\/pre>\n
     <\/b>Query: show DATABASES <\/b>
    \n<\/b>+———————–+ <\/b>
    \n<\/b>| name \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| <\/b>
    \n<\/b>+———————–+ <\/b>
    \n<\/b>| _impala_builtins \u00a0\u00a0\u00a0\u00a0\u00a0| <\/b>
    \n<\/b>| default \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| <\/b>
    \n<\/b>| my_db \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| <\/b>
    \n<\/b>| sample_database \u00a0\u00a0\u00a0\u00a0\u00a0\u00a0| <\/b>
    \n<\/b>+———————–+ <\/b>
    \n<\/b>Fetched 4 row(s) in 0.11s<\/b>
    \nFurther, using the USE Statement, \u00a0switch the session to the newly created database (sample_database).<\/span>
    \n<\/span><\/p>\n
    > USE sample_database;<\/pre>\n
    As a result, the current context will change to sample_database. Also, displays a message.<\/span>
    \n<\/span>
    \n<\/span>Query: use sample_database<\/b><\/p>\n
    Selecting a Database using Hue Browser<\/span><\/h2>\n
    There are several steps we can follow, in order to Select a Database using Hue Browser, such as;<\/span><\/p>\n
      \n
    • There is a drop-down menu On the left-hand side of the Query Editor of Impala.<\/span><\/li>\n
    • Then after clicking on the drop-down menu, you will find the list of all the databases in Impala.<\/span><\/li>\n
    • Further, select the database to which you need to change the current context.<\/span><\/li>\n<\/ul>\n
      This was all about Impala Select a Data Base. Hope you like our explanation.<\/p>\n
      Conclusion<\/span><\/h2>\n
      As a result, we have seen the whole concept of Impala Select a Database. Still, if any query you want to ask regarding Impala Select a Database, please ask through the comment section.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
      While working on Impala, it is essential to select one database among the available databases. So, in this article \u201cIntroduction to Impala Select a Database\u201d, we will learn what we mean by Impala Select...<\/p>\n","protected":false},"author":6,"featured_media":19070,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[27],"tags":[4367,5889,6507,6576,15218,15766],"class_list":["post-11954","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-impala","tag-example-of-use-statement","tag-how-impala-select-a-database","tag-impala-database","tag-impala-use-statement","tag-use-statement-syntax","tag-what-is-impala-use-statement"],"yoast_head":"\nImpala Select a Database Using Hue Browser - DataFlair<\/title>\n<meta name=\"description\" content=\"How Impala select a database, Impala USE Statement, Syntax of USE Statement in Impala, Syntax of Impala USE Statement, Select a database in Impala\" \/>\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-select-a-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Impala Select a Database Using Hue Browser - DataFlair\" \/>\n<meta property=\"og:description\" content=\"How Impala select a database, Impala USE Statement, Syntax of USE Statement in Impala, Syntax of Impala USE Statement, Select a database in Impala\" \/>\n<meta property=\"og:url\" content=\"https:\/\/data-flair.training\/blogs\/impala-select-a-database\/\" \/>\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-03-29T04:54:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-05-09T07:41:17+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Impala-Select-a-Database-01-3.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 Select a Database Using Hue Browser - DataFlair","description":"How Impala select a database, Impala USE Statement, Syntax of USE Statement in Impala, Syntax of Impala USE Statement, Select a database in Impala","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-select-a-database\/","og_locale":"en_US","og_type":"article","og_title":"Impala Select a Database Using Hue Browser - DataFlair","og_description":"How Impala select a database, Impala USE Statement, Syntax of USE Statement in Impala, Syntax of Impala USE Statement, Select a database in Impala","og_url":"https:\/\/data-flair.training\/blogs\/impala-select-a-database\/","og_site_name":"DataFlair","article_publisher":"https:\/\/www.facebook.com\/DataFlairWS\/","article_published_time":"2018-03-29T04:54:35+00:00","article_modified_time":"2021-05-09T07:41:17+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Impala-Select-a-Database-01-3.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-select-a-database\/#article","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/impala-select-a-database\/"},"author":{"name":"DataFlair Team","@id":"https:\/\/data-flair.training\/blogs\/#\/schema\/person\/2c58ecb4f73a39f0ef993f1ddfcd7b89"},"headline":"Impala Select a Database Using Hue Browser","datePublished":"2018-03-29T04:54:35+00:00","dateModified":"2021-05-09T07:41:17+00:00","mainEntityOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/impala-select-a-database\/"},"wordCount":566,"commentCount":0,"publisher":{"@id":"https:\/\/data-flair.training\/blogs\/#organization"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/impala-select-a-database\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Impala-Select-a-Database-01-3.jpg","keywords":["Example of USE statement","How Impala select a database","Impala Database","Impala use statement","USE Statement Syntax","what is Impala Use statement"],"articleSection":["Impala Tutorials"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/data-flair.training\/blogs\/impala-select-a-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/data-flair.training\/blogs\/impala-select-a-database\/","url":"https:\/\/data-flair.training\/blogs\/impala-select-a-database\/","name":"Impala Select a Database Using Hue Browser - DataFlair","isPartOf":{"@id":"https:\/\/data-flair.training\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/data-flair.training\/blogs\/impala-select-a-database\/#primaryimage"},"image":{"@id":"https:\/\/data-flair.training\/blogs\/impala-select-a-database\/#primaryimage"},"thumbnailUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Impala-Select-a-Database-01-3.jpg","datePublished":"2018-03-29T04:54:35+00:00","dateModified":"2021-05-09T07:41:17+00:00","description":"How Impala select a database, Impala USE Statement, Syntax of USE Statement in Impala, Syntax of Impala USE Statement, Select a database in Impala","breadcrumb":{"@id":"https:\/\/data-flair.training\/blogs\/impala-select-a-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/data-flair.training\/blogs\/impala-select-a-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/data-flair.training\/blogs\/impala-select-a-database\/#primaryimage","url":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Impala-Select-a-Database-01-3.jpg","contentUrl":"https:\/\/data-flair.training\/blogs\/wp-content\/uploads\/sites\/2\/2018\/06\/Impala-Select-a-Database-01-3.jpg","width":1200,"height":628,"caption":"Impala Select a Database using Hue Browser"},{"@type":"BreadcrumbList","@id":"https:\/\/data-flair.training\/blogs\/impala-select-a-database\/#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 Select a Database Using Hue Browser"}]},{"@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\/11954","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=11954"}],"version-history":[{"count":1,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/11954\/revisions"}],"predecessor-version":[{"id":94054,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/posts\/11954\/revisions\/94054"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media\/19070"}],"wp:attachment":[{"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/media?parent=11954"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/categories?post=11954"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/data-flair.training\/blogs\/wp-json\/wp\/v2\/tags?post=11954"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}