configuration
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
configuration [2017/09/04 18:17] dmtolpeko [hplsql.conn.hiveconn] |
configuration [2017/09/04 18:20] dmtolpeko [hplsql.conn.convert.hiveconn] |
||
|---|---|---|---|
| Line 135: | Line 135: | ||
| Version: HPL/SQL 0.3.1 | Version: HPL/SQL 0.3.1 | ||
| - | ===== hplsql.conn.hiveconn ===== | + | ===== hplsql.conn.hive1conn ===== |
| The //hplsql.conn.hiveconn// option specifies the connection profile for Hive embedded JDBC connection (not requiring a HiveServer): | The //hplsql.conn.hiveconn// option specifies the connection profile for Hive embedded JDBC connection (not requiring a HiveServer): | ||
| Line 146: | Line 146: | ||
| </HTML> | </HTML> | ||
| - | You can use this profile when you run HPL/SQL tool on a host containing the Hive client (typically, a node of the Hadoop cluster). | + | You can use this profile when you run HPL/SQL tool on a host containing the Hive client (typically, a node of the Hadoop cluster). Note that this connection mode is deprecated. |
| Version: HPL/SQL 0.3.1 | Version: HPL/SQL 0.3.1 | ||
| - | ===== hplsql.conn.init.hiveconn ===== | + | ===== hplsql.conn.init.hive1conn ===== |
| - | The //hplsql.conn.init.hiveconn// option defines SQL statements to execute after establishing a connection to the [[configuration#hplsqlconnhiveconn|hiveconn]] profile. You can use this option to specify job queue, execution engines in Hive etc. | + | The //hplsql.conn.init.hive1conn// option defines SQL statements to execute after establishing a connection to the [[configuration#hplsqlconnhive1conn|hive1conn]] profile. You can use this option to specify job queue, execution engines in Hive etc. |
| For example: | For example: | ||
| Line 158: | Line 158: | ||
| <HTML> | <HTML> | ||
| <property> | <property> | ||
| - | <name>hplsql.conn.init.hiveconn</name> | + | <name>hplsql.conn.init.hive1conn</name> |
| <value> | <value> | ||
| set mapred.job.queue.name=dev; | set mapred.job.queue.name=dev; | ||
| Line 169: | Line 169: | ||
| Version: HPL/SQL 0.3.1 | Version: HPL/SQL 0.3.1 | ||
| - | ===== hplsql.conn.convert.hiveconn ===== | + | ===== hplsql.conn.convert.hive1conn ===== |
| - | The //hplsql.conn.convert.hiveconn// option defines whether on-the-fly SQL conversion is enabled for the [[configuration#hplsqlconnhiveconn|hiveconn]] profile. The default value is //true//. | + | The //hplsql.conn.convert.hive1conn// option defines whether on-the-fly SQL conversion is enabled for the [[configuration#hplsqlconnhive1conn|hiveconn]] profile. The default value is //true//. |
| For example: | For example: | ||
| Line 177: | Line 177: | ||
| <HTML> | <HTML> | ||
| <property> | <property> | ||
| - | <name>hplsql.conn.convert.hiveconn</name> | + | <name>hplsql.conn.convert.hive1conn</name> |
| <value>true</value> | <value>true</value> | ||
| </property> | </property> | ||
Page Tools
