Re: Drill session and jdbc connections

2017-12-14 Thread Prasad Nagaraj Subramanya
The code looks good. To keep things simple you can call *reset `option_name`* for all options which you change during the session. (that way you need not be concerned with the default value) So, your finally block will look like - finally{ st.executeQuery("RESET `store.format`"); }

Re: Drill Capacity

2017-11-02 Thread Prasad Nagaraj Subramanya
Hi Yun, Drill is designed to query large datasets. There is no specific limit on the size, it works well even when data is in hundreds of GBs. DATA_READ ERROR has something to do with the data in your file. The data in some of the columns may not be consistent with the datatype. Please refer to t