[GitHub] drill pull request: DRILL-4551: Implement new functions (cot, rege...

2016-03-30 Thread jinfengni
Github user jinfengni commented on the pull request: https://github.com/apache/drill/pull/452#issuecomment-203744127 Other than one comment, look 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 wel

[GitHub] drill pull request: DRILL-4551: Implement new functions (cot, rege...

2016-03-30 Thread jinfengni
Github user jinfengni commented on a diff in the pull request: https://github.com/apache/drill/pull/452#discussion_r57998932 --- Diff: exec/java-exec/src/main/java/org/apache/drill/exec/expr/fn/impl/DateTypeFunctions.java --- @@ -40,6 +42,41 @@ public class DateTypeFunc

[GitHub] drill pull request: DRILL-4237 DRILL-4478 fully implement hash to ...

2016-03-30 Thread jacques-n
Github user jacques-n commented on the pull request: https://github.com/apache/drill/pull/430#issuecomment-203726680 Did you consider leveraging this library: https://github.com/OpenHFT/Zero-Allocation-Hashing --- If your project is set up for it, you can reply to this email

Remove HBasePersistentStoreProvider

2016-03-30 Thread Aditya
Folks, I have created DRILL-4567[1] to potentially remove HBasePersistentStoreProvider in 1.7 release. This thread is to see if there is any user using it in their environment. aditya... [1] https://issues.apache.org/jira/browse/DRILL-4567

[jira] [Created] (DRILL-4567) Remove HBase HBasePersistentStoreProvider

2016-03-30 Thread Aditya Kishore (JIRA)
Aditya Kishore created DRILL-4567: - Summary: Remove HBase HBasePersistentStoreProvider Key: DRILL-4567 URL: https://issues.apache.org/jira/browse/DRILL-4567 Project: Apache Drill Issue Type:

[GitHub] drill pull request: DRILL-4199: Add Support for HBase 1.X

2016-03-30 Thread adityakishore
Github user adityakishore commented on the pull request: https://github.com/apache/drill/pull/443#issuecomment-203699506 The latest patch, 1684daa5a081e1ae7d6d66cb5ee5e2f88015fc53, takes care of HBase connection life-cycle management within the plugin's life-cycle. --- If your projec

[GitHub] drill pull request: DRILL-4521: Map variance() and stddev() to var...

2016-03-30 Thread StevenMPhillips
Github user StevenMPhillips commented on the pull request: https://github.com/apache/drill/pull/437#issuecomment-203657641 +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 project does not have this feature enab

[GitHub] drill pull request: DRILL-4551: Implement new functions (cot, rege...

2016-03-30 Thread jaltekruse
Github user jaltekruse commented on the pull request: https://github.com/apache/drill/pull/452#issuecomment-203637282 Addressed both comments, @jinfengni can you take another look? --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub a

Re: REPEATED_CONTAINS

2016-03-30 Thread Jean-Claude Cote
Hey Jacques, I have done some rudimentary tests and realized my use case is a bit more complicated then stated above. {"name":"classic","fillings":[ {"name":"sugar","cal":500} , {"name":"flour","cal":300} ] } SELECT a,b,c,d,e,f,g, max(suggar_val) FROM ( SELECT a,b,c,d,e,f,g, case when fill['name

[GitHub] drill pull request: DRILL-4566: TDigest, median, and quantile func...

2016-03-30 Thread StevenMPhillips
GitHub user StevenMPhillips opened a pull request: https://github.com/apache/drill/pull/456 DRILL-4566: TDigest, median, and quantile functions Adds tdigest, tdigest_merge, median, and quantile UDFS Adds reduce aggregates rule to reduce: median(x) -> tdigest_median(tdigest(

[jira] [Created] (DRILL-4566) Add TDigest functions for computing median and quantile

2016-03-30 Thread Steven Phillips (JIRA)
Steven Phillips created DRILL-4566: -- Summary: Add TDigest functions for computing median and quantile Key: DRILL-4566 URL: https://issues.apache.org/jira/browse/DRILL-4566 Project: Apache Drill

[jira] [Created] (DRILL-4565) Document entire set of Drill config properties including default values

2016-03-30 Thread Paul Rogers (JIRA)
Paul Rogers created DRILL-4565: -- Summary: Document entire set of Drill config properties including default values Key: DRILL-4565 URL: https://issues.apache.org/jira/browse/DRILL-4565 Project: Apache Dri

[jira] [Created] (DRILL-4564) Add documentation detail regarding start-up properties hierarchy

2016-03-30 Thread Paul Rogers (JIRA)
Paul Rogers created DRILL-4564: -- Summary: Add documentation detail regarding start-up properties hierarchy Key: DRILL-4564 URL: https://issues.apache.org/jira/browse/DRILL-4564 Project: Apache Drill

[jira] [Created] (DRILL-4563) Add HOCON reference to Drill docs

2016-03-30 Thread Paul Rogers (JIRA)
Paul Rogers created DRILL-4563: -- Summary: Add HOCON reference to Drill docs Key: DRILL-4563 URL: https://issues.apache.org/jira/browse/DRILL-4563 Project: Apache Drill Issue Type: Improvement

[GitHub] drill pull request: DRILL-2100: Added deleting temporary spill dir...

2016-03-30 Thread jaltekruse
Github user jaltekruse commented on a diff in the pull request: https://github.com/apache/drill/pull/454#discussion_r57955905 --- Diff: exec/java-exec/src/main/java/org/apache/drill/exec/physical/impl/xsort/ExternalSortBatch.java --- @@ -110,11 +111,12 @@ private LinkedList

[GitHub] drill pull request: DRILL-4562: Fix bug with nested union expressi...

2016-03-30 Thread StevenMPhillips
GitHub user StevenMPhillips opened a pull request: https://github.com/apache/drill/pull/455 DRILL-4562: Fix bug with nested union expressions You can merge this pull request into a Git repository by running: $ git pull https://github.com/StevenMPhillips/drill drill-4562 Alter

[jira] [Created] (DRILL-4562) NPE when evaluating expression on nested union type

2016-03-30 Thread Steven Phillips (JIRA)
Steven Phillips created DRILL-4562: -- Summary: NPE when evaluating expression on nested union type Key: DRILL-4562 URL: https://issues.apache.org/jira/browse/DRILL-4562 Project: Apache Drill

[jira] [Created] (DRILL-4561) Rationalize jar structure to minimize client dependencies

2016-03-30 Thread Paul Rogers (JIRA)
Paul Rogers created DRILL-4561: -- Summary: Rationalize jar structure to minimize client dependencies Key: DRILL-4561 URL: https://issues.apache.org/jira/browse/DRILL-4561 Project: Apache Drill I

[jira] [Created] (DRILL-4560) ZKClusterCoordinator does not call DrillbitStatusListener.drillbitRegistered for new bits

2016-03-30 Thread Paul Rogers (JIRA)
Paul Rogers created DRILL-4560: -- Summary: ZKClusterCoordinator does not call DrillbitStatusListener.drillbitRegistered for new bits Key: DRILL-4560 URL: https://issues.apache.org/jira/browse/DRILL-4560 P

[GitHub] drill pull request: DRILL-4551: Implement new functions (cot, rege...

2016-03-30 Thread jaltekruse
Github user jaltekruse commented on a diff in the pull request: https://github.com/apache/drill/pull/452#discussion_r57943477 --- Diff: exec/java-exec/src/main/java/org/apache/drill/exec/expr/fn/impl/StringFunctionHelpers.java --- @@ -213,11 +213,39 @@ public static long getDate(D

[GitHub] drill pull request: DRILL-4551: Implement new functions (cot, rege...

2016-03-30 Thread jaltekruse
Github user jaltekruse commented on a diff in the pull request: https://github.com/apache/drill/pull/452#discussion_r57942687 --- Diff: exec/java-exec/src/main/java/org/apache/drill/exec/expr/fn/impl/DateTypeFunctions.java --- @@ -40,6 +41,36 @@ public class DateTypeFun

[GitHub] drill pull request: DRILL-4514 : Add describe schema ...

2016-03-30 Thread arina-ielchiieva
Github user arina-ielchiieva commented on the pull request: https://github.com/apache/drill/pull/436#issuecomment-203501750 @hnfgns, @jacques-n Could you please review this pull request? --- If your project is set up for it, you can reply to this email and have your reply appear

[GitHub] drill pull request: DRILL-4529: Force $SUM0 to be used when Window...

2016-03-30 Thread jinfengni
Github user jinfengni commented on the pull request: https://github.com/apache/drill/pull/447#issuecomment-203461091 Since we have use same approach for regular sum() aggregate, it makes sense to apply to window sum() aggregate function. LGTM +1. --- If your projec

Re: Aggregation OutOfMemoryException

2016-03-30 Thread François Méthot
Thank you Abdel, After following your recommendation, our query actually went through. From the Fragments Profiles Overview in the Web UI, we saw that after 2 days of processing, a thread was still doing some work. We let it on for another 3 days. Nothing was happening, then we hit ctrl-c from t

[GitHub] drill pull request: DRILL-2100: Added deleting temporary spill dir...

2016-03-30 Thread vdiravka
GitHub user vdiravka opened a pull request: https://github.com/apache/drill/pull/454 DRILL-2100: Added deleting temporary spill directories when query is … …finished. You can merge this pull request into a Git repository by running: $ git pull https://github.com/vdiravka/dr

[jira] [Created] (DRILL-4559) Re-work DESCRIBE command after moving to Calcite master branch

2016-03-30 Thread Arina Ielchiieva (JIRA)
Arina Ielchiieva created DRILL-4559: --- Summary: Re-work DESCRIBE command after moving to Calcite master branch Key: DRILL-4559 URL: https://issues.apache.org/jira/browse/DRILL-4559 Project: Apache Dr

[GitHub] drill pull request: DRILL-4514 : Add describe schema ...

2016-03-30 Thread arina-ielchiieva
Github user arina-ielchiieva commented on the pull request: https://github.com/apache/drill/pull/436#issuecomment-203372453 Comment from Jacques - Let's open a follow-up bug to move this to Calcite and get in Drill for now (was accidentally added to https://github.com/apache/drill/pul

[GitHub] drill pull request: DRILL-4544: Improve error messages for REFRESH...

2016-03-30 Thread arina-ielchiieva
Github user arina-ielchiieva commented on the pull request: https://github.com/apache/drill/pull/448#issuecomment-203372090 Comment from Jacques was meant for https://github.com/apache/drill/pull/436 (DRILL-4514: Add describe schema command), sorry for confusion. --- If your project

[jira] [Created] (DRILL-4558) When a query returns diacritics in a string, the string is cut

2016-03-30 Thread Vincent Uribe (JIRA)
Vincent Uribe created DRILL-4558: Summary: When a query returns diacritics in a string, the string is cut Key: DRILL-4558 URL: https://issues.apache.org/jira/browse/DRILL-4558 Project: Apache Drill