Hi,
I am able to issue Hive queries through the Hive JDBC but I cannot find a way to set config parameters nor change the job name. Is there a way to pass/modify the HiveConf when issuing a JDBC statement?
I have tried creating my own Session but had not much success by using: org.apache.hadoop.hive.jdbc.JdbcSessionState.JdbcSessionState(HiveConf conf) The properties that I set are not taken when the job runs.
thanks,
Zeus Courtois's gravatar image asked May 2 2011 at 20:29 in Hive-User by Zeus Courtois

1 Answers

On Mon, May 2, 2011 at 4:29 PM, Zeus Courtois wrote: > Hi, > I am able to issue Hive queries through the Hive JDBC but I cannot find a > way to set config parameters nor change the job name. > Is there a way to pass/modify the HiveConf when issuing a JDBC statement? > I have tried creating my own Session but had not much success by using: > org.apache.hadoop.hive.jdbc.JdbcSessionState.JdbcSessionState(HiveConf conf) > The properties that I set are not taken when the job runs. > thanks, >
You can not easily set a job name because hive overwrites this as it's job flow runs. A quick trick is adding a quick comment at the front of the query.
select /* my job name */ col1, from ...
Edward Capriolo's gravatar image answered May 2 2011 at 20:33 by Edward Capriolo