Impala Select Statement – How to Fetch Records using Hue

It is possible to fetch the data from one or more tables in a database in Impala. For that, we use Impala Select Statement. So, in this article, we will discuss, how we can fetch data with Impala Select Statement. Also, we will cover its syntax, usage as well as Example to understand it well.

So, let’s start How Impala Select Statement.

How to use Impala Select Statement?

Basically, to performs queries, retrieving data from one or more tables and producing result sets consisting of rows and columns, we use Impala  Select Statement. In addition, it also typically ends with a SELECT statement, to define data to copy from one table to another.

To be more specific, to fetch the data from one or more tables in a database, we use  Impala  Select Statement. Also, returns data in the form of tables.

Stay updated with latest technology trends
Join DataFlair on Telegram!!

i. Impala SELECT queries support

  • SQL data types: BOOLEAN, TINYINT, SMALLINT, INT, BIGINT, FLOAT, DOUBLE, TIMESTAMP, STRING.
  • Before the SELECT keyword, there is an optional WITH clause. By using this we can define a subquery whose name or column names can be referenced from later in the main query. 
  • DISTINCT clause per query. 
  • Subqueries in a FROM clause.
  • WHERE, GROUP BY, HAVING clauses.
  • ORDER BY

ii. Cancellation

It is possible to cancel it. That implies it Can be canceled. Basically, we use Ctrl-C from the impala-shell interpreter, in order to cancel this statement. Hence the Cancel button from the Watch page in Hue, Actions > Cancel from the Queries list in Cloudera Manager.

Also, Cancel from the list of in-flight queries (for a particular node) on the Queries tab in the Impala web UI (port 25000).

iii. Syntax of Impala Select Statements

Here, is the syntax of Impala – Select Statement, below;

SELECT column1, column2, columnN from table_name;

So, column1, column2…are the fields of a table whose values we want to fetch. So, we can use the following syntax if we want to fetch all the fields available in the field −

SELECT * FROM table_name;

iv. Example of Impala Select Statement

Let’s take one example of Impala Select statement suppose we have a table named Employees in Impala. Here,  is the data −

id name age address salary
1 shubham 32 delhi 20000
2 monika 25 mumbai 15000
3 kajal 27 alirajpur 40000
4 revti 25 indore 35000
5 shreyash 23 pune 30000
6 mehul 22 heydrabad 32000

So, using select statement, we can fetch the id, name, and age of all the records of the Employees table.

[quickstart.cloudera:21000] > select id, name, age from Employees

Also, Impala fetches id, name, the age of all the records from the specified table and displays them, on executing the above query.

Query: select id,name,age from Employees
id name age
1 shubham 32
2 monika 25
3 kajal 27
4 revti 25
5 shreyash 23
6 mehul 22

Fetched 6 row(s) in 0.66s
Moreover, using the select query, we can also fetch all the records from the Employees table.

[quickstart.cloudera:21000] > select name, age from Employees;
Query: select * from Employees

Basically, Impala fetches and displays all the records from the specified table, on executing the above query.

id name age address salary
1 shubham 32 delhi 20000
2 monika 25 mumbai 15000
3 kajal 27 alirajpur 40000
4 revti 25 indore 35000
5 shreyash 23 pune 30000
6 mehul 22 heydrabad 32000

Fetched 6 row(s) in 0.66s

Fetching the Records using Hue

There are several steps you have to follow while fetching the records using Hue. Such as:

  • At first,  type the select Statement in Impala Query editor. Further, click on the execute button.
  • Afterward,  we can see the list of the records of the specified table, just after executing the query, once you scroll down and select the Results tab.

So, this was all about Impala Select Statements. Hope you like our explanation.

Conclusion – Impala Select Statement

As a result, we have seen the whole concept of Impala – Select Statement. Still, if any doubt occurs in how to create impala database, feel free to ask in the comment section.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.