Re: Passing hive conf variables through ODBC/JDBC

2014-07-29 Thread sai chaitanya tirumerla
Hi, Thanks Lars. I'm using hive 0.11 and it throws "can't execute after statement is closed" error when doing it(jdbc:hive2://foobar:1/database? fs.s3.awsAccessKeyId=xxx;fs.s3.awsSecretAccesskey=xx) from sql workbench. i have tried different methods to make it work like jdbc:hive2://f

Re: Passing hive conf variables through ODBC/JDBC

2014-07-28 Thread Lars Francke
Hi, 1. I'm afraid I have no idea about ODBC 2. No need to specify anything on the client side when using LDAP. That was just an example So it'd look like this for you: jdbc:hive2://foobar:1/database?fs.s3. awsAccessKeyId=xxx;fs.s3.awsSecretAccesskey=xx Cheers, Lars On Tue, Jul 29,

Re: Passing hive conf variables through ODBC/JDBC

2014-07-28 Thread sai chaitanya tirumerla
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:1/database;auth=*LDAP*?fs.s3.awsAccessKeyId=xxx; fs.s3.awsSec

Re: Passing hive conf variables through ODBC/JDBC

2014-07-28 Thread Lars Francke
Yes there is. The format is: jdbc:hive2://:/dbName;sess_var_list?hive_conf_list#hive_var_list Example: jdbc:hive2://foobar:1/database;auth=noSasl?fs.s3.awsAccessKeyId=xxx; fs.s3.awsSecretAccesskey=xx#foo=bar Cheers, Lars On Tue, Jul 29, 2014 at 1:28 AM, sai chaitanya tirumerla < ti

Passing hive conf variables through ODBC/JDBC

2014-07-28 Thread sai chaitanya tirumerla
Hi, We are connecting ODBC/JDBC tools to hiveserver2 using 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 ta