Re: Wrong results on repeated DATE_ADD

2017-03-09 Thread Rahul Raj
Create DRILL-5343 On Thu, Mar 9, 2017 at 9:08 PM, Aman Sinha wrote: > Thanks for detecting this. Odd that it works for Day but not for minute > intervals. Can you pls file a JIRA ? > > -Aman > > On 3/9/17, 5:59 AM, "Rahul Raj" wrote: > > Hi, > > On Drill 1.9, DATE_ADD(DATE_ADD ...) re

Re: [Drill 1.9.0] : [CONNECTION ERROR] :- (user client) closed unexpectedly. Drillbit down?

2017-03-09 Thread Anup Tiwari
Hi John, First of all sorry for delayed response and thanks for your suggestion, reducing value of "planner.width.max_per_node" helped me a lot, above issue which was coming 8 out of 10 times earlier now it is coming only 2 out of 10 times. As mentioned above occurrences of connection error came

Re: Query on .gz.parquet files

2017-03-09 Thread Kunal Khatua
Is this a Parquet file? It looks more like a JSON document. What is the schema description published by the parquet-tools? From: PROJJWAL SAHA Sent: Thursday, March 9, 2017 4:36:06 AM To: user@drill.apache.org Subject: Query on .gz.parquet files All, one ques

Re: Minimise query plan time for dfs plugin for local file system on tsv file

2017-03-09 Thread Zelaine Fong
I believe Chunhui has a fix for DRILL-5089 but is waiting on the Calcite portions of the fix to be accepted. -- Zelaine On 3/9/17, 7:47 AM, "Jinfeng Ni" wrote: DRILL-5089 has hit many drill users for very long time; it was reported several times on this drill user list. It would make s

Re: Minimise query plan time for dfs plugin for local file system on tsv file

2017-03-09 Thread Jinfeng Ni
DRILL-5089 has hit many drill users for very long time; it was reported several times on this drill user list. It would make sense to bump it's priority and get it fixed in the next Drill release. On Wed, Mar 8, 2017 at 8:45 AM, Zelaine Fong wrote: > The slowness you’re seeing when you have addi

Re: Wrong results on repeated DATE_ADD

2017-03-09 Thread Aman Sinha
Thanks for detecting this. Odd that it works for Day but not for minute intervals. Can you pls file a JIRA ? -Aman On 3/9/17, 5:59 AM, "Rahul Raj" wrote: Hi, On Drill 1.9, DATE_ADD(DATE_ADD ...) results in the inner most value getting added up N times. Its seen on MINUTE/S

Wrong results on repeated DATE_ADD

2017-03-09 Thread Rahul Raj
Hi, On Drill 1.9, DATE_ADD(DATE_ADD ...) results in the inner most value getting added up N times. Its seen on MINUTE/SECOND/HOUR interval values, It works fine on DAY interval See the results below; I have trimmed the sqlline results for brevity. SELECT DATE_ADD(TIME '12:23:34',INTERVAL '1' mi

Query on .gz.parquet files

2017-03-09 Thread PROJJWAL SAHA
All, one question i am querying on .gz.parquet files. select * from xxx returns data like +-+ | current | +-+ | {"vendor_id":"VTS","pickup_datetime":"ACj75+tEAAAvfSUA","payment_type":"CSH","fare_amount":12.0,"mta_tax":0.5,"tip_amount":0.0,"tolls_amount":5.33,"total_amount":18.33,"r