RE: Drill session and jdbc connections

2017-12-13 Thread Kunal Khatua
That will (IMO) not solve the problem, since different threads will be setting and resetting the store format. My suggestion would be to use a pool of connections and each thread work off one connection, and returning it to the pool when done resetting. -Original Message- From: Rahul R

Re: Drill session and jdbc connections

2017-12-13 Thread Rahul Raj
We are using a one connection and multiple statements for creating the CSV files. I will surround the calls with a finally to reset the store format. Thanks for your inputs, Regards, Rahul On Wed, Dec 13, 2017 at 10:59 PM, Kunal Khatua wrote: > A Drill session is isolated and bound to a connec

Illegal Argument Exception while convert unix date format to drill timestamp

2017-12-13 Thread Divya Gehlot
Hi, Does Drill supprts to convert Unix date format to Drill timstamp ? Unix TimeStamp : Thu Dec 14 03:40:50 UTC 2017 When I Cast to Drill time stamp I get Illegal Argument Exception. Thanks, Divya

Issue with time zone

2017-12-13 Thread Kostyantyn Krakovych
Hi Team, I faced with the issue described in http://www.openkb.info/2015/05/understanding-drills-timestamp-and.html Drill 1.11 I run sqlline -u jdbc:drill:zk=local on local computer. Meantime I do not see user.timestamp o

RE: Drill session and jdbc connections

2017-12-13 Thread Kunal Khatua
A Drill session is isolated and bound to a connection. Your 'getConnection()' method might be fetching connections from a pool, where the settings haven't been reset. If the connections are shared, you will continue to have this problem. If you are returning a connection back to the pool, run t

Drill session and jdbc connections

2017-12-13 Thread Rahul Raj
Hi, How is a drill session related to a drill jdbc connection instance? What happens in a pool of connections when one connection changes the store.format? I am seeing some mix-ups where a parquet row is written as an array of multiple records(rather than multiple columns) when another thread trie