Hi Lars, Thank you so much for the information. I have couple of questions here 1. I would like to also access from ODBC tools , can i do it in any other way? 2. What if my authentication is LDAP , can i use
jdbc:hive2://foobar:10000/database;auth=*LDAP*?fs.s3.awsAccessKeyId=xxxxxxx; fs.s3.awsSecretAccesskey=xxxxxx Thanks On Mon, Jul 28, 2014 at 4:42 PM, Lars Francke <lars.fran...@gmail.com> wrote: > 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 < > tirume...@gmail.com> 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 >> >> >> >
