What is the syntax for HiveQL SELECT Statement?

0 votes
Can anyone suggest what can be the syntax for HiveQL SELECT statement?
Jun 24 in Big Data Hadoop by Sandip
31 views

1 answer to this question.

0 votes

Hey, 

You can use this  syntax below:

  1. SELECT [ALL | DISTINCT] select_expr, select_expr, ...
  2. FROM table_reference
  3. [WHERE where_condition]
  4. [GROUP BY col_list]
  5. [HAVING having_condition]
  6. [CLUSTER BY col_list | [DISTRIBUTE BY col_list] [SORT BY col_list]]
  7. [LIMIT number];
answered Jun 24 by Gitika
• 25,360 points

Related Questions In Big Data Hadoop

0 votes
1 answer

What is the prerequisite for BigQuery other than SQL?

If you know your SQL, you should ...READ MORE

answered Aug 23, 2018 in Big Data Hadoop by Frankie
• 9,810 points
36 views
0 votes
1 answer
0 votes
1 answer

What is the PostgreSQL connection string for Sqoop?

The format of the connection string is: jdbc:postgresql://<HOST>:<PORT>/<DATABASE_NAME> You ...READ MORE

answered Jun 6 in Big Data Hadoop by Kamal
73 views
0 votes
1 answer

Hadoop Mapreduce word count Program

Firstly you need to understand the concept ...READ MORE

answered Mar 16, 2018 in Data Analytics by nitinrawat895
• 10,730 points
3,363 views
0 votes
10 answers

hadoop fs -put command?

put syntax: put <localSrc> <dest> copy syntax: copyFr ...READ MORE

answered Dec 7, 2018 in Big Data Hadoop by Aditya
16,676 views
0 votes
1 answer

Hadoop dfs -ls command?

In your case there is no difference ...READ MORE

answered Mar 16, 2018 in Big Data Hadoop by kurt_cobain
• 9,260 points
1,217 views
0 votes
1 answer
0 votes
1 answer

What is the syntax for creating bucketing table in hive?

Hi, Syntax for creating bucketed table is as ...READ MORE

answered May 16 in Big Data Hadoop by Gitika
• 25,360 points
74 views
0 votes
1 answer

Mention what is the Hadoop MapReduce APIs contract for a key and value class?

Hey, For a key and value class, there ...READ MORE

answered Jun 10 in Big Data Hadoop by Gitika
• 25,360 points
59 views