Impala Comments – 2 Types of Comments with Examples

1. Objective – Impala Comments

In Impala, when we need to specify what each query or a group of queries are, we use Several Impala Comments. So, in this article, we will introduce various Impala Comments. There are two types of Impala Comments. Such as Single line and Multiline. We will also learn about them in detail here. Moreover, we will see some examples, to understand it well.

Impala Comments - 2 Types of Comments with Examples

Impala Comments – 2 Types of Comments with Examples

2. What is Impala Comments?

Basically, we can say, Impala Comments are same as comments in SQL. Moreover, we might require adding comments to specify what each query or a group of queries are while lots of queries are written in a file. So, further adding comments to the query file will help you achieve your objective.
Let’s Discuss Impala Architecture – components of Impala
However, there are two types of comments in programming languages, such as:

  1. Single-line Comments
  2. Multiline Comments

i. Single-line comments or  – – Sequence (two dashes)

In Impala, every single line that is followed by “—” is considered as a comment. For example:
– – Hello welcome to DataFlair
In other words, all text from a – – sequence to the end of the line is considered a comment and ignored. Moreover, This type of comment can occur on a single line by itself. Also, or part of a statement.

ii. Multiline comments or /* this is a comment */

In Impala, Multiline comments are all the lines between /* and */. For example:

Join DataFlair on Telegram
/*
Hi this is an example
Of multiline comments in Impala
*/

In other words, All text from a /* sequence to the next */ sequence is considered a comment and ignored. Basically, we can stretch it over multiple lines. It can occur on one or more lines by itself, in the middle of a statement. Also, before or after a statement.
Read about Impala Shell and Impala commands 

Hadoop Quiz
If these professionals can make a switch to Big Data, so can you:
Rahul Doddamani Story - DataFlair
Rahul Doddamani
Java → Big Data Consultant, JDA
Follow on
Mritunjay Singh Success Story - DataFlair
Mritunjay Singh
PeopleSoft → Big Data Architect, Hexaware
Follow on
Rahul Doddamani Success Story - DataFlair
Rahul Doddamani
Big Data Consultant, JDA
Follow on
I got placed, scored 100% hike, and transformed my career with DataFlair
Enroll now
Deepika Khadri Success Story - DataFlair
Deepika Khadri
SQL → Big Data Engineer, IBM
Follow on
DataFlair Web Services
You could be next!
Enroll now

3. Example of Comments in Impala

For example:

-- This line is a comment about a table.
create table ...;
/*
This is a multi-line comment about a query.
*/
select ...;
select * from t /* This is an embedded comment about a query. */ where ...;
select * from t -- This is a trailing comment within a multi-line command.
where ...;

4. Conclusion

As a result, we have seen, several types of Impala Comments. However, if any doubt occurs, feel free to ask in the comment section.
See also- Impala Quiz
For reference

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.