RE: question on failed unit test (in protobuf)

2016-08-11 Thread Dave Oshinsky
Jinfeng, Not initially, but I figured out how to correct the inconsistent protocols yesterday (manually ran protoc on *.proto, after seeing other *.proto include Types.proto, and an uncaught and un-logged class load exception under debugger after Drill just hung running a SQL select). I'm now

Re: Performance question

2016-08-11 Thread Zelaine Fong
What does the query plan look like when you're using SqlServer with Drill? I'm guessing that the join isn't being pushed down to SqlServer. If so, you've hit DRILL-4818. There are known limitations with the JDBC storage plugin that prevent it from generating the optimal query plan in cases like

Performance question

2016-08-11 Thread imbar marinescu
Hi, I'm looking into drill, to use it as an in memory db. I wanted to handle data that I have in a Sql Server db. I connected with an Sql Server jdbc plug in, and my test query ran for about 2 sec. When running directly from Sql Server it took 0.15 sec. I ran a "create table" as a parquet file

[GitHub] drill issue #566: DRILL-4833: Insert exchanges on the inputs of union-all su...

2016-08-11 Thread jinfengni
Github user jinfengni commented on the issue: https://github.com/apache/drill/pull/566 +1 LGTM. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so,

UDF returning boolean?

2016-08-11 Thread Charles Givre
Hello all, Is it possible for a UDF to return a boolean value, or are we stuck with using the BitHolder and returning 0/1? Thanks, — C

RE: question on failed unit test (in protobuf)

2016-08-11 Thread Dave Oshinsky
Jinfeng, My build node has no readme in the folder with *.proto (protocol/src/main/protobuf). However, there's a readme.txt 3 levels up in "protocol", which I did not notice because I ran protoc manually (using Cygwin shell) in protocol/src/main/protobuf. IDEA debugger did help me to see the

Re: question on failed unit test (in protobuf)

2016-08-11 Thread Jinfeng Ni
For IDEA debugger, I just tried with one sample query, and it did stop in MaterializeVisitor. One thing you may check is to make sure the expression passed to this visitor does have the expression matches the breakpoint ( if you set a breakpoint in visitFunctionCall(), then the expression should

[jira] [Created] (DRILL-4843) Trailing spaces in CSV column headers cause IndexOutOfBoundsException

2016-08-11 Thread Matt Keranen (JIRA)
Matt Keranen created DRILL-4843: --- Summary: Trailing spaces in CSV column headers cause IndexOutOfBoundsException Key: DRILL-4843 URL: https://issues.apache.org/jira/browse/DRILL-4843 Project: Apache

Re: [VOTE] Release Apache Drill 1.8.0 - rc0

2016-08-11 Thread Zelaine Fong
+1 (non-binding) Downloaded build Ran some ad-hoc queries Verified a random bug fixed in the release (DRILL-3149) -- Zelaine On Wed, Aug 10, 2016 at 10:58 PM, Aman Sinha wrote: > +1 (binding) > Downloaded source as well as binary tarballs. > Checked git.properties and

The project says it has dozens of committers

2016-08-11 Thread Michael Lazar
You say you have “dozens of committers”. A dozen is 12. You have 21 names on the list. That is not even 2 dozen. Seems to be a math error to me. Michael Lazar, Sr Sales Engineer 301 202 4084 [image: http://files.cloudera.com.s3.amazonaws.com/email-imgs/2016/hadoop10.png] Cloudera

Re: The project says it has dozens of committers

2016-08-11 Thread Jason Altekruse
I believe the page you are referring to is our "Team" page available here [1]. The page does not say we have dozens of comitters, it says contributors, who we currently don't credit on this page, but whose contributions are tracked through JIRA and git. If you look at the github mirror of our repo

Re: Performance question

2016-08-11 Thread imbar marinescu
I also checked on Microsoft Tabular, and the same query came back within 0.01 sec. That is amazing! 2016-08-11 19:22 GMT+03:00 imbar marinescu : > Hi, > > I'm looking into drill, to use it as an in memory db. > I wanted to handle data that I have in a Sql Server db. > I