[GitHub] drill pull request: DRILL-4539: Add support for Null Equality Join...

2016-04-14 Thread vkorukanti
Github user vkorukanti commented on the pull request: https://github.com/apache/drill/pull/462#issuecomment-210244225 It seems like mixed condition of EQUALS and IS NOT DISTINCT FROM in the same join condition can be supported few changes. Here are the WIP changes [1]. Need to test mo

[jira] [Created] (DRILL-4608) Csv with Headers reader is not case insensitive

2016-04-14 Thread Jacques Nadeau (JIRA)
Jacques Nadeau created DRILL-4608: - Summary: Csv with Headers reader is not case insensitive Key: DRILL-4608 URL: https://issues.apache.org/jira/browse/DRILL-4608 Project: Apache Drill Issue

[jira] [Created] (DRILL-4607) Add a split function that allows to separate string by a delimiter

2016-04-14 Thread Alicia Alvarez (JIRA)
Alicia Alvarez created DRILL-4607: - Summary: Add a split function that allows to separate string by a delimiter Key: DRILL-4607 URL: https://issues.apache.org/jira/browse/DRILL-4607 Project: Apache Dr

[jira] [Resolved] (DRILL-4564) Document start-up properties hierarchy

2016-04-14 Thread Bridget Bevens (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4564?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bridget Bevens resolved DRILL-4564. --- Resolution: Fixed Updated doc to reflect suggested changes. Added a documentation label to D

[GitHub] drill pull request: DRILL-4577: Construct a specific path for quer...

2016-04-14 Thread jacques-n
Github user jacques-n commented on the pull request: https://github.com/apache/drill/pull/461#issuecomment-210167874 Isn't 8 seconds still too long? Remember that the moment we connect Tableau, it will frequently (via the ODBC driver) run several information schema queries on nearly e

[GitHub] drill pull request: DRILL-4577: Construct a specific path for quer...

2016-04-14 Thread hsuanyi
Github user hsuanyi commented on the pull request: https://github.com/apache/drill/pull/461#issuecomment-210144139 In the background, Chun, Rahul and Jinfeng have done some experiments: 1. Functional-wise: If Hive uses storage-based impersonation, when a user does "Show Tables" on

[GitHub] drill pull request: DRILL-4258: Add threads, fragments, and querie...

2016-04-14 Thread sudheeshkatkam
Github user sudheeshkatkam commented on a diff in the pull request: https://github.com/apache/drill/pull/479#discussion_r59787703 --- Diff: exec/java-exec/src/main/java/org/apache/drill/exec/ops/ThreadStatCollector.java --- @@ -0,0 +1,124 @@ +/** + * Licensed to the Apache

[GitHub] drill pull request: DRILL-4258: Add threads, fragments, and querie...

2016-04-14 Thread StevenMPhillips
GitHub user StevenMPhillips opened a pull request: https://github.com/apache/drill/pull/479 DRILL-4258: Add threads, fragments, and queries system tables Here are the pojos that represent the data for the new system tables: ```java public static class FragmentInfo {

[GitHub] drill pull request: DRILL-4539: Add support for Null Equality Join...

2016-04-14 Thread amansinha100
Github user amansinha100 commented on the pull request: https://github.com/apache/drill/pull/462#issuecomment-210085324 I think additional support may be needed; the hash table only stores the equality join keys, so the generated code in ChainedHashTable is targeted to the those colum

[GitHub] drill pull request: DRILL-4581: Minor fixes to drill startup scrip...

2016-04-14 Thread paul-rogers
GitHub user paul-rogers opened a pull request: https://github.com/apache/drill/pull/478 DRILL-4581: Minor fixes to drill startup scripts for linux This pull request replaces a previous one. No code differences; this one resolves some git issues. Provides fixes to a number o

[GitHub] drill pull request: Drill 4581

2016-04-14 Thread paul-rogers
Github user paul-rogers closed the pull request at: https://github.com/apache/drill/pull/477 --- 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, or if the feature is

[GitHub] drill pull request: Drill 4581

2016-04-14 Thread paul-rogers
Github user paul-rogers commented on the pull request: https://github.com/apache/drill/pull/477#issuecomment-210070503 Closing this request due to some newbie Git errors. Will open a new one in proper format. --- If your project is set up for it, you can reply to this email and have

Wrong result in select with multiple identical UDF call

2016-04-14 Thread François Méthot
I was able to reproduce this on 1.5 running on a cluster and on 1.6 in embedded mode. Within a single select, if I select the same udf(value) multiple time, different result may get outputted for each columns. ex: select name, ilike(name, 'jack'), ilike(name, 'jack'), ilike(name, 'jack'), ilike(n

[GitHub] drill pull request: DRILL-4539: Add support for Null Equality Join...

2016-04-14 Thread vkorukanti
Github user vkorukanti commented on the pull request: https://github.com/apache/drill/pull/462#issuecomment-210056992 I haven't tried this, but wondering whether this is sufficient to handle mix of EQUALS and IS NOT DISTINCT FROM cases. Maintain a list (one for each join condition) i

[GitHub] drill pull request: DRILL-4539: Add support for Null Equality Join...

2016-04-14 Thread amansinha100
Github user amansinha100 commented on the pull request: https://github.com/apache/drill/pull/462#issuecomment-210047513 Right, the HashJoin and MergeJoin currently can handle one type of comparison, not mixed...this is why when we have a join condition such as t1.a1 = t2.a2 AND t2.b

[GitHub] drill pull request: DRILL-4571: Add link to local Drill logs from ...

2016-04-14 Thread arina-ielchiieva
Github user arina-ielchiieva commented on a diff in the pull request: https://github.com/apache/drill/pull/472#discussion_r59694227 --- Diff: exec/java-exec/src/main/java/org/apache/drill/exec/ExecConstants.java --- @@ -303,4 +303,9 @@ StringValidator IMPERSONATION_POLICY_VA

[GitHub] drill pull request: DRILL-4539: Add support for Null Equality Join...

2016-04-14 Thread vkorukanti
Github user vkorukanti commented on the pull request: https://github.com/apache/drill/pull/462#issuecomment-209836956 Added few more tests: ```SELECT * FROM t1, t2, t3 WHERE t1.a = t2.a OR (t1.b is null and t3.b is null)``` to test it throws CannotPlanException ```SELECT * FROM