Re: Slow query on parquet imported from SQL Server while the external SQL server is down.

2016-11-29 Thread Abhishek Girish
Can you attempt to disable to jdbc plugin (configured with SQLServer) and try the query (on parquet) when SQL Server is offline? I've seen a similar issue previously when the HBase / Hive plugin was enabled but either the plugin configuration was wrong or the underlying data source was down. On

Re: Sql Server Query taking long time to run

2016-11-29 Thread Abhishek Girish
Have you tried using the JDBC plugin before with other data sources and seen anything similar from your setup? Also with SQL Server, have you tried with a prior version of Drill and still hit the issue? Can you create a simple table on SQL Server with just a few rows and attempt to query the same

Re: Last Column showing blank in csv file

2016-11-29 Thread Abhishek Girish
Like Khurram, I'm also not able to reproduce this issue. My format plugin is defined as follows: "csv": { "type": "text", "extensions": [ "csv" ], "extractHeader": true, "delimiter": "," } Query: > select * from `tmp.csv`;

Re: Last Column showing blank in csv file

2016-11-29 Thread Sanjiv Kumar
I am using latest version 1.8 and in window 10 operating system. On Tue, Nov 29, 2016 at 11:40 AM, Sanjiv Kumar wrote: > I already pasted the csv file. Just copy and save it as csv. I am also > attaching csv file. And the query is same as i mention above. > > select

Re: [ANNOUNCE] Apache Drill 1.9.0 Released

2016-11-29 Thread Abhishek Girish
Congrats all! I'd like to mention that the 1.9.0 release also includes the MapR format plugin, to read MapR-DB Binary and JSON Tables. On Tue, Nov 29, 2016 at 3:52 PM, Sudheesh Katkam wrote: > On behalf of the Apache Drill community, I am happy to announce the release > of

[ANNOUNCE] Apache Drill 1.9.0 Released

2016-11-29 Thread Sudheesh Katkam
On behalf of the Apache Drill community, I am happy to announce the release of Apache Drill 1.9.0. For information about Apache Drill, and to get involved, visit the project website: https://drill.apache.org/ This release introduces new features and enhancements, including asynchronous Parquet

Re: Last Column showing blank in csv file

2016-11-29 Thread Khurram Faraaz
Thanks. What version of Drill are you using ? And is this on Linux ? On Tue, Nov 29, 2016 at 11:40 AM, Sanjiv Kumar wrote: > I already pasted the csv file. Just copy and save it as csv. I am also > attaching csv file. And the query is same as i mention above. > > select