HPL/SQL is included to Apache Hive since version 2.0
HPL/SQL is included to Apache Hive since version 2.0
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.