How can we access data with simple SQL knowledge in hive

Question

Hi,

I am new in hive but have idea in SQL, Can anyone tell me how can we can access data in hive with simple SQL knowledge?

Answer 1

Hey,

The following examples are simple, common data access queries that work on Hive as well as most SQL compatible RDBMS.

• Syntax:

SELECT * FROM table;

Retrieves all columns from all rows from a table.

• Similarly aggregations with GROUP BY and ordering of results are supported as expected,

SELECT col1, col2 FROM table GROUP BY col1, col2 ORDER BY col2 DESC;

These examples show how easy it is for anyone with SQL knowledge to log into a Hive command.