How to Query Hive Tables : SELECT Statement
6.3 هزار بار بازدید -
7 سال پیش
-
Official Website:
Official Website: bigdataelearning.com/
How to Query Hive Tables : SELECT Statement
Here is the select statement syntax to select rows from hive tables using certain conditions.
SELECT col1, col2, col3
FROM TABLENAME
WHERE [condition]
GROUP BY col1
ORDER BY
LIMIT 10;
SELECT is the clause and here you can specify the list of columns that we are retrieving from the table or we can use an asterisk to fetch all the columns available in the hive table.
“FROM tableName” indicates the hive table from which we are going to fetch records.
WHERE is the condition part. We can specify the condition on which SELECT should retrieve the records.
GROUP BY is used if we need to group the records based on certain column value.
ORDER BY clause is used to sort the rows based on certain conditions
LIMIT is used to limit the number of records being fetched during every retrieval.
7 سال پیش
در تاریخ 1396/10/15 منتشر شده
است.
6,371
بـار بازدید شده