Re: Hash Aggregate Memory usage

2016-05-25 Thread rahul challapalli
Its using hash aggregation. On May 25, 2016 7:48 PM, "Zelaine Fong" wrote: > What does the explain plan show? I.e., is the group by being done via a > hash agg or a streaming agg? If it's a streaming agg, then you still have > to sort the entire data set before you reduce

Re: Hash Aggregate Memory usage

2016-05-25 Thread Zelaine Fong
Oops, my bad. I just noticed you did indicate that the query plan shows usage of a hash agg. -- Zelaine On Wed, May 25, 2016 at 7:48 PM, Zelaine Fong wrote: > What does the explain plan show? I.e., is the group by being done via a > hash agg or a streaming agg? If it's a

Re: Hash Aggregate Memory usage

2016-05-25 Thread Zelaine Fong
What does the explain plan show? I.e., is the group by being done via a hash agg or a streaming agg? If it's a streaming agg, then you still have to sort the entire data set before you reduce it down to a single group. That would explain the increase in memory as you add group by keys. --

Re: Manta Object Store Support

2016-05-25 Thread Elijah Zupancic
Hi Tomer, Thanks for your advice about creating a Hadoop FileSystem implementation. I just finished a prototypical implementation of a Hadoop file system for Manta: https://github.com/dekobon/hadoop-manta I see the example for enabling S3 with Apache

[GitHub] drill pull request: DRILL-4693: Ensure final column re-ordering is...

2016-05-25 Thread asfgit
Github user asfgit closed the pull request at: https://github.com/apache/drill/pull/508 --- 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-4693: Ensure final column re-ordering is...

2016-05-25 Thread amansinha100
Github user amansinha100 commented on a diff in the pull request: https://github.com/apache/drill/pull/508#discussion_r64677891 --- Diff: exec/java-exec/src/main/java/org/apache/drill/exec/planner/physical/ProjectPrel.java --- @@ -81,6 +83,18 @@ public SelectionVectorMode

[GitHub] drill pull request: DRILL-4693: Ensure final column re-ordering is...

2016-05-25 Thread jinfengni
Github user jinfengni commented on the pull request: https://github.com/apache/drill/pull/508#issuecomment-221749835 LGGM. +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

Re: [ANNOUNCE] New PMC Chair of Apache Drill

2016-05-25 Thread Parth Chandra
Thanks everyone, and in particular, thank you, Jacques, for making Drill possible. On Wed, May 25, 2016 at 3:31 PM, Chunhui Shi wrote: > Big congratulations to Parth! > Thanks Jacques for founding Drill project and way to go drillers! > > Chunhui > > On Wed, May 25, 2016 at

[GitHub] drill pull request: DRILL-4693: Ensure final column re-ordering is...

2016-05-25 Thread amansinha100
Github user amansinha100 commented on the pull request: https://github.com/apache/drill/pull/508#issuecomment-221746191 @jinfengni could you pls review ? --- 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

[GitHub] drill pull request: DRILL-4693: Ensure final column re-ordering is...

2016-05-25 Thread amansinha100
GitHub user amansinha100 opened a pull request: https://github.com/apache/drill/pull/508 DRILL-4693: Ensure final column re-ordering is done if any select li… …st expression is convert_fromjson. You can merge this pull request into a Git repository by running: $ git pull

Issue with Drill installation

2016-05-25 Thread Doddi, Lakshmi
Hi, I am trying to install apache drill 1.6 on windows 7 laptop. This is how my drill-override.conf looks like : drill.exec: { cluster-id: "drillbits1", zk.connect: "localhost:2181", sys.store.provider.local.path="C:/data/drill" } When I issue the command I see the below error and I am

Re: [ANNOUNCE] New PMC Chair of Apache Drill

2016-05-25 Thread Chunhui Shi
Big congratulations to Parth! Thanks Jacques for founding Drill project and way to go drillers! Chunhui On Wed, May 25, 2016 at 11:45 AM, John Omernik wrote: > Congratz Parth, and thank you Jacques! > > On Wed, May 25, 2016 at 1:25 PM, Xiao Meng wrote: >

[jira] [Created] (DRILL-4695) Startup failure should be logged in log file.

2016-05-25 Thread Chunhui Shi (JIRA)
Chunhui Shi created DRILL-4695: -- Summary: Startup failure should be logged in log file. Key: DRILL-4695 URL: https://issues.apache.org/jira/browse/DRILL-4695 Project: Apache Drill Issue Type:

[GitHub] drill pull request: DRILL-4690: CORS in REST API

2016-05-25 Thread hnfgns
Github user hnfgns commented on a diff in the pull request: https://github.com/apache/drill/pull/507#discussion_r64632355 --- Diff: exec/jdbc-all/pom.xml --- @@ -441,7 +441,7 @@ This is likely due to you adding new dependencies to a java-exec and not

[jira] [Created] (DRILL-4694) CTAS in JSON format produces extraneous NULL fields

2016-05-25 Thread Aman Sinha (JIRA)
Aman Sinha created DRILL-4694: - Summary: CTAS in JSON format produces extraneous NULL fields Key: DRILL-4694 URL: https://issues.apache.org/jira/browse/DRILL-4694 Project: Apache Drill Issue

Re: [ANNOUNCE] New PMC Chair of Apache Drill

2016-05-25 Thread John Omernik
Congratz Parth, and thank you Jacques! On Wed, May 25, 2016 at 1:25 PM, Xiao Meng wrote: > Big congratulations, Parth! > > And thank you, Jacques, for the leadership and the tremendous contributions > to the community. > > Best, > > Xiao > > On Wed, May 25, 2016 at 8:35 AM,

[GitHub] drill pull request: DRILL-4690: CORS in REST API

2016-05-25 Thread hnfgns
Github user hnfgns commented on the pull request: https://github.com/apache/drill/pull/507#issuecomment-221669367 Looks pretty good. I will make another pass once reviews are addressed. --- If your project is set up for it, you can reply to this email and have your reply appear on

[GitHub] drill pull request: DRILL-4690: CORS in REST API

2016-05-25 Thread PythonicNinja
Github user PythonicNinja commented on a diff in the pull request: https://github.com/apache/drill/pull/507#discussion_r64630482 --- Diff: exec/jdbc-all/pom.xml --- @@ -441,7 +441,7 @@ This is likely due to you adding new dependencies to a java-exec and not

[GitHub] drill pull request: DRILL-4690: CORS in REST API

2016-05-25 Thread PythonicNinja
Github user PythonicNinja commented on a diff in the pull request: https://github.com/apache/drill/pull/507#discussion_r64629803 --- Diff: exec/java-exec/src/main/resources/drill-module.conf --- @@ -110,6 +110,7 @@ drill.exec: { http: { enabled: true,

[GitHub] drill pull request: DRILL-4690: CORS in REST API

2016-05-25 Thread hnfgns
Github user hnfgns commented on a diff in the pull request: https://github.com/apache/drill/pull/507#discussion_r64629460 --- Diff: exec/jdbc-all/pom.xml --- @@ -441,7 +441,7 @@ This is likely due to you adding new dependencies to a java-exec and not

[GitHub] drill pull request: DRILL-4690: CORS in REST API

2016-05-25 Thread hnfgns
Github user hnfgns commented on a diff in the pull request: https://github.com/apache/drill/pull/507#discussion_r64629211 --- Diff: exec/java-exec/src/main/resources/drill-module.conf --- @@ -110,6 +110,7 @@ drill.exec: { http: { enabled: true, ssl_enabled:

[GitHub] drill pull request: DRILL-4690: CORS in REST API

2016-05-25 Thread hnfgns
Github user hnfgns commented on a diff in the pull request: https://github.com/apache/drill/pull/507#discussion_r64627653 --- Diff: exec/java-exec/src/main/java/org/apache/drill/exec/server/rest/WebServer.java --- @@ -159,6 +163,14 @@ public void start() throws Exception {

[GitHub] drill pull request: DRILL-4690: CORS in REST API

2016-05-25 Thread hnfgns
Github user hnfgns commented on a diff in the pull request: https://github.com/apache/drill/pull/507#discussion_r64627240 --- Diff: exec/java-exec/src/main/java/org/apache/drill/exec/server/rest/WebServer.java --- @@ -159,6 +163,14 @@ public void start() throws Exception {

Re: [ANNOUNCE] New PMC Chair of Apache Drill

2016-05-25 Thread Xiao Meng
Big congratulations, Parth! And thank you, Jacques, for the leadership and the tremendous contributions to the community. Best, Xiao On Wed, May 25, 2016 at 8:35 AM, Jacques Nadeau wrote: > I'm pleased to announce that the Drill PMC has voted to elect Parth Chandra > as

Re: [ANNOUNCE] New PMC Chair of Apache Drill

2016-05-25 Thread Abhishek Girish
Congrats Parth! And thanks Jacques. On Wed, May 25, 2016 at 10:53 AM, Jason Altekruse wrote: > Congrats Parth! > > Jason Altekruse > Software Engineer at Dremio > Apache Drill Committer > > On Wed, May 25, 2016 at 10:39 AM, rahul challapalli < > challapallira...@gmail.com>

Re: [ANNOUNCE] New PMC Chair of Apache Drill

2016-05-25 Thread Jason Altekruse
Congrats Parth! Jason Altekruse Software Engineer at Dremio Apache Drill Committer On Wed, May 25, 2016 at 10:39 AM, rahul challapalli < challapallira...@gmail.com> wrote: > Congratulations Parth! > > Thank You Jacques for your leadership over the last few years. > > On Wed, May 25, 2016 at

Re: [ANNOUNCE] New PMC Chair of Apache Drill

2016-05-25 Thread rahul challapalli
Congratulations Parth! Thank You Jacques for your leadership over the last few years. On Wed, May 25, 2016 at 10:26 AM, Gautam Parai wrote: > Congratulations Parth! > > On Wed, May 25, 2016 at 9:02 AM, Jinfeng Ni wrote: > > > Big congratulations,

[GitHub] drill pull request: DRILL-4573: Zero copy LIKE, REGEXP_MATCHES, SU...

2016-05-25 Thread jinfengni
Github user jinfengni commented on the pull request: https://github.com/apache/drill/pull/458#issuecomment-221648222 @jcmcote , just wanna to check the current status of your latest fix. FYI, you may consider using couple of existing methods [1] [2], when you decode the

[GitHub] drill pull request: DRILL-4690: CORS in REST API

2016-05-25 Thread laurentgo
Github user laurentgo commented on a diff in the pull request: https://github.com/apache/drill/pull/507#discussion_r64602614 --- Diff: exec/java-exec/src/main/java/org/apache/drill/exec/server/rest/WebServer.java --- @@ -159,6 +163,14 @@ public void start() throws Exception {

Re: [ANNOUNCE] New PMC Chair of Apache Drill

2016-05-25 Thread Jinfeng Ni
Big congratulations, Parth! Thank you, Jacques, for your contribution and leadership over the last few years! On Wed, May 25, 2016 at 8:35 AM, Jacques Nadeau wrote: > I'm pleased to announce that the Drill PMC has voted to elect Parth Chandra > as the new PMC chair of

[jira] [Created] (DRILL-4693) Incorrect column ordering when CONVERT_FROM() json is used

2016-05-25 Thread Aman Sinha (JIRA)
Aman Sinha created DRILL-4693: - Summary: Incorrect column ordering when CONVERT_FROM() json is used Key: DRILL-4693 URL: https://issues.apache.org/jira/browse/DRILL-4693 Project: Apache Drill

[ANNOUNCE] New PMC Chair of Apache Drill

2016-05-25 Thread Jacques Nadeau
I'm pleased to announce that the Drill PMC has voted to elect Parth Chandra as the new PMC chair of Apache Drill. Please join me in congratulating Parth! thanks, Jacques -- Jacques Nadeau CTO and Co-Founder, Dremio