[jira] [Created] (DRILL-3926) TPCH Concurrency Scale tests hit ChannelClosedException

2015-10-13 Thread Dechang Gu (JIRA)
Dechang Gu created DRILL-3926: - Summary: TPCH Concurrency Scale tests hit ChannelClosedException Key: DRILL-3926 URL: https://issues.apache.org/jira/browse/DRILL-3926 Project: Apache Drill Issue

[jira] [Created] (DRILL-3890) TPCH Concurrency test hit foremanException even when all the drillbits are alive

2015-10-02 Thread Dechang Gu (JIRA)
Dechang Gu created DRILL-3890: - Summary: TPCH Concurrency test hit foremanException even when all the drillbits are alive Key: DRILL-3890 URL: https://issues.apache.org/jira/browse/DRILL-3890 Project:

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

2015-12-16 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4205?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15060854#comment-15060854 ] Dechang Gu commented on DRILL-4205: --- The parquet file can be downloaded here:

[jira] [Closed] (DRILL-3912) Common subexpression elimination in code generation

2015-12-15 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3912?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-3912. - Tested and Verified: For the following query: select * from comscore_512MB where l_orderkey in

[jira] [Closed] (DRILL-4146) Concurrent queries hang in planner in ReflectiveRelMetadataProvider

2015-12-15 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4146?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-4146. - Tested and verified with TPCH concurrency test with 28, 32, 48, 64, 96, and 128 threads, using mapr-drill

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

2015-12-16 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4205?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15060473#comment-15060473 ] Dechang Gu commented on DRILL-4205: --- Error: SYSTEM ERROR: IndexOutOfBoundsException: srcIndex: 1048587

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

2015-12-16 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4205?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15060476#comment-15060476 ] Dechang Gu commented on DRILL-4205: --- the parquet file can be found at [root@ucs-node1 drill]# ls -ltr

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

2015-12-16 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4205?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15060513#comment-15060513 ] Dechang Gu commented on DRILL-4205: --- Drill 1.3.0 also shows the same failure. It works fine with Drill

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

2015-12-16 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4205?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15060513#comment-15060513 ] Dechang Gu edited comment on DRILL-4205 at 12/16/15 6:47 PM: - Drill 1.3.0 also

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

2015-12-16 Thread Dechang Gu (JIRA)
Dechang Gu created DRILL-4205: - Summary: Simple query hit IndexOutOfBoundException Key: DRILL-4205 URL: https://issues.apache.org/jira/browse/DRILL-4205 Project: Apache Drill Issue Type: Bug

[jira] [Closed] (DRILL-3941) Add timing instrumentation around Partition Pruning

2015-12-14 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3941?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-3941. - verified with 1.4.0 (gitId: 32b871b). LGTM. > Add timing instrumentation around Partition Pruning >

[jira] [Updated] (DRILL-4025) Reduce getFileStatus() invocation for Parquet by 1

2015-12-15 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4025?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu updated DRILL-4025: -- Reviewer: Dechang Gu (was: Chun Chang) > Reduce getFileStatus() invocation for Parquet by 1 >

[jira] [Closed] (DRILL-4046) Performance regression in some tpch queries with 1.3rc0 build

2015-12-14 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4046?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-4046. - Reviewed and verified the fix. It looks fine. > Performance regression in some tpch queries with 1.3rc0

[jira] [Closed] (DRILL-3340) Add named metrics and named operators in OperatorProfile

2015-12-14 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3340?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-3340. - Reviewed and verified. > Add named metrics and named operators in OperatorProfile >

[jira] [Updated] (DRILL-3952) Improve Window Functions performance when not all batches are required to process the current batch

2015-12-14 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu updated DRILL-3952: -- Reviewer: Dechang Gu (was: Chun Chang) > Improve Window Functions performance when not all batches are

[jira] [Closed] (DRILL-3952) Improve Window Functions performance when not all batches are required to process the current batch

2015-12-14 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-3952. - Verified with 1.4.0 (gitId: 32b871b). LGTM. > Improve Window Functions performance when not all batches are

[jira] [Created] (DRILL-4235) Hit IllegalStateException when exec.queue.enable=ture

2015-12-30 Thread Dechang Gu (JIRA)
Dechang Gu created DRILL-4235: - Summary: Hit IllegalStateException when exec.queue.enable=ture Key: DRILL-4235 URL: https://issues.apache.org/jira/browse/DRILL-4235 Project: Apache Drill Issue

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

2015-12-21 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4205?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15067182#comment-15067182 ] Dechang Gu edited comment on DRILL-4205 at 12/21/15 10:37 PM: -- Parth, which

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

2015-12-21 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4205?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15067182#comment-15067182 ] Dechang Gu commented on DRILL-4205: --- Parth, which repo is this fix ( abdfc6a ) in?I looked in your

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

2015-12-21 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4205?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15067358#comment-15067358 ] Dechang Gu commented on DRILL-4205: --- Found the patch in the Apache Drill master repo. And tested it --

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

2015-12-28 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4205?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-4205. - Tested and verified for the following RPM:

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

2015-12-28 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4205?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-4205. - Resolution: Fixed LGTM. > Simple query hit IndexOutOfBoundException >

[jira] [Closed] (DRILL-3765) Partition prune rule is unnecessary fired multiple times.

2015-12-21 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3765?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-3765. - Verified and tested. It looks fine. alter session set `planner.enable_hep_partition_pruning` = false;

[jira] [Closed] (DRILL-4237) Skew in hash distribution

2016-05-26 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4237?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-4237. - Verified with TPCH regression test, no regression is observed. > Skew in hash distribution >

[jira] [Closed] (DRILL-4577) Improve performance for query on INFORMATION_SCHEMA when HIVE is plugged in

2016-05-26 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4577?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-4577. - Verified and add test cases to perf test framework > Improve performance for query on INFORMATION_SCHEMA

[jira] [Closed] (DRILL-4256) Performance regression in hive planning

2016-02-18 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4256?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-4256. - Verified by Rahul. > Performance regression in hive planning > --- > >

[jira] [Closed] (DRILL-4380) Fix performance regression: in creation of FileSelection in ParquetFormatPlugin to not set files if metadata cache is available.

2016-02-18 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4380?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-4380. - Verified. LGTM. > Fix performance regression: in creation of FileSelection in > ParquetFormatPlugin to not

[jira] [Created] (DRILL-4590) Queries return wrong results when applied to views

2016-04-07 Thread Dechang Gu (JIRA)
Dechang Gu created DRILL-4590: - Summary: Queries return wrong results when applied to views Key: DRILL-4590 URL: https://issues.apache.org/jira/browse/DRILL-4590 Project: Apache Drill Issue

[jira] [Commented] (DRILL-4590) Queries return wrong results when applied to views

2016-04-07 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15230424#comment-15230424 ] Dechang Gu commented on DRILL-4590: --- This issue can be easily reproduced as follows (using the drill

[jira] [Commented] (DRILL-4590) Queries return wrong results when applied to views

2016-04-07 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15230441#comment-15230441 ] Dechang Gu commented on DRILL-4590: --- TPCH query 17 on views created from CSV files also shows the same

[jira] [Commented] (DRILL-4590) TPC-H q17 returns wrong results when applied to views

2016-04-07 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15230535#comment-15230535 ] Dechang Gu commented on DRILL-4590: --- Just check the runs with 1.4.0 (r1) against views, the plan looks

[jira] [Commented] (DRILL-4590) TPC-H q17 returns wrong results when applied to views

2016-04-07 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4590?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15230677#comment-15230677 ] Dechang Gu commented on DRILL-4590: --- 1.2.0 release also show the same wrong results. > TPC-H q17

[jira] [Closed] (DRILL-4194) Improve the performance of metadata fetch operation in HiveScan

2016-04-13 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4194?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-4194. - Verified with the test case HIVE in drill perf test framework, comparing this commit (bc74629) and the

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

2016-04-13 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4279?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-4279. - Verified, and it looks good. > Improve performance for skipAll query against Text/JSON/Parquet table >

[jira] [Commented] (DRILL-4589) Reduce planning time for file system partition pruning by reducing filter evaluation overhead

2016-04-26 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4589?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15259189#comment-15259189 ] Dechang Gu commented on DRILL-4589: --- Verified on ucs cluster with the test case. Overall, we see

[jira] [Comment Edited] (DRILL-4589) Reduce planning time for file system partition pruning by reducing filter evaluation overhead

2016-04-26 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4589?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15259189#comment-15259189 ] Dechang Gu edited comment on DRILL-4589 at 4/27/16 2:51 AM: Verified on ucs

[jira] [Closed] (DRILL-4589) Reduce planning time for file system partition pruning by reducing filter evaluation overhead

2016-05-06 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4589?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-4589. - Reviewed and verified. LGTM. > Reduce planning time for file system partition pruning by reducing filter >

[jira] [Closed] (DRILL-4287) Do lazy reading of parquet metadata cache file

2016-04-13 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4287?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-4287. - Verified, looks good. > Do lazy reading of parquet metadata cache file >

[jira] [Closed] (DRILL-4126) Adding HiveMetaStore caching when impersonation is enabled.

2016-07-25 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4126?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-4126. - Verified with Apache Drill 1.5.0 (git id 3f228d3) against the commit (git id 539cbba) prior to the patch,

[jira] [Closed] (DRILL-4127) HiveSchema.getSubSchema() should use lazy loading of all the table names

2016-07-21 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4127?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-4127. - verified with perf test framework. without the patch (commit id: 539cbba):

[jira] [Created] (DRILL-4816) sqlline -f failed to read the query file

2016-07-29 Thread Dechang Gu (JIRA)
Dechang Gu created DRILL-4816: - Summary: sqlline -f failed to read the query file Key: DRILL-4816 URL: https://issues.apache.org/jira/browse/DRILL-4816 Project: Apache Drill Issue Type: Bug

[jira] [Updated] (DRILL-4816) sqlline -f failed to read the query file

2016-07-29 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4816?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu updated DRILL-4816: -- Description: Installed Apache Drill master (commit id: 4e1bdac) on a 10 node cluster. sqlline -u

[jira] [Created] (DRILL-4785) Limit 0 queries regressed in Drill 1.7.0

2016-07-18 Thread Dechang Gu (JIRA)
Dechang Gu created DRILL-4785: - Summary: Limit 0 queries regressed in Drill 1.7.0 Key: DRILL-4785 URL: https://issues.apache.org/jira/browse/DRILL-4785 Project: Apache Drill Issue Type: Bug

[jira] [Closed] (DRILL-4785) Limit 0 queries regressed in Drill 1.7.0

2016-07-20 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4785?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-4785. - verified with limit 0 queries. LGTM. > Limit 0 queries regressed in Drill 1.7.0 >

[jira] [Created] (DRILL-4827) Checking modification time of directories takes too long, needs to be improved

2016-08-04 Thread Dechang Gu (JIRA)
Dechang Gu created DRILL-4827: - Summary: Checking modification time of directories takes too long, needs to be improved Key: DRILL-4827 URL: https://issues.apache.org/jira/browse/DRILL-4827 Project:

[jira] [Commented] (DRILL-2330) Add support for nested aggregate expressions for window aggregates

2016-08-09 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2330?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15413801#comment-15413801 ] Dechang Gu commented on DRILL-2330: --- The Queries are added to the Drill Perf Test Framework, and test on

[jira] [Created] (DRILL-4850) TPCDS Query 33 failed in the second and 3rd runs, but succeeded in the 1st run

2016-08-17 Thread Dechang Gu (JIRA)
Dechang Gu created DRILL-4850: - Summary: TPCDS Query 33 failed in the second and 3rd runs, but succeeded in the 1st run Key: DRILL-4850 URL: https://issues.apache.org/jira/browse/DRILL-4850 Project:

[jira] [Closed] (DRILL-4623) Disable Epoll by Default

2016-08-16 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4623?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-4623. - Verified with gitid 39406d6 on tpch concurrency test with 28 and 32 threads. There is no error message like

[jira] [Assigned] (DRILL-4827) Checking modification time of directories takes too long, needs to be improved

2017-02-07 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4827?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu reassigned DRILL-4827: - Assignee: Aman Sinha > Checking modification time of directories takes too long, needs to be

[jira] [Commented] (DRILL-4851) TPCDS Query 64 just hang there at "starting" state

2016-08-19 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4851?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15428390#comment-15428390 ] Dechang Gu commented on DRILL-4851: --- The same issue is also shown in Drill 1.7.0 release, commit id:

[jira] [Commented] (DRILL-4851) TPCDS Query 64 just hang there at "starting" state

2016-08-19 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4851?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15428771#comment-15428771 ] Dechang Gu commented on DRILL-4851: --- The issue also is shown in Drill 1.6.0 release, commit id: d51f7fc

[jira] [Commented] (DRILL-4877) max(dir0), max(dir1) query against parquet data slower by 2X

2016-09-07 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4877?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15472053#comment-15472053 ] Dechang Gu commented on DRILL-4877: --- Run the same queries on the commit (DRILL-4715: Fix IOBE for

[jira] [Closed] (DRILL-4857) When no partition pruning occurs with metadata caching there's a performance regression

2016-09-13 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4857?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-4857. - Verified, and added test cases to Perf Test Framework. > When no partition pruning occurs with metadata

[jira] [Closed] (DRILL-4846) Eliminate extra operations during metadata cache pruning

2016-09-13 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4846?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-4846. - Verified, and added test cases to Perf Test Framework. So close it. > Eliminate extra operations during

[jira] [Created] (DRILL-4851) TPCDS Query 64 just hang there at "starting" state

2016-08-17 Thread Dechang Gu (JIRA)
Dechang Gu created DRILL-4851: - Summary: TPCDS Query 64 just hang there at "starting" state Key: DRILL-4851 URL: https://issues.apache.org/jira/browse/DRILL-4851 Project: Apache Drill Issue

[jira] [Closed] (DRILL-4816) sqlline -f failed to read the query file

2016-08-22 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4816?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-4816. - Verified on commit 6f5864cfbdcdccd67ba8f031126568d8edbf0c42. LGTM. > sqlline -f failed to read the query

[jira] [Commented] (DRILL-3714) Query runs out of memory and remains in CANCELLATION_REQUESTED state until drillbit is restarted

2016-08-22 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3714?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15431205#comment-15431205 ] Dechang Gu commented on DRILL-3714: --- Verified on TPCDS SF100, LGTM: 0:

[jira] [Commented] (DRILL-4877) max(dir0), max(dir1) query against parquet data slower by 2X

2016-09-30 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4877?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15536289#comment-15536289 ] Dechang Gu commented on DRILL-4877: --- I run the query on the latest 1.9.0 (gitid: 2295715), and the query

[jira] [Closed] (DRILL-4851) TPCDS Query 64 just hang there at "starting" state

2017-03-07 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4851?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-4851. - Duplicate of DRILL-4347, hence close this one > TPCDS Query 64 just hang there at "starting" state >

[jira] [Closed] (DRILL-4850) TPCDS Query 33 failed in the second and 3rd runs, but succeeded in the 1st run

2017-03-07 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4850?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-4850. - Cannot repro in 1.10.0, so close it. > TPCDS Query 33 failed in the second and 3rd runs, but succeeded in

[jira] [Resolved] (DRILL-4850) TPCDS Query 33 failed in the second and 3rd runs, but succeeded in the 1st run

2017-03-07 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4850?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu resolved DRILL-4850. --- Resolution: Cannot Reproduce Fix Version/s: 1.10.0 Cannot repro in 1.10.0 (gitid: 3bfb497),

[jira] [Commented] (DRILL-4347) Planning time for query64 from TPCDS test suite has increased 10 times compared to 1.4 release

2017-03-07 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4347?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15900247#comment-15900247 ] Dechang Gu commented on DRILL-4347: --- Check it with the current AD1.10.0 master (gitid 3dfb497), it takes

[jira] [Created] (DRILL-5669) Multiple TPCH queries failed due to OOM

2017-07-12 Thread Dechang Gu (JIRA)
Dechang Gu created DRILL-5669: - Summary: Multiple TPCH queries failed due to OOM Key: DRILL-5669 URL: https://issues.apache.org/jira/browse/DRILL-5669 Project: Apache Drill Issue Type: Bug

[jira] [Commented] (DRILL-5669) Multiple TPCH queries failed due to OOM

2017-07-12 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5669?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16084506#comment-16084506 ] Dechang Gu commented on DRILL-5669: --- I have narrowed down to the commit

[jira] [Commented] (DRILL-5669) Multiple TPCH queries failed due to OOM

2017-07-12 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5669?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16084877#comment-16084877 ] Dechang Gu commented on DRILL-5669: --- Here is the plan for the failed query: {code} 00-00Screen :

[jira] [Commented] (DRILL-5669) Multiple TPCH queries failed due to OOM

2017-07-12 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5669?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16084881#comment-16084881 ] Dechang Gu commented on DRILL-5669: --- And the profile is uploaded:

[jira] [Updated] (DRILL-5669) Multiple TPCH queries failed due to OOM

2017-07-12 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5669?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu updated DRILL-5669: -- Attachment: 26999476-174e-98fd-e21e-fd53f79284c7.sys.drill > Multiple TPCH queries failed due to OOM >

[jira] [Updated] (DRILL-5468) THCH Q18 regressed ~3x due to execution plan changes

2017-05-03 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5468?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu updated DRILL-5468: -- Attachment: Q18_profile_gitid_adbf363 Q18_profile_gitid_841ead4 > THCH Q18 regressed

[jira] [Created] (DRILL-5468) THCH Q18 regressed ~3x due to execution plan changes

2017-05-03 Thread Dechang Gu (JIRA)
Dechang Gu created DRILL-5468: - Summary: THCH Q18 regressed ~3x due to execution plan changes Key: DRILL-5468 URL: https://issues.apache.org/jira/browse/DRILL-5468 Project: Apache Drill Issue

[jira] [Closed] (DRILL-5267) Managed external sort spills too often with Parquet data

2017-05-11 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5267?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-5267. - Verified and added test case to perf framework. Here are the numbers: Drill version (gitid) Query tm (ms)

[jira] [Closed] (DRILL-5266) Parquet Reader produces "low density" record batches - bits vs. bytes

2017-05-11 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5266?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-5266. - verified. see closure comment in DRILL-5267 > Parquet Reader produces "low density" record batches - bits

[jira] [Updated] (DRILL-5532) TPCH Query 16 failed when planner.width.max_per_node <10

2017-05-22 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5532?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu updated DRILL-5532: -- Attachment: profile_tpch16_gitid_adbf363.26dce6f3-3d75-e906-bfcb-2c6541ee2ff0.sys.drill

[jira] [Created] (DRILL-5532) TPCH Query 16 failed when planner.width.max_per_node <10

2017-05-22 Thread Dechang Gu (JIRA)
Dechang Gu created DRILL-5532: - Summary: TPCH Query 16 failed when planner.width.max_per_node <10 Key: DRILL-5532 URL: https://issues.apache.org/jira/browse/DRILL-5532 Project: Apache Drill

[jira] [Commented] (DRILL-5532) TPCH Query 16 failed when planner.width.max_per_node <10

2017-05-22 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5532?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16019987#comment-16019987 ] Dechang Gu commented on DRILL-5532: --- set planner.width.max_per_node >=10, the query run correctly.

[jira] [Closed] (DRILL-4982) Hive Queries degrade when queries switch between different formats

2017-05-08 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4982?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-4982. - Verified and added testcase to perf test framework. > Hive Queries degrade when queries switch between

[jira] [Commented] (DRILL-5809) Queries failed with UnrecognizedPropertyException

2017-09-21 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5809?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16175469#comment-16175469 ] Dechang Gu commented on DRILL-5809: --- [~timothyfarkas] You don't need to run tpch query, even the

[jira] [Closed] (DRILL-5809) Queries failed with UnrecognizedPropertyException

2017-09-22 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5809?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu closed DRILL-5809. - Resolution: Fixed [~timothyfarkas] Tried your new patch, LGTM. Thanks. > Queries failed with

[jira] [Assigned] (DRILL-5809) Queries failed with UnrecognizedPropertyException

2017-09-21 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5809?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu reassigned DRILL-5809: - Assignee: Boaz Ben-Zvi > Queries failed with UnrecognizedPropertyException >

[jira] [Updated] (DRILL-5809) Queries failed with UnrecognizedPropertyException

2017-09-21 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5809?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu updated DRILL-5809: -- Priority: Blocker (was: Major) > Queries failed with UnrecognizedPropertyException >

[jira] [Created] (DRILL-5809) Queries failed with UnrecognizedPropertyException

2017-09-21 Thread Dechang Gu (JIRA)
Dechang Gu created DRILL-5809: - Summary: Queries failed with UnrecognizedPropertyException Key: DRILL-5809 URL: https://issues.apache.org/jira/browse/DRILL-5809 Project: Apache Drill Issue Type:

[jira] [Commented] (DRILL-5809) Queries failed with UnrecognizedPropertyException

2017-09-25 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5809?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16179303#comment-16179303 ] Dechang Gu commented on DRILL-5809: --- [~timothyfarkas]Please merge your patch to the master, thanks. >

[jira] [Created] (DRILL-5817) deprecated sys options should be deleted from old zookeeper setting

2017-09-25 Thread Dechang Gu (JIRA)
Dechang Gu created DRILL-5817: - Summary: deprecated sys options should be deleted from old zookeeper setting Key: DRILL-5817 URL: https://issues.apache.org/jira/browse/DRILL-5817 Project: Apache Drill

[jira] [Updated] (DRILL-5817) deprecated sys options should be deleted from old zookeeper setting

2017-09-25 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5817?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu updated DRILL-5817: -- Environment: drill 1.12.0 (was: drill 1.11.0 ) > deprecated sys options should be deleted from old

[jira] [Updated] (DRILL-5817) deprecated sys options should be deleted from old zookeeper setting

2017-09-25 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5817?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu updated DRILL-5817: -- Fix Version/s: (was: 1.11.0) 1.12.0 > deprecated sys options should be deleted

[jira] [Updated] (DRILL-5817) deprecated sys options should be deleted from old zookeeper setting

2017-09-25 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5817?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu updated DRILL-5817: -- Affects Version/s: (was: 1.11.0) 1.12.0 > deprecated sys options should be

[jira] [Updated] (DRILL-5817) deprecated sys options should be deleted from old zookeeper setting

2017-09-25 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5817?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu updated DRILL-5817: -- Fix Version/s: (was: 1.12.0) 1.11.0 > deprecated sys options should be deleted

[jira] [Updated] (DRILL-5817) deprecated sys options should be deleted from old zookeeper setting

2017-09-25 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5817?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu updated DRILL-5817: -- Affects Version/s: (was: 1.12.0) 1.11.0 > deprecated sys options should be

[jira] [Updated] (DRILL-5817) deprecated sys options should be deleted from old zookeeper setting

2017-09-25 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5817?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu updated DRILL-5817: -- Environment: drill 1.11.0 (was: drill 1.12.0 ) > deprecated sys options should be deleted from old

[jira] [Commented] (DRILL-5967) Memory leak by HashPartitionSender

2017-12-08 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16284121#comment-16284121 ] Dechang Gu commented on DRILL-5967: --- This is from concurrency test: 16 clients, each executes 16 TPCH

[jira] [Commented] (DRILL-5967) Memory leak by HashPartitionSender

2017-12-07 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16282032#comment-16282032 ] Dechang Gu commented on DRILL-5967: --- Tried the fix (gitid f599401) but still hit memory leak: {code}

[jira] [Commented] (DRILL-5967) Memory leak by HashPartitionSender

2017-12-08 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16284483#comment-16284483 ] Dechang Gu commented on DRILL-5967: --- Is it this one: c8ca958eeb5e3b314aca9bb451e1631cbde18d83

[jira] [Comment Edited] (DRILL-5967) Memory leak by HashPartitionSender

2017-12-08 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16284121#comment-16284121 ] Dechang Gu edited comment on DRILL-5967 at 12/8/17 7:54 PM: This is from

[jira] [Commented] (DRILL-5967) Memory leak by HashPartitionSender

2017-12-08 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5967?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16284170#comment-16284170 ] Dechang Gu commented on DRILL-5967: --- The query did not complete, it was cancelled after this error.

[jira] [Commented] (DRILL-5468) TPCH Q18 regressed ~3x due to execution plan changes

2017-10-31 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16227570#comment-16227570 ] Dechang Gu commented on DRILL-5468: --- I tried this setting on SF100, Q18 did not show the 3x regression,

[jira] [Created] (DRILL-6448) query on nested data returns bogus results

2018-05-25 Thread Dechang Gu (JIRA)
Dechang Gu created DRILL-6448: - Summary: query on nested data returns bogus results Key: DRILL-6448 URL: https://issues.apache.org/jira/browse/DRILL-6448 Project: Apache Drill Issue Type: Bug

[jira] [Commented] (DRILL-6374) TPCH Queries regressed and OOM when run concurrency test

2018-05-01 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16460231#comment-16460231 ] Dechang Gu commented on DRILL-6374: --- Query 08 also takes 4x time: 30 sec vs 7.5 sec in the parent

[jira] [Commented] (DRILL-6374) TPCH Queries regressed and OOM when run concurrency test

2018-05-01 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16460238#comment-16460238 ] Dechang Gu commented on DRILL-6374: --- For the OOM, here is the stack: {code} 2018-05-01 13:40:42,457

[jira] [Updated] (DRILL-6374) TPCH Queries regressed and OOM when run concurrency test

2018-05-01 Thread Dechang Gu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6374?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dechang Gu updated DRILL-6374: -- Description: Run TPCH regression test on Apache Drill 1.14.0 master commit

[jira] [Created] (DRILL-6374) TPCH Queries regressed and OOM when run concurrency test

2018-05-01 Thread Dechang Gu (JIRA)
Dechang Gu created DRILL-6374: - Summary: TPCH Queries regressed and OOM when run concurrency test Key: DRILL-6374 URL: https://issues.apache.org/jira/browse/DRILL-6374 Project: Apache Drill

[jira] [Created] (DRILL-6718) TPCH Queries hit IOB when running with the JPPD feature

2018-08-28 Thread Dechang Gu (JIRA)
Dechang Gu created DRILL-6718: - Summary: TPCH Queries hit IOB when running with the JPPD feature Key: DRILL-6718 URL: https://issues.apache.org/jira/browse/DRILL-6718 Project: Apache Drill Issue

  1   2   >