Regarding Apache Drill 1.7 Version Release Date

2016-05-24 Thread Sanjiv Kumar
Hello Would you please tell me when Apache Drill 1.7 Version will going to release?. .. Thanks & Regards Sanjiv Kumar

Re: Custom Authenticator in Window Operating System.

2016-05-24 Thread Sanjiv Kumar
Hello I want to know that what are the required classes and jar files for compiling java file in window environment for custom authentiaction. OR How I will create Custom Authentication in Window. .. Thanks & Regards *Sanjiv Kumar*

Re: Performance tuning for TPC-H Q1 on a three nodes cluster

2016-05-24 Thread Dechang Gu
Hi Yijie, Thanks for the profile. Looks like from the Operator Profile overview, 03-xx-02 HASH_AGGREGATE and 03-xx-06 PARQUET_ROW_GROUP_SCAN took the most of time: 03-xx-02HASH_AGGREGATE 0.020s 0.083s 0.213s 1m06s 1m55s 3m12s 0.000s 0.000s 0.000s 16MB16MB 03-xx-03

Re: "user" as a reserved word

2016-05-24 Thread Jinfeng Ni
@John, I agree with what you suggested. The behavior on Postgres makes more sense. The issue is in Apache Calcite, the sql planner Drill that uses. I post this question on Calcite dev list. The fix would be in Calcite code. On Tue, May 24, 2016 at 8:01 AM, Zelaine Fong

Re: "user" as a reserved word

2016-05-24 Thread Zelaine Fong
I agree that this is a bug, as you've already noted via DRILL-4692. Putting backticks around USER should treat it as an identifier, not a reserved word or special function. Based on Jinfeng's findings, it looks like Drill puts special function names in the same namespace as identifiers, resulting

Re: "user" as a reserved word

2016-05-24 Thread John Omernik
I think if there is any change that one of the interpretations could be to allow `user` (backtick user backtick) that we should do that... Drill uses backticks as the quoted identifier (I gather Postgres uses double quotes as it's identifier) having user be the column name will same many