configuration

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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;​