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] (current) 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> |