[jira] [Created] (DRILL-4343) UNSUPPORTED_OPERATION ERROR: This type of window frame is currently not supported See Apache Drill JIRA: DRILL-3188

2016-02-02 Thread Chun Chang (JIRA)
Chun Chang created DRILL-4343: - Summary: UNSUPPORTED_OPERATION ERROR: This type of window frame is currently not supported See Apache Drill JIRA: DRILL-3188 Key: DRILL-4343 URL:

[jira] [Created] (DRILL-4344) oadd.org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: NullPointerException

2016-02-02 Thread Chun Chang (JIRA)
Chun Chang created DRILL-4344: - Summary: oadd.org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: NullPointerException Key: DRILL-4344 URL: https://issues.apache.org/jira/browse/DRILL-4344

[GitHub] drill pull request: DRILL-4287: During initial DrillTable creation...

2016-02-02 Thread jinfengni
Github user jinfengni commented on the pull request: https://github.com/apache/drill/pull/345#issuecomment-178746517 Overall, looks good to me. +1 --- 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

[GitHub] drill pull request: DRILL-4287: During initial DrillTable creation...

2016-02-02 Thread jinfengni
Github user jinfengni commented on a diff in the pull request: https://github.com/apache/drill/pull/345#discussion_r51612792 --- Diff: exec/java-exec/src/main/java/org/apache/drill/exec/store/dfs/FileSelection.java --- @@ -118,13 +133,34 @@ public boolean apply(@Nullable

Hangout Starting

2016-02-02 Thread Jacques Nadeau
https://plus.google.com/hangouts/_/dremio.com/drillhangout?authuser=0 -- Jacques Nadeau CTO and Co-Founder, Dremio

[jira] [Resolved] (DRILL-4032) Drill unable to parse json files with schema changes

2016-02-02 Thread Jason Altekruse (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4032?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jason Altekruse resolved DRILL-4032. Resolution: Fixed Fix Version/s: 1.4.0 > Drill unable to parse json files with

[jira] [Resolved] (DRILL-4048) Parquet reader corrupts dictionary encoded binary columns

2016-02-02 Thread Jason Altekruse (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4048?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jason Altekruse resolved DRILL-4048. Resolution: Fixed Fix Version/s: 1.4.0 > Parquet reader corrupts dictionary encoded

[jira] [Resolved] (DRILL-4243) CTAS with partition by, results in Out Of Memory

2016-02-02 Thread Jason Altekruse (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4243?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jason Altekruse resolved DRILL-4243. Resolution: Fixed Fix Version/s: 1.5.0 > CTAS with partition by, results in Out Of

[jira] [Resolved] (DRILL-4328) Fix for backward compatibility regression caused by DRILL-4198

2016-02-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4328?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-4328. --- Resolution: Fixed Fixed in commit: 03197d0f2c665b7671b366332e1b4ebc2f271bd9 > Fix for backward

Re: setting session params in a rest request

2016-02-02 Thread Josh Schlesser
I have a background worker process (on a server, not a browser) that kicks off every minute or so and issues some queries sequentially to the rest query endpoint.In 1.4 with no authentication this worked fine except that in 1 instance I need to issue a CTAS query with a different format

[GitHub] drill pull request: DRILL-4323: When converting HiveParquetScan To...

2016-02-02 Thread hsuanyi
Github user hsuanyi commented on the pull request: https://github.com/apache/drill/pull/349#issuecomment-178900844 Rahul already verified it and this patch passed all the requested tests. --- If your project is set up for it, you can reply to this email and have your reply appear on

[jira] [Resolved] (DRILL-4163) Support schema changes for MergeJoin operator.

2016-02-02 Thread Jason Altekruse (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4163?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jason Altekruse resolved DRILL-4163. Resolution: Fixed Fix Version/s: 1.5.0 Fixed in

[jira] [Created] (DRILL-4345) Hive Native Reader reporting wrong results for timestamp column in hive generated parquet file

2016-02-02 Thread Rahul Challapalli (JIRA)
Rahul Challapalli created DRILL-4345: Summary: Hive Native Reader reporting wrong results for timestamp column in hive generated parquet file Key: DRILL-4345 URL:

Re: setting session params in a rest request

2016-02-02 Thread Venki Korukanti
When auth is *enabled*, is the worker process logging out after queries are done? When auth is *disabled* can you set session_max_idle_secs in drill.exec.http block in drill-override.conf to something like 30 (secs) and try? This way anonymous sessions are closed quickly and not kept for 1hr

[jira] [Resolved] (DRILL-4205) Simple query hit IndexOutOfBoundException

2016-02-02 Thread Jason Altekruse (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4205?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jason Altekruse resolved DRILL-4205. Resolution: Fixed Fix Version/s: 1.5.0 > Simple query hit IndexOutOfBoundException

[jira] [Resolved] (DRILL-4192) Dir0 and Dir1 from drill-1.4 are messed up

2016-02-02 Thread Jason Altekruse (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4192?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jason Altekruse resolved DRILL-4192. Resolution: Fixed Fix Version/s: 1.5.0 > Dir0 and Dir1 from drill-1.4 are messed up

[jira] [Resolved] (DRILL-4279) Improve performance for skipAll query against Text/JSON/Parquet table

2016-02-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4279?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-4279. --- Resolution: Fixed Fix Version/s: 1.6.0 Fixed in commit:

Re: Deterministic behavior of Negative Function?

2016-02-02 Thread Sean Hsuan-Yi Chu
@Jacques, it is Drill-2060 . @All, making the function properties non-deterministic also makes "partition pruning" not happening. This is one case we observed: Say, we have a negative function in the WHERE-CLAUSE. Since the property is claimed to be non-deterministic, partition pruning cannot take

How vectorization is implemented in Drill?

2016-02-02 Thread Jingguo Yao
[1] says: > Vectorization: Drill takes advantage of the latest SIMD instructions > available in modern processors. I have done a quick browse of the source code. The following list are the clues which may relate with vectorization: - Drill source use Arrays.fill, Arrays.copyOf and

[jira] [Created] (DRILL-4340) Tableau complains about the ODBC driver capabilities

2016-02-02 Thread Oscar Morante (JIRA)
Oscar Morante created DRILL-4340: Summary: Tableau complains about the ODBC driver capabilities Key: DRILL-4340 URL: https://issues.apache.org/jira/browse/DRILL-4340 Project: Apache Drill

[jira] [Created] (DRILL-4342) Drill fails to read a date column from hive generated parquet

2016-02-02 Thread Rahul Challapalli (JIRA)
Rahul Challapalli created DRILL-4342: Summary: Drill fails to read a date column from hive generated parquet Key: DRILL-4342 URL: https://issues.apache.org/jira/browse/DRILL-4342 Project: Apache

Re: setting session params in a rest request

2016-02-02 Thread Josh Schlesser
No, it wasn’t logging out, it was just stopping, obviously that caused dangling sessions for the authenticated scenario. I don’t think that a short timeout for anonymous sessions is a good way to go for anonymous api calls. Session management isn’t what anybody would expect when using a

Re: Deterministic behavior of Negative Function?

2016-02-02 Thread Jason Altekruse
I made this change. It was a bit of a hack to re-use the non-deterministic property as an indication if a function could be folded into a constant. If you look at the definition of that list of NON_REDUCIBLE_TYPES constant, explanations are given for why given types are included. The problem

project build fails -> drill-jdbc-all-1.5.0-SNAPSHOT.jar is outside the expected size range

2016-02-02 Thread Arina Yelchiyeva
Hi all! Just pulled recent changes from master (revision number 1b96174b1e5bafb13a873dd79f03467802d7c929) and mvn clean install -DskipTests failed with the following error: *[ERROR] Failed to execute goal org.apache.maven.plugins:maven-enforcer-plugin:1.3.1:enforce (enforce-jdbc-jar-compactness)

Re: setting session params in a rest request

2016-02-02 Thread Venki Korukanti
Currently we keep the DrillClient per session. All the state is in Server and DrillClient is the reference to reuse the state. DrillClient is automatically closed when the session expires (default value is 1hr after the last activity on session) or user explicitly logs out. I am trying to

[jira] [Created] (DRILL-4339) Avro Reader can not read records - Regression

2016-02-02 Thread JIRA
Stefán Baxter created DRILL-4339: Summary: Avro Reader can not read records - Regression Key: DRILL-4339 URL: https://issues.apache.org/jira/browse/DRILL-4339 Project: Apache Drill Issue

Re: Deterministic behavior of Negative Function?

2016-02-02 Thread Jason Altekruse
Thanks for the prompt reply Julian. I will open a Calcite JIRA to continue the discussion on, I was similarly confused about the semantics of these types of intervals and didn't want to reason through it when I was making these changes. It would be useful to discuss if this Drill concept has a

Re: Deterministic behavior of Negative Function?

2016-02-02 Thread Julian Hyde
I don’t recall interval literals being discussed on the Calcite list. We do support interval literals of the standard types (day-to-second or year-to-month) but we don’t support interval literals (or interval values) of month-to-day type. I think there’s a good reason that that kind of literal

Re: Deterministic behavior of Negative Function?

2016-02-02 Thread Zelaine Fong
What was the motivation for supporting intervals spanning month to day in Drill? As Julian has already noted, this isn't part of ANSI SQL, and that would explain why Jason wasn't able to find examples of this in other databases :). -- Zelaine On Tue, Feb 2, 2016 at 9:18 AM, Jason Altekruse

Re: setting session params in a rest request

2016-02-02 Thread Venki Korukanti
I think you made valid points. It makes sense to have session less REST calls in both auth enabled and disabled cases. In case of auth enabled: 1) Session-less calls can be authenticated using Basic auth (this was already asked on mailing list sometime back) as a start and move onto token based

Re: [VOTE] Release Apache Drill 1.5.0 RC0

2016-02-02 Thread Jason Altekruse
I tried running the tests on a linux machine (I prepared the candidate on a mac) to check for any cross-system issues and actually found a small bug I introduced with my POM changes right before the release candidate. I had thought I re-ran the tests after making the small build change, but I

RE: [jira] [Created] (DRILL-4294) InfoSchema is not returning column metadata if the query contains escape character

2016-02-02 Thread Sudip Mukherjee
Hi, Could you please advise if this is the correct way to fix the problem. Wanted to use Power BI with Drill and got into the below issue. https://github.com/apache/drill/commit/19886c11352cfa45bdb2da885a86e6500986e1e3 Thanks, Sudip -Original Message- From: Sudip Mukherjee (JIRA)

[jira] [Resolved] (DRILL-4339) Avro Reader can not read records - Regression

2016-02-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-4339. --- Resolution: Fixed Fixed in commit: 6a36a704bc139aa05deb3919e792f21b3fcd7794 > Avro Reader can not

[VOTE] Release Apache Drill 1.5.0 RC0

2016-02-02 Thread Jason Altekruse
Hello all, I'd like to propose the first release candidate (rc0) of Apache Drill, version 1.5.0. It covers a total of 54 resolved JIRAs [1]. Thanks to everyone who contributed to this release. The tarball artifacts are hosted at [2] and the maven artifacts are hosted at [3]. This release

Re: project build fails -> drill-jdbc-all-1.5.0-SNAPSHOT.jar is outside the expected size range

2016-02-02 Thread Jacques Nadeau
This is a bug in maven we haven't figured out yet how we're causing. Upgrading to Maven 3.3.x fixes it. On Feb 2, 2016 2:18 AM, "Arina Yelchiyeva" wrote: > Hi all! > > Just pulled recent changes from master (revision number > 1b96174b1e5bafb13a873dd79f03467802d7c929)

Re: Deterministic behavior of Negative Function?

2016-02-02 Thread Jacques Nadeau
What jira was this change added with? On Feb 1, 2016 11:42 PM, "Hsuan Yi Chu" wrote: > All the variants of Negative DrillFuncHolder are supposed to be > deterministic. However, when they are being registered > into DrillOperatorTable, there is a if-statement: > > >