RE: Drill error with large sort

2016-02-26 Thread Paul Friedman
Thanks for this, these parameters fixed it! ---Paul -Original Message- From: Abdel Hakim Deneche [mailto:adene...@maprtech.com] Sent: Thursday, February 25, 2016 5:32 PM To: user Subject: Re: Drill error with large sort Not so short answer: In Drill 1.5 (I

extractHeader in session variable?

2016-02-26 Thread Christopher Matta
Is it possible to set the extractHeader option for CSV/TSV in a session variable? Doing it on the format type is just too broad sometimes and I'd like to be able to set it based on the files I'm querying. Chris Matta cma...@mapr.com 215-701-3146

Re: Avro support in Drill - Missing support for the IN operator and other frustrating things

2016-02-26 Thread Jason Altekruse
Stefan, I'm sorry that we have not been better about getting back to the issues you have filed against the Avro reader. We do appreciate all of the effort you have put into filing thorough bugs and being active in the discussions on the list. I have responded on the bug you filed on this issue

Re: The praises for Drill

2016-02-26 Thread Abdel Hakim Deneche
Looking forward to reading the paper! On Fri, Feb 26, 2016 at 10:19 AM, Parth Chandra wrote: > Welcome back Edmon, and thanks for the praise :). Hope to see you on the > next hangout. > > On Thu, Feb 25, 2016 at 7:27 PM, Edmon Begoli wrote: > > > Hello

Re: The praises for Drill

2016-02-26 Thread Parth Chandra
Welcome back Edmon, and thanks for the praise :). Hope to see you on the next hangout. On Thu, Feb 25, 2016 at 7:27 PM, Edmon Begoli wrote: > Hello fellow Driilers, > > I have been inactive on the development side of the project, as we got busy > being heavy/power users of

Re: Question Regarding How to search excel file using drill.

2016-02-26 Thread Rajkumar Singh
-Sanjeev This can help you to setup drill with MS excel using Drill-ODBC. http://rajkrrsingh.blogspot.in/2015/11/apache-drill-run-query-through.html > On Feb 26, 2016, at 10:12 PM, Andries Engelbrecht

Re: Question Regarding How to search excel file using drill.

2016-02-26 Thread Andries Engelbrecht
You can use the Drill ODBC driver, and then query Drill using MS Query or the same way you would query another DB engine through an ODBC DSN. --Andries > On Feb 26, 2016, at 2:09 AM, Sanjiv Kumar C wrote: > > Hello > I want to know how to query from excel file(.xslx)

Question Regarding How to search excel file using drill.

2016-02-26 Thread Sanjiv Kumar C
Hello I want to know how to query from excel file(.xslx) and ms access file using drill. -- Thanks & Regards * Sanjiv Kumar*