The following examples are simple, common data access queries that work on Hive as well as most SQL compatible RDBMS.
SELECT * FROM table;
Retrieves all columns from all rows from a table.
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.