Option 1, is not good for me,
I specify the connection string once for many statements
From: Karthik Banala [mailto:karthikban...@gmail.com]
Sent: Tuesday, November 25, 2014 6:32 PM
To: user@hive.apache.org
Subject: Re: using "SET" with JDBC
You're right , Missed it We do
>
> Isn’t the second is actually what I am doing?
>
>
>
> I tried to remove the “SET” keyword and got sql exception.
>
>
>
>
>
>
>
> *From:* Karthik Banala [mailto:karthikban...@gmail.com
> ]
> *Sent:* Tuesday, November 25, 2014 5:03 PM
> *To:
Thanks
Isn’t the second is actually what I am doing?
I tried to remove the “SET” keyword and got sql exception.
From: Karthik Banala [mailto:karthikban...@gmail.com]
Sent: Tuesday, November 25, 2014 5:03 PM
To: user@hive.apache.org
Subject: Re: using "SET" with JDBC
Hi ,
Two way
Hi ,
Two ways of doing it -
1. You can specify the configuration parameter in the JDBC URL while
establishing the connection
jdbc:hive2://*serverName*:*port*?hive.exec.dynamic.partition.mode=nonstrict
;
2. Using statement/prepared statement
ps.execute("hive.exec.dynamic.p