hive allows you to invoke Hive CLI (command line tool) to execute a SQL statement or HQL script.
Syntax:
hive -e 'query' | -f file [-hiveconf var=expr ...]
Parameters:
| Parameter | Description |
| -e 'query' | SQL statements to execute |
| -f file | Execute SQL statements from file |
| -hiveconf var=expr | Hive variables |
Notes:
Example 1:
hive -f script.hql -hiveconf cr_date=NVL(var, '1970-01-01')
Example 2:
hive -e 'SELECT ' || cols || ' FROM ' || table || ' LIMIT 3'
Compatibility: Apache Hive.