Yes there is. The format is: jdbc:hive2://<host>:<port>/dbName;sess_var_list?hive_conf_list#hive_var_list
Example: jdbc:hive2://foobar:10000/database;auth=noSasl?fs.s3.awsAccessKeyId=xxxxxxx; fs.s3.awsSecretAccesskey=xxxxxx#foo=bar Cheers, Lars On Tue, Jul 29, 2014 at 1:28 AM, sai chaitanya tirumerla < [email protected]> wrote: > Hi, > > We are connecting ODBC/JDBC tools to hiveserver2 using <ipaddr:10000> and > ldap authentication and wanted to pass hiveconf variables explicitly > through it. > Can anybody help me how to pass the hiveconf variables explicitly when the > connection is made to hiveserver2. > It works perfectly fine from cli as hive takes hiveconf variables > explicitly. > > Example hiveconf variables: > hive -hiveconf fs.s3.awsAccessKeyId=xxxxxxx -hiveconf > fs.s3.awsSecretAccesskey=xxxxxx > > This works fine in hive cli but is there anyway that we can pass to > hiveserver2 through ODBC/JDBC tools. > > > Thanks in Advance!! > > > --Sai > > >
