This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
configuration [2017/09/04 18:12] dmtolpeko |
configuration [2017/09/04 18:19] dmtolpeko [hplsql.conn.init.hiveconn] |
||
---|---|---|---|
Line 88: | Line 88: | ||
===== hplsql.conn.hiveconn ===== | ===== hplsql.conn.hiveconn ===== | ||
- | 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 HiveServer 2 embedded connection (local connection): |
<HTML> | <HTML> | ||
<property> | <property> | ||
<name>hplsql.conn.hiveconn</name> | <name>hplsql.conn.hiveconn</name> | ||
- | <value>org.apache.hadoop.hive.jdbc.HiveDriver;jdbc:hive://</value> | + | <value>org.apache.hive.jdbc.HiveDriver;jdbc:hive2://</value> |
</property> | </property> | ||
</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 running the HiveServer2. |
Version: HPL/SQL 0.3.1 | Version: HPL/SQL 0.3.1 | ||
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; |