RE: using "SET" with JDBC

2014-11-26 Thread Guy Doulberg
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

Re: using "SET" with JDBC

2014-11-25 Thread Karthik Banala
> > 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:

RE: using "SET" with JDBC

2014-11-25 Thread Guy Doulberg
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

Re: using "SET" with JDBC

2014-11-25 Thread Karthik Banala
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