[jira] [Updated] (DRILL-7227) TPCDS queries 47, 57, 59 fail to run with Statistics enabled at sf100

[ https://issues.apache.org/jira/browse/DRILL-7227?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai updated DRILL-7227: Labels: (was: ready-to-commit) > TPCDS queries 47, 57, 59 fail to run with Statistics enabled at

[jira] [Created] (DRILL-7245) TPCDS queries 1, 45, 65, 97 are 3x slower when Statistics is enabled at sf 100

Gautam Parai created DRILL-7245: --- Summary: TPCDS queries 1, 45, 65, 97 are 3x slower when Statistics is enabled at sf 100 Key: DRILL-7245 URL: https://issues.apache.org/jira/browse/DRILL-7245 Project:

[jira] [Updated] (DRILL-7227) TPCDS queries 47, 57, 59 fail to run with Statistics enabled at sf100

[ https://issues.apache.org/jira/browse/DRILL-7227?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai updated DRILL-7227: Labels: ready-to-commit (was: ) > TPCDS queries 47, 57, 59 fail to run with Statistics enabled at

[jira] [Commented] (DRILL-7148) TPCH query 17 increases execution time with Statistics enabled because join order is changed

[ https://issues.apache.org/jira/browse/DRILL-7148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16834153#comment-16834153 ] Gautam Parai commented on DRILL-7148: - [~anishareddy] / [~agirish] these 2 tests require a baseline

[jira] [Updated] (DRILL-7148) TPCH query 17 increases execution time with Statistics enabled because join order is changed

[ https://issues.apache.org/jira/browse/DRILL-7148?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai updated DRILL-7148: Labels: ready-to-commit (was: ) > TPCH query 17 increases execution time with Statistics enabled

[jira] [Updated] (DRILL-7231) TPCDS-21 regresses after fix for DRILL-7148

[ https://issues.apache.org/jira/browse/DRILL-7231?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai updated DRILL-7231: Description: The join rowcount regresses a lot after changes made for DRILL-7148. This affects

[jira] [Created] (DRILL-7231) TPCDS-21 regresses after fix for DRILL-7148

Gautam Parai created DRILL-7231: --- Summary: TPCDS-21 regresses after fix for DRILL-7148 Key: DRILL-7231 URL: https://issues.apache.org/jira/browse/DRILL-7231 Project: Apache Drill Issue Type:

[jira] [Commented] (DRILL-7148) TPCH query 17 increases execution time with Statistics enabled because join order is changed

[ https://issues.apache.org/jira/browse/DRILL-7148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16829718#comment-16829718 ] Gautam Parai commented on DRILL-7148: - PR link is present in the Issue Links section > TPCH query 17

[jira] [Commented] (DRILL-7148) TPCH query 17 increases execution time with Statistics enabled because join order is changed

[ https://issues.apache.org/jira/browse/DRILL-7148?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16829717#comment-16829717 ] Gautam Parai commented on DRILL-7148: - [https://github.com/apache/drill/pull/1744] > TPCH query 17

[jira] [Issue Comment Deleted] (DRILL-7148) TPCH query 17 increases execution time with Statistics enabled because join order is changed

[ https://issues.apache.org/jira/browse/DRILL-7148?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai updated DRILL-7148: Comment: was deleted (was: [https://github.com/apache/drill/pull/1744]) > TPCH query 17 increases

[jira] [Updated] (DRILL-7148) TPCH query 17 increases execution time with Statistics enabled because join order is changed

[ https://issues.apache.org/jira/browse/DRILL-7148?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai updated DRILL-7148: Labels: ready-to-commit (was: ) > TPCH query 17 increases execution time with Statistics enabled

[jira] [Updated] (DRILL-7148) TPCH query 17 increases execution time with Statistics enabled because join order is changed

[ https://issues.apache.org/jira/browse/DRILL-7148?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai updated DRILL-7148: Fix Version/s: (was: 1.16.0) 1.17.0 > TPCH query 17 increases execution

[jira] [Commented] (DRILL-7114) ANALYZE command generates warnings for stats file and materialization

[ https://issues.apache.org/jira/browse/DRILL-7114?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16811085#comment-16811085 ] Gautam Parai commented on DRILL-7114: - Fixed with commit ID: e477480e7b9626abc8efd70914d3bfd4321b7258

[jira] [Resolved] (DRILL-7114) ANALYZE command generates warnings for stats file and materialization

[ https://issues.apache.org/jira/browse/DRILL-7114?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai resolved DRILL-7114. - Resolution: Fixed > ANALYZE command generates warnings for stats file and materialization >

[jira] [Assigned] (DRILL-7136) Num_buckets for HashAgg in profile may be inaccurate

[ https://issues.apache.org/jira/browse/DRILL-7136?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai reassigned DRILL-7136: --- Assignee: Boaz Ben-Zvi (was: Gautam Parai) > Num_buckets for HashAgg in profile may be

[jira] [Created] (DRILL-7148) TPCH query 17 increases execution time with Statistics enabled because join order is changed

Gautam Parai created DRILL-7148: --- Summary: TPCH query 17 increases execution time with Statistics enabled because join order is changed Key: DRILL-7148 URL: https://issues.apache.org/jira/browse/DRILL-7148

[jira] [Commented] (DRILL-7076) NPE is logged when querying postgres tables

[ https://issues.apache.org/jira/browse/DRILL-7076?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16804510#comment-16804510 ] Gautam Parai commented on DRILL-7076: - [~vvysotskyi] could you please let me know how to get/create

[jira] [Resolved] (DRILL-7123) TPCDS query 83 runs slower when Statistics is disabled

[ https://issues.apache.org/jira/browse/DRILL-7123?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai resolved DRILL-7123. - Resolution: Fixed > TPCDS query 83 runs slower when Statistics is disabled >

[jira] [Resolved] (DRILL-7120) Query fails with ChannelClosedException when Statistics is disabled

[ https://issues.apache.org/jira/browse/DRILL-7120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai resolved DRILL-7120. - Resolution: Fixed > Query fails with ChannelClosedException when Statistics is disabled >

[jira] [Resolved] (DRILL-7122) TPCDS queries 29 25 17 are slower when Statistics is disabled.

[ https://issues.apache.org/jira/browse/DRILL-7122?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai resolved DRILL-7122. - Resolution: Fixed > TPCDS queries 29 25 17 are slower when Statistics is disabled. >

[jira] [Commented] (DRILL-7109) Statistics adds external sort, which spills to disk

[ https://issues.apache.org/jira/browse/DRILL-7109?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16799449#comment-16799449 ] Gautam Parai commented on DRILL-7109: - [~rhou] can you please create another Jira for the issue where

[jira] [Assigned] (DRILL-7129) Join with more than 1 condition is not using stats to compute row count estimate

[ https://issues.apache.org/jira/browse/DRILL-7129?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai reassigned DRILL-7129: --- Assignee: Gautam Parai > Join with more than 1 condition is not using stats to compute row

[jira] [Updated] (DRILL-7108) With statistics enabled TPCH 16 has two additional exchange operators

[ https://issues.apache.org/jira/browse/DRILL-7108?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai updated DRILL-7108: Labels: ready-to-commit (was: ) > With statistics enabled TPCH 16 has two additional exchange

[jira] [Commented] (DRILL-7114) ANALYZE command generates warnings for stats file and materialization

[ https://issues.apache.org/jira/browse/DRILL-7114?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16796306#comment-16796306 ] Gautam Parai commented on DRILL-7114: - [~vitalii] yes you are right - this happens for all queries. I

[jira] [Assigned] (DRILL-7085) Drill Statistics: analyze table cmd fails

[ https://issues.apache.org/jira/browse/DRILL-7085?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai reassigned DRILL-7085: --- Assignee: Gautam Parai > Drill Statistics: analyze table cmd fails >

[jira] [Resolved] (DRILL-1328) Support table statistics

[ https://issues.apache.org/jira/browse/DRILL-1328?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai resolved DRILL-1328. - Resolution: Fixed Merged with commit IDs  469be17597e7b7c6bc1de9863dcb6c5604a55f0c

[jira] [Commented] (DRILL-1328) Support table statistics

[ https://issues.apache.org/jira/browse/DRILL-1328?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16780922#comment-16780922 ] Gautam Parai commented on DRILL-1328: - Reopened the PR to address the most critical review comments.

[jira] [Created] (DRILL-6899) Fix timestamp issues in unit tests ignored with DRILL-6833

Gautam Parai created DRILL-6899: --- Summary: Fix timestamp issues in unit tests ignored with DRILL-6833 Key: DRILL-6899 URL: https://issues.apache.org/jira/browse/DRILL-6899 Project: Apache Drill

[jira] [Commented] (DRILL-6501) Revert/modify fix for DRILL-6212 after CALCITE-2223 is fixed

[ https://issues.apache.org/jira/browse/DRILL-6501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16718497#comment-16718497 ] Gautam Parai commented on DRILL-6501: - This may also be the root cause of

[jira] [Updated] (DRILL-6501) Revert/modify fix for DRILL-6212 after CALCITE-2223 is fixed

[ https://issues.apache.org/jira/browse/DRILL-6501?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai updated DRILL-6501: Fix Version/s: 1.16.0 > Revert/modify fix for DRILL-6212 after CALCITE-2223 is fixed >

[jira] [Updated] (DRILL-6882) Handle the cases where RowKeyJoin's left pipeline being called multiple times.

[ https://issues.apache.org/jira/browse/DRILL-6882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai updated DRILL-6882: Description: RowKeyJoin operator's leftStream pipeline uses IterOutcome.NONE state to repeat the

[jira] [Created] (DRILL-6882) Handle the cases where RowKeyJoin's left pipeline being called multiple times.

Gautam Parai created DRILL-6882: --- Summary: Handle the cases where RowKeyJoin's left pipeline being called multiple times. Key: DRILL-6882 URL: https://issues.apache.org/jira/browse/DRILL-6882 Project:

[jira] [Updated] (DRILL-6882) Handle the cases where RowKeyJoin's left pipeline being called multiple times.

[ https://issues.apache.org/jira/browse/DRILL-6882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai updated DRILL-6882: Description: RowKeyJoin operator's leftStream pipeline uses IterOutcome.NONE state to repeat the

[jira] [Updated] (DRILL-6882) Handle the cases where RowKeyJoin's left pipeline being called multiple times.

[ https://issues.apache.org/jira/browse/DRILL-6882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai updated DRILL-6882: Fix Version/s: 1.15.0 > Handle the cases where RowKeyJoin's left pipeline being called multiple

[jira] [Updated] (DRILL-6882) Handle the cases where RowKeyJoin's left pipeline being called multiple times.

[ https://issues.apache.org/jira/browse/DRILL-6882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai updated DRILL-6882: Affects Version/s: 1.15.0 > Handle the cases where RowKeyJoin's left pipeline being called

[jira] [Created] (DRILL-6878) Index Plan Test failures after DRILL-6833

Gautam Parai created DRILL-6878: --- Summary: Index Plan Test failures after DRILL-6833 Key: DRILL-6878 URL: https://issues.apache.org/jira/browse/DRILL-6878 Project: Apache Drill Issue Type: Bug

[jira] [Updated] (DRILL-6833) MapRDB queries with Run Time Filters with row_key/Secondary Index Should Support Pushdown

[ https://issues.apache.org/jira/browse/DRILL-6833?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai updated DRILL-6833: Labels: ready-to-commit (was: ) > MapRDB queries with Run Time Filters with row_key/Secondary

[jira] [Updated] (DRILL-6770) Queries on MapR-DB JSON tables fail with UnsupportedOperationException: Getting number of rows for tablet not supported

[ https://issues.apache.org/jira/browse/DRILL-6770?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai updated DRILL-6770: Labels: ready-to-commit (was: ) > Queries on MapR-DB JSON tables fail with

[jira] [Created] (DRILL-6841) Statistics ANALYZE statement should be more flexible

Gautam Parai created DRILL-6841: --- Summary: Statistics ANALYZE statement should be more flexible Key: DRILL-6841 URL: https://issues.apache.org/jira/browse/DRILL-6841 Project: Apache Drill

[jira] [Created] (DRILL-6833) MapRDB queries with Run Time Filters with row_key/Secondary Index Should Support Pushdown

Gautam Parai created DRILL-6833: --- Summary: MapRDB queries with Run Time Filters with row_key/Secondary Index Should Support Pushdown Key: DRILL-6833 URL: https://issues.apache.org/jira/browse/DRILL-6833

[jira] [Updated] (DRILL-6824) Drill Query on MapRDB JSON table failing on schema SchemaChangeException, the only distinct Values are NULL and Text

[ https://issues.apache.org/jira/browse/DRILL-6824?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Parai updated DRILL-6824: Description: Drill Query on MapR DB JSON Table or it View fails with a SchemaChangeException. The

[jira] [Created] (DRILL-6824) Drill Query on MapRDB JSON table failing on schema SchemaChangeException, the only distinct Values are NULL and Text

Gautam Parai created DRILL-6824: --- Summary: Drill Query on MapRDB JSON table failing on schema SchemaChangeException, the only distinct Values are NULL and Text Key: DRILL-6824 URL: