[GitHub] drill pull request #668: DRILL-5068: Add a new system table for completed pr...

2016-12-21 Thread zbdzzg
GitHub user zbdzzg reopened a pull request: https://github.com/apache/drill/pull/668 DRILL-5068: Add a new system table for completed profiles Add table "sys.profiles" for completed queries. Following fields added: 1. queryID (String) 2. time (Timestamp) 3.

[GitHub] drill pull request #668: DRILL-5068: Add a new system table for completed pr...

2016-12-21 Thread zbdzzg
Github user zbdzzg closed the pull request at: https://github.com/apache/drill/pull/668 --- 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 enabl

[GitHub] drill pull request #704: DRILL-5125: Provide option to use generic code for ...

2016-12-21 Thread paul-rogers
GitHub user paul-rogers opened a pull request: https://github.com/apache/drill/pull/704 DRILL-5125: Provide option to use generic code for sv remover Performance tests showed that, for queries with a large number of columns, it is faster to use a “generic” implementation of t

[jira] [Created] (DRILL-5152) Enhance the mock data source: better data, SQL access

2016-12-21 Thread Paul Rogers (JIRA)
Paul Rogers created DRILL-5152: -- Summary: Enhance the mock data source: better data, SQL access Key: DRILL-5152 URL: https://issues.apache.org/jira/browse/DRILL-5152 Project: Apache Drill Issue

[GitHub] drill pull request #703: DRILL-5104: Foreman should not set sort memory for ...

2016-12-21 Thread paul-rogers
Github user paul-rogers commented on a diff in the pull request: https://github.com/apache/drill/pull/703#discussion_r93558749 --- Diff: logical/src/main/java/org/apache/drill/common/logical/PlanProperties.java --- @@ -112,8 +121,13 @@ public PlanPropertiesBuilder generator(Generat

[GitHub] drill pull request #703: DRILL-5104: Foreman should not set sort memory for ...

2016-12-21 Thread Ben-Zvi
Github user Ben-Zvi commented on a diff in the pull request: https://github.com/apache/drill/pull/703#discussion_r93556996 --- Diff: logical/src/main/java/org/apache/drill/common/logical/PlanProperties.java --- @@ -112,8 +121,13 @@ public PlanPropertiesBuilder generator(Generator

[GitHub] drill pull request #703: DRILL-5104: Foreman should not set sort memory for ...

2016-12-21 Thread paul-rogers
GitHub user paul-rogers opened a pull request: https://github.com/apache/drill/pull/703 DRILL-5104: Foreman should not set sort memory for a physical plan Physical plans include a plan for memory allocations. However, the code path in Foreman replans external sort memory, even fo

[jira] [Created] (DRILL-5151) ConventionTraitDef.plannerConversionMap is not thread safe

2016-12-21 Thread Chunhui Shi (JIRA)
Chunhui Shi created DRILL-5151: -- Summary: ConventionTraitDef.plannerConversionMap is not thread safe Key: DRILL-5151 URL: https://issues.apache.org/jira/browse/DRILL-5151 Project: Apache Drill I

[jira] [Created] (DRILL-5150) JDBC connections cause drillbit leaks resources and eventually JVM crashes

2016-12-21 Thread Chun Chang (JIRA)
Chun Chang created DRILL-5150: - Summary: JDBC connections cause drillbit leaks resources and eventually JVM crashes Key: DRILL-5150 URL: https://issues.apache.org/jira/browse/DRILL-5150 Project: Apache Dr

[jira] [Created] (DRILL-5149) Planner Optimization : Filter should get pushed into the sub-query

2016-12-21 Thread Rahul Challapalli (JIRA)
Rahul Challapalli created DRILL-5149: Summary: Planner Optimization : Filter should get pushed into the sub-query Key: DRILL-5149 URL: https://issues.apache.org/jira/browse/DRILL-5149 Project: Apa

[jira] [Created] (DRILL-5148) Replace hash-distribution with a simple round-robin distribution for a simple order by query

2016-12-21 Thread Rahul Challapalli (JIRA)
Rahul Challapalli created DRILL-5148: Summary: Replace hash-distribution with a simple round-robin distribution for a simple order by query Key: DRILL-5148 URL: https://issues.apache.org/jira/browse/DRILL-5148

[jira] [Created] (DRILL-5147) Doc update: Support impersonation through Web Console

2016-12-21 Thread Bridget Bevens (JIRA)
Bridget Bevens created DRILL-5147: - Summary: Doc update: Support impersonation through Web Console Key: DRILL-5147 URL: https://issues.apache.org/jira/browse/DRILL-5147 Project: Apache Drill

[GitHub] drill pull request #702: DRILL-5088: set default codec for toJson

2016-12-21 Thread chunhui-shi
GitHub user chunhui-shi opened a pull request: https://github.com/apache/drill/pull/702 DRILL-5088: set default codec for toJson You can merge this pull request into a Git repository by running: $ git pull https://github.com/chunhui-shi/drill DRILL-5088 Alternatively you can

[jira] [Created] (DRILL-5146) Unnecessary spilling to disk by sort when we only have 5000 rows with one column

2016-12-21 Thread Rahul Challapalli (JIRA)
Rahul Challapalli created DRILL-5146: Summary: Unnecessary spilling to disk by sort when we only have 5000 rows with one column Key: DRILL-5146 URL: https://issues.apache.org/jira/browse/DRILL-5146

[GitHub] drill pull request #700: DRILL-5137 - Optimize count(*) queries on MapR-DB B...

2016-12-21 Thread adityakishore
Github user adityakishore commented on a diff in the pull request: https://github.com/apache/drill/pull/700#discussion_r93487747 --- Diff: contrib/storage-hbase/src/main/java/org/apache/drill/exec/store/hbase/HBaseRecordReader.java --- @@ -124,6 +124,11 @@ public HBaseRecordReader

[GitHub] drill pull request #700: DRILL-5137 - Optimize count(*) queries on MapR-DB B...

2016-12-21 Thread adityakishore
Github user adityakishore commented on a diff in the pull request: https://github.com/apache/drill/pull/700#discussion_r93486944 --- Diff: contrib/storage-hbase/src/main/java/org/apache/drill/exec/store/hbase/HBaseRecordReader.java --- @@ -124,6 +124,11 @@ public HBaseRecordReader

Re: drill return count(*) is wrong

2016-12-21 Thread Dechang Gu
I tried something similar to your query, the result looks correct to me: 0: jdbc:drill:schema=dfs.tpchPar100> select t.n, count(*) cnt from (select distinct c_address addr, c_nationkey n from customer limit 10) t group by t.n; *+-+--+* *| ** n ** | **cnt ** |* *+-+--+* *| *7

[GitHub] drill pull request #701: DRILL-4963: Sync remote and local function registri...

2016-12-21 Thread arina-ielchiieva
GitHub user arina-ielchiieva opened a pull request: https://github.com/apache/drill/pull/701 DRILL-4963: Sync remote and local function registries before query ex… …ecution Lazy-init was performed only when function was not found during Calcite parsing but DRILL-4963 sh

Re: drill return count(*) is wrong

2016-12-21 Thread 林春晓
sorry ,update last mail sql:select t.b, count (*) the from (select distinct columns [4] a, columns[5] m, columns [6] b, columns[7] c, columns [8] d from hdfs.`/ott_raw_data/8/2016/12/20161202.txt`) t group by t.b 2016-12-21 19:19 GMT+08:00 林春晓 : > Hello, > I upgrade to V1.9.0 from V1.4.0 today, f

[GitHub] drill pull request #700: DRILL-5137 - Optimize count(*) queries on MapR-DB B...

2016-12-21 Thread spanchamiamapr
GitHub user spanchamiamapr opened a pull request: https://github.com/apache/drill/pull/700 DRILL-5137 - Optimize count(*) queries on MapR-DB Binary Tables This diff uses the same optimization as that for the rowKeyOnly queries. We use the FirstKeyOnlyFilter for count(*) queries.

[GitHub] drill pull request #699: DRILL-5137 - Optimize count(*) queries for MapR-DB ...

2016-12-21 Thread spanchamiamapr
Github user spanchamiamapr closed the pull request at: https://github.com/apache/drill/pull/699 --- 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

[GitHub] drill issue #699: DRILL-5137 - Optimize count(*) queries for MapR-DB Binary ...

2016-12-21 Thread spanchamiamapr
Github user spanchamiamapr commented on the issue: https://github.com/apache/drill/pull/699 Closing this pull request since it is showing unnecessary changes too. --- 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 pr

[GitHub] drill pull request #699: DRILL-5137 - Optimize count(*) queries for MapR-DB ...

2016-12-21 Thread spanchamiamapr
GitHub user spanchamiamapr opened a pull request: https://github.com/apache/drill/pull/699 DRILL-5137 - Optimize count(*) queries for MapR-DB Binary Tables This diff uses the same optimization as that for the rowKeyOnly queries. We use the FirstKeyOnlyFilter for count(*) queries.

[GitHub] drill pull request #685: Drill 5043: Function that returns a unique id per s...

2016-12-21 Thread nagarajanchinnasamy
Github user nagarajanchinnasamy commented on a diff in the pull request: https://github.com/apache/drill/pull/685#discussion_r93394114 --- Diff: exec/java-exec/src/main/java/org/apache/drill/exec/rpc/user/UserServer.java --- @@ -255,11 +257,12 @@ void disableReadTimeout() {