cli
Differences
This shows you the differences between two versions of the page.
|
cli [2015/09/23 20:26] 127.0.0.1 external edit |
cli [2016/04/20 07:31] dmtolpeko |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== PL/HQL Command Line ====== | + | ====== HPL/SQL Command Line ====== |
| - | You can run //plhql// tool from a command line to execute a SQL statement or HQL script. | + | You can run //hplsql// tool from a command line to execute a SQL statement or HPL/SQL script. |
| **Syntax**: | **Syntax**: | ||
| <code language="sql"> | <code language="sql"> | ||
| - | plhql -e 'query' | -f file | + | hplsql -e 'query' | -f file |
| [-main procname] | [-main procname] | ||
| [-d | --define | -hiveconf | -hivevar var=value ...] | [-d | --define | -hiveconf | -hivevar var=value ...] | ||
| Line 16: | Line 16: | ||
| **Parameters:** | **Parameters:** | ||
| - | | **Parameter** || **Description** | **PL/HQL Version** | | + | | **Parameter** || **Description** | **HPL/SQL Version** | |
| | -e 'query' || SQL statements to execute | 0.1 | | | -e 'query' || SQL statements to execute | 0.1 | | ||
| | -f file || Execute SQL statements from //file// | 0.1 | | | -f file || Execute SQL statements from //file// | 0.1 | | ||
| Line 24: | Line 24: | ||
| | -hiveconf var=value ||:::| 0.1 | | | -hiveconf var=value ||:::| 0.1 | | ||
| | -hivevar var=value ||:::| 0.1 | | | -hivevar var=value ||:::| 0.1 | | ||
| - | | -version | %%--%%version | Print PL/HQL version | 0.1 | | + | | -version | %%--%%version | Print HPL/SQL version | 0.1 | |
| | -trace | %%--%%trace | Print trace information | 0.1 | | | -trace | %%--%%trace | Print trace information | 0.1 | | ||
| | -H | %%--%%help | Print help information and exit | 0.1 | | | -H | %%--%%help | Print help information and exit | 0.1 | | ||
| Line 31: | Line 31: | ||
| * -e and -f cannot be specified together | * -e and -f cannot be specified together | ||
| - | * if -main option is not specified, PL/HQL start executing all statements from the beginning of the script | + | * if -main option is not specified, HPL/SQL starts executing all statements from the beginning of the script |
| * You can use single 'query' and double "query" quotes with -e option | * You can use single 'query' and double "query" quotes with -e option | ||
| * Currently -d, %%--%%define, -hivevar and -hiveconf are equivalent and allow you to define input variables. | * Currently -d, %%--%%define, -hivevar and -hiveconf are equivalent and allow you to define input variables. | ||
| Line 37: | Line 37: | ||
| **Example 1:** | **Example 1:** | ||
| - | Executing PL/HQL statements from a script: | + | Executing HPL/SQL statements from a script: |
| <code language="sql"> | <code language="sql"> | ||
| - | plhql -f script.hql | + | hplsql -f script.sql |
| </code> | </code> | ||
| **Example 2:** | **Example 2:** | ||
| - | Executing PL/HQL statements from command line: | + | Executing HPL/SQL statements from command line: |
| <code language="sql"> | <code language="sql"> | ||
| - | plhql -e "NVL(MAX_PARTITION_DATE(db.sales, local_dt, code='A'), CURRENT_DATE)" | + | hplsql -e "NVL(MAX_PARTITION_DATE(db.sales, local_dt, code='A'), CURRENT_DATE)" |
| </code> | </code> | ||
| Line 56: | Line 56: | ||
| <code language="sql"> | <code language="sql"> | ||
| - | plhql -e "PRINT a || ', ' || b" -d a=Hello -d b=world | + | hplsql -e "PRINT a || ', ' || b" -d a=Hello -d b=world |
| </code> | </code> | ||
| Result: | Result: | ||
| <code>Hello, world</code> | <code>Hello, world</code> | ||
Page Tools
