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

[ https://issues.apache.org/jira/browse/DRILL-1328?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai reassigned DRILL-1328: - Assignee: Gautam Kumar Parai > Support table statistics >

[jira] [Commented] (DRILL-4743) HashJoin's not fully parallelized in query plan

[ https://issues.apache.org/jira/browse/DRILL-4743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15343061#comment-15343061 ] Gautam Kumar Parai commented on DRILL-4743: --- [~amansinha100] I have updated the pull request.

[jira] [Created] (DRILL-4743) HashJoin's not fully parallelized in query plan

Gautam Kumar Parai created DRILL-4743: - Summary: HashJoin's not fully parallelized in query plan Key: DRILL-4743 URL: https://issues.apache.org/jira/browse/DRILL-4743 Project: Apache Drill

[jira] [Commented] (DRILL-4743) HashJoin's not fully parallelized in query plan

[ https://issues.apache.org/jira/browse/DRILL-4743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15342826#comment-15342826 ] Gautam Kumar Parai commented on DRILL-4743: --- I have created a pull request

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

[ https://issues.apache.org/jira/browse/DRILL-2330?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15338566#comment-15338566 ] Gautam Kumar Parai commented on DRILL-2330: --- [~amansinha100] Please review the pull request

[jira] [Commented] (DRILL-4665) Partition pruning not working for hive partitioned table with 'LIKE' and '=' filter

[ https://issues.apache.org/jira/browse/DRILL-4665?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15336911#comment-15336911 ] Gautam Kumar Parai commented on DRILL-4665: --- I have created the pull request

[jira] [Updated] (DRILL-4743) HashJoin's not fully parallelized in query plan

[ https://issues.apache.org/jira/browse/DRILL-4743?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai updated DRILL-4743: -- Description: The underlying problem is filter selectivity under-estimate for a query

[jira] [Updated] (DRILL-4743) HashJoin's not fully parallelized in query plan

[ https://issues.apache.org/jira/browse/DRILL-4743?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai updated DRILL-4743: -- Description: The underlying problem is filter selectivity under-estimate for a query

[jira] [Updated] (DRILL-4743) HashJoin's not fully parallelized in query plan

[ https://issues.apache.org/jira/browse/DRILL-4743?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai updated DRILL-4743: -- Description: The underlying problem is filter selectivity under-estimate for a query

[jira] [Updated] (DRILL-4743) HashJoin's not fully parallelized in query plan

[ https://issues.apache.org/jira/browse/DRILL-4743?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai updated DRILL-4743: -- Description: The underlying problem is filter selectivity under-estimate for a query

[jira] [Assigned] (DRILL-4806) need a better error message

[ https://issues.apache.org/jira/browse/DRILL-4806?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai reassigned DRILL-4806: - Assignee: Gautam Kumar Parai > need a better error message >

[jira] [Commented] (DRILL-3710) Make the 20 in-list optimization configurable

[ https://issues.apache.org/jira/browse/DRILL-3710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15394980#comment-15394980 ] Gautam Kumar Parai commented on DRILL-3710: --- [~amansinha100]] I have updated the pull request

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

[ https://issues.apache.org/jira/browse/DRILL-2330?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15378326#comment-15378326 ] Gautam Kumar Parai commented on DRILL-2330: --- I have updated the pull request

[jira] [Commented] (DRILL-4795) Nested aggregate windowed query fails - IllegalStateException

[ https://issues.apache.org/jira/browse/DRILL-4795?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15388181#comment-15388181 ] Gautam Kumar Parai commented on DRILL-4795: --- Yes, we should group by on the partitioning column

[jira] [Commented] (DRILL-3710) Make the 20 in-list optimization configurable

[ https://issues.apache.org/jira/browse/DRILL-3710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15390107#comment-15390107 ] Gautam Kumar Parai commented on DRILL-3710: --- I have updated the pull request

[jira] [Commented] (DRILL-3710) Make the 20 in-list optimization configurable

[ https://issues.apache.org/jira/browse/DRILL-3710?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15389127#comment-15389127 ] Gautam Kumar Parai commented on DRILL-3710: --- I have created the pull request

[jira] [Commented] (DRILL-4743) HashJoin's not fully parallelized in query plan

[ https://issues.apache.org/jira/browse/DRILL-4743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15389157#comment-15389157 ] Gautam Kumar Parai commented on DRILL-4743: --- I have updated the pull request

[jira] [Updated] (DRILL-4806) need a better error message

[ https://issues.apache.org/jira/browse/DRILL-4806?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai updated DRILL-4806: -- Assignee: (was: Gautam Kumar Parai) > need a better error message >

[jira] [Commented] (DRILL-4806) need a better error message

[ https://issues.apache.org/jira/browse/DRILL-4806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15398262#comment-15398262 ] Gautam Kumar Parai commented on DRILL-4806: --- This issue seems unrelated to nested aggregates. We

[jira] [Updated] (DRILL-4743) HashJoin's not fully parallelized in query plan

[ https://issues.apache.org/jira/browse/DRILL-4743?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai updated DRILL-4743: -- Description: The underlying problem is filter selectivity under-estimate for a query

[jira] [Commented] (DRILL-4797) Partition by aggregate function in a window query results in IllegalStateException

[ https://issues.apache.org/jira/browse/DRILL-4797?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15396800#comment-15396800 ] Gautam Kumar Parai commented on DRILL-4797: --- [~khfaraaz] Is this Drill-2330 specific issue? I

[jira] [Comment Edited] (DRILL-4797) Partition by aggregate function in a window query results in IllegalStateException

[ https://issues.apache.org/jira/browse/DRILL-4797?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15396800#comment-15396800 ] Gautam Kumar Parai edited comment on DRILL-4797 at 7/28/16 2:27 AM:

[jira] [Updated] (DRILL-4808) CTE query with window function results in AssertionError

[ https://issues.apache.org/jira/browse/DRILL-4808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai updated DRILL-4808: -- Assignee: (was: Gautam Kumar Parai) > CTE query with window function results in

[jira] [Commented] (DRILL-4806) need a better error message

[ https://issues.apache.org/jira/browse/DRILL-4806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15396815#comment-15396815 ] Gautam Kumar Parai commented on DRILL-4806: --- [~khfaraaz] This can be reduced to a simple

[jira] [Comment Edited] (DRILL-4806) need a better error message

[ https://issues.apache.org/jira/browse/DRILL-4806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15396815#comment-15396815 ] Gautam Kumar Parai edited comment on DRILL-4806 at 7/28/16 2:47 AM:

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

[ https://issues.apache.org/jira/browse/DRILL-1328?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15383080#comment-15383080 ] Gautam Kumar Parai commented on DRILL-1328: --- I have uploaded a new design specification based on

[jira] [Created] (DRILL-4789) In-list to join optimization should have configurable in-list size

Gautam Kumar Parai created DRILL-4789: - Summary: In-list to join optimization should have configurable in-list size Key: DRILL-4789 URL: https://issues.apache.org/jira/browse/DRILL-4789 Project:

[jira] [Assigned] (DRILL-3710) Make the 20 in-list optimization configurable

[ https://issues.apache.org/jira/browse/DRILL-3710?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai reassigned DRILL-3710: - Assignee: Gautam Kumar Parai > Make the 20 in-list optimization configurable >

[jira] [Closed] (DRILL-4789) In-list to join optimization should have configurable in-list size

[ https://issues.apache.org/jira/browse/DRILL-4789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai closed DRILL-4789. - Resolution: Duplicate > In-list to join optimization should have configurable in-list

[jira] [Commented] (DRILL-4665) Partition pruning not working for hive partitioned table with 'LIKE' and '=' filter

[ https://issues.apache.org/jira/browse/DRILL-4665?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15372097#comment-15372097 ] Gautam Kumar Parai commented on DRILL-4665: --- [~amansinha100] I have updated the pull

[jira] [Commented] (DRILL-4743) HashJoin's not fully parallelized in query plan

[ https://issues.apache.org/jira/browse/DRILL-4743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15372060#comment-15372060 ] Gautam Kumar Parai commented on DRILL-4743: --- [~amansinha100] I have updated the pull request

[jira] [Commented] (DRILL-4743) HashJoin's not fully parallelized in query plan

[ https://issues.apache.org/jira/browse/DRILL-4743?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15373539#comment-15373539 ] Gautam Kumar Parai commented on DRILL-4743: --- [~amansinha100]] I have updated the pull request

[jira] [Updated] (DRILL-4771) Drill should avoid doing the same join twice if count(distinct) exists

[ https://issues.apache.org/jira/browse/DRILL-4771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai updated DRILL-4771: -- Affects Version/s: (was: 1.6.0) 1.2.0 > Drill should avoid

[jira] [Created] (DRILL-4771) Drill should avoid doing the same join twice if count(distinct) exists

Gautam Kumar Parai created DRILL-4771: - Summary: Drill should avoid doing the same join twice if count(distinct) exists Key: DRILL-4771 URL: https://issues.apache.org/jira/browse/DRILL-4771

[jira] [Commented] (DRILL-4469) SUM window query returns incorrect results over integer data

[ https://issues.apache.org/jira/browse/DRILL-4469?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15412145#comment-15412145 ] Gautam Kumar Parai commented on DRILL-4469: --- [~zfong] No, I do not think so. Those address

[jira] [Commented] (DRILL-4795) Nested aggregate windowed query fails - IllegalStateException

[ https://issues.apache.org/jira/browse/DRILL-4795?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15412798#comment-15412798 ] Gautam Kumar Parai commented on DRILL-4795: --- I have created a pull request

[jira] [Resolved] (DRILL-4795) Nested aggregate windowed query fails - IllegalStateException

[ https://issues.apache.org/jira/browse/DRILL-4795?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai resolved DRILL-4795. --- Resolution: Fixed Closed with commit: 0bac42dec63a46ca787f6c5fe5a51b9a97e0d6cc >

[jira] [Resolved] (DRILL-4796) AssertionError - Nested sum(avg(c1)) over window

[ https://issues.apache.org/jira/browse/DRILL-4796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai resolved DRILL-4796. --- Resolution: Fixed Closed with commit: 0bac42dec63a46ca787f6c5fe5a51b9a97e0d6cc >

[jira] [Commented] (DRILL-5088) Error when reading DBRef column

[ https://issues.apache.org/jira/browse/DRILL-5088?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15852859#comment-15852859 ] Gautam Kumar Parai commented on DRILL-5088: --- [~cshi] I think you should mark this issue as

[jira] [Assigned] (DRILL-4862) wrong results - use of convert_from(binary_string(key),'UTF8') in filter results in wrong results

[ https://issues.apache.org/jira/browse/DRILL-4862?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai reassigned DRILL-4862: - Assignee: Chunhui Shi (was: Gautam Kumar Parai) +1. The changes look good. >

[jira] [Created] (DRILL-4929) Drill unable to propagate selectivity/distinctrowcount through RelSubset

Gautam Kumar Parai created DRILL-4929: - Summary: Drill unable to propagate selectivity/distinctrowcount through RelSubset Key: DRILL-4929 URL: https://issues.apache.org/jira/browse/DRILL-4929

[jira] [Commented] (DRILL-4895) StreamingAggBatch code generation issues

[ https://issues.apache.org/jira/browse/DRILL-4895?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15497884#comment-15497884 ] Gautam Kumar Parai commented on DRILL-4895: --- This is a potential performance issue - hence not

[jira] [Comment Edited] (DRILL-4771) Drill should avoid doing the same join twice if count(distinct) exists

[ https://issues.apache.org/jira/browse/DRILL-4771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15497847#comment-15497847 ] Gautam Kumar Parai edited comment on DRILL-4771 at 9/17/16 12:51 AM: -

[jira] [Commented] (DRILL-4771) Drill should avoid doing the same join twice if count(distinct) exists

[ https://issues.apache.org/jira/browse/DRILL-4771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15497847#comment-15497847 ] Gautam Kumar Parai commented on DRILL-4771: --- I have created the pull request

[jira] [Created] (DRILL-4895) StreamingAggBatch code generation issues

Gautam Kumar Parai created DRILL-4895: - Summary: StreamingAggBatch code generation issues Key: DRILL-4895 URL: https://issues.apache.org/jira/browse/DRILL-4895 Project: Apache Drill

[jira] [Resolved] (DRILL-4771) Drill should avoid doing the same join twice if count(distinct) exists

[ https://issues.apache.org/jira/browse/DRILL-4771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai resolved DRILL-4771. --- Resolution: Fixed Fix Version/s: 1.9.0 Closed with commit:

[jira] [Assigned] (DRILL-4902) nested aggregate query does not complain about missing GROUP BY clause

[ https://issues.apache.org/jira/browse/DRILL-4902?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai reassigned DRILL-4902: - Assignee: Gautam Kumar Parai > nested aggregate query does not complain about

[jira] [Commented] (DRILL-5043) Function that returns a unique id per session/connection similar to MySQL's CONNECTION_ID()

[ https://issues.apache.org/jira/browse/DRILL-5043?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15684196#comment-15684196 ] Gautam Kumar Parai commented on DRILL-5043: --- Could you please post a link to your GitHub branch

[jira] [Updated] (DRILL-5043) Function that returns a unique id per session/connection similar to MySQL's CONNECTION_ID()

[ https://issues.apache.org/jira/browse/DRILL-5043?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai updated DRILL-5043: -- Priority: Minor (was: Major) > Function that returns a unique id per

[jira] [Commented] (DRILL-5043) Function that returns a unique id per session/connection similar to MySQL's CONNECTION_ID()

[ https://issues.apache.org/jira/browse/DRILL-5043?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15671468#comment-15671468 ] Gautam Kumar Parai commented on DRILL-5043: --- Thanks for creating the JIRA. Please see the

[jira] [Updated] (DRILL-5043) Function that returns a unique id per session/connection similar to MySQL's CONNECTION_ID()

[ https://issues.apache.org/jira/browse/DRILL-5043?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai updated DRILL-5043: -- Affects Version/s: 1.8.0 > Function that returns a unique id per session/connection

[jira] [Commented] (DRILL-4792) Include session options used for a query as part of the profile

[ https://issues.apache.org/jira/browse/DRILL-4792?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15672432#comment-15672432 ] Gautam Kumar Parai commented on DRILL-4792: --- It does not seem to work with the option

[jira] [Updated] (DRILL-4674) Allow casting to boolean the same literals as in Postgre

[ https://issues.apache.org/jira/browse/DRILL-4674?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai updated DRILL-4674: -- Assignee: Arina Ielchiieva (was: Gautam Kumar Parai) > Allow casting to boolean the

[jira] [Updated] (DRILL-4864) Add ANSI format for date/time functions

[ https://issues.apache.org/jira/browse/DRILL-4864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai updated DRILL-4864: -- Assignee: Serhii Harnyk (was: Gautam Kumar Parai) > Add ANSI format for date/time

[jira] [Commented] (DRILL-4864) Add ANSI format for date/time functions

[ https://issues.apache.org/jira/browse/DRILL-4864?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15622571#comment-15622571 ] Gautam Kumar Parai commented on DRILL-4864: --- Sorry, I forgot to reassign it back to the

[jira] [Created] (DRILL-4992) Failing query with same case statement in both select and order by clause using using hash aggregate

Gautam Kumar Parai created DRILL-4992: - Summary: Failing query with same case statement in both select and order by clause using using hash aggregate Key: DRILL-4992 URL:

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

[ https://issues.apache.org/jira/browse/DRILL-1328?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15563926#comment-15563926 ] Gautam Kumar Parai commented on DRILL-1328: --- I have created a new PR to address the review

[jira] [Updated] (DRILL-4919) Fix select count(1) / count(*) on csv with header

[ https://issues.apache.org/jira/browse/DRILL-4919?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai updated DRILL-4919: -- Labels: ready-to-commit (was: ) > Fix select count(1) / count(*) on csv with header >

[jira] [Commented] (DRILL-5088) Error when reading DBRef column

[ https://issues.apache.org/jira/browse/DRILL-5088?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15822090#comment-15822090 ] Gautam Kumar Parai commented on DRILL-5088: --- Sorry, jumped the gun on the +1. I had one more

[jira] [Updated] (DRILL-5048) AssertionError when case statement is used with timestamp and null

[ https://issues.apache.org/jira/browse/DRILL-5048?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai updated DRILL-5048: -- Labels: ready-to-commit (was: ) > AssertionError when case statement is used with

[jira] [Updated] (DRILL-5048) AssertionError when case statement is used with timestamp and null

[ https://issues.apache.org/jira/browse/DRILL-5048?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai updated DRILL-5048: -- Reviewer: Gautam Kumar Parai > AssertionError when case statement is used with

[jira] [Updated] (DRILL-5048) AssertionError when case statement is used with timestamp and null

[ https://issues.apache.org/jira/browse/DRILL-5048?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai updated DRILL-5048: -- Assignee: Serhii Harnyk (was: Gautam Kumar Parai) > AssertionError when case statement

[jira] [Commented] (DRILL-5043) Function that returns a unique id per session/connection similar to MySQL's CONNECTION_ID()

[ https://issues.apache.org/jira/browse/DRILL-5043?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15726877#comment-15726877 ] Gautam Kumar Parai commented on DRILL-5043: --- Hi Nagarajan, Any updates? Regarding your

[jira] [Commented] (DRILL-5394) Optimize query planning for MapR-DB tables by caching row counts

[ https://issues.apache.org/jira/browse/DRILL-5394?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15951400#comment-15951400 ] Gautam Kumar Parai commented on DRILL-5394: --- [~ppenumarthy] is the code ready to go in Apache?

[jira] [Updated] (DRILL-5319) Refactor FragmentContext and OptionManager for unit testing

[ https://issues.apache.org/jira/browse/DRILL-5319?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai updated DRILL-5319: -- Labels: ready-to-commit (was: ) > Refactor FragmentContext and OptionManager for unit

[jira] [Commented] (DRILL-5319) Refactor FragmentContext and OptionManager for unit testing

[ https://issues.apache.org/jira/browse/DRILL-5319?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15959873#comment-15959873 ] Gautam Kumar Parai commented on DRILL-5319: --- [~paul-rogers] since this can be merged

[jira] [Commented] (DRILL-3029) Wrong result with correlated not exists subquery

[ https://issues.apache.org/jira/browse/DRILL-3029?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15923368#comment-15923368 ] Gautam Kumar Parai commented on DRILL-3029: --- [~agirish] Instead of empty results I see the

[jira] [Assigned] (DRILL-3029) Wrong result with correlated not exists subquery

[ https://issues.apache.org/jira/browse/DRILL-3029?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai reassigned DRILL-3029: - Assignee: Gautam Kumar Parai (was: Jinfeng Ni) > Wrong result with correlated

[jira] [Assigned] (DRILL-5049) wrong results - correlated subquery interacting with null equality join

[ https://issues.apache.org/jira/browse/DRILL-5049?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai reassigned DRILL-5049: - Assignee: Gautam Kumar Parai > wrong results - correlated subquery interacting

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

[ https://issues.apache.org/jira/browse/DRILL-1328?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16061374#comment-16061374 ] Gautam Kumar Parai commented on DRILL-1328: --- Based on the last discussion with the reviewers and

[jira] [Created] (DRILL-5794) Projection pushdown does not preserve collation

Gautam Kumar Parai created DRILL-5794: - Summary: Projection pushdown does not preserve collation Key: DRILL-5794 URL: https://issues.apache.org/jira/browse/DRILL-5794 Project: Apache Drill

[jira] [Created] (DRILL-5853) Sort removal based on NULL direction

Gautam Kumar Parai created DRILL-5853: - Summary: Sort removal based on NULL direction Key: DRILL-5853 URL: https://issues.apache.org/jira/browse/DRILL-5853 Project: Apache Drill Issue

[jira] [Assigned] (DRILL-3539) CTAS over empty json file throws NPE

[ https://issues.apache.org/jira/browse/DRILL-3539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai reassigned DRILL-3539: - Assignee: Gautam Kumar Parai > CTAS over empty json file throws NPE >

[jira] [Assigned] (DRILL-3964) CTAS fails with NPE when source JSON file is empty

[ https://issues.apache.org/jira/browse/DRILL-3964?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai reassigned DRILL-3964: - Assignee: Gautam Kumar Parai > CTAS fails with NPE when source JSON file is

[jira] [Resolved] (DRILL-3539) CTAS over empty json file throws NPE

[ https://issues.apache.org/jira/browse/DRILL-3539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai resolved DRILL-3539. --- Resolution: Duplicate > CTAS over empty json file throws NPE >

[jira] [Commented] (DRILL-3539) CTAS over empty json file throws NPE

[ https://issues.apache.org/jira/browse/DRILL-3539?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16491094#comment-16491094 ] Gautam Kumar Parai commented on DRILL-3539: --- [~khfaraaz] this still appears to be an issue in

[jira] [Assigned] (DRILL-4525) Query with BETWEEN clause on Date and Timestamp values fails with Validation Error

[ https://issues.apache.org/jira/browse/DRILL-4525?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai reassigned DRILL-4525: - Assignee: Bohdan Kazydub (was: Gautam Kumar Parai) > Query with BETWEEN clause

[jira] [Assigned] (DRILL-4525) Query with BETWEEN clause on Date and Timestamp values fails with Validation Error

[ https://issues.apache.org/jira/browse/DRILL-4525?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai reassigned DRILL-4525: - Assignee: Gautam Kumar Parai (was: Bohdan Kazydub) > Query with BETWEEN clause

[jira] [Comment Edited] (DRILL-6212) A simple join is recursing too deep in planning and eventually throwing stack overflow.

[ https://issues.apache.org/jira/browse/DRILL-6212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16509017#comment-16509017 ] Gautam Kumar Parai edited comment on DRILL-6212 at 6/12/18 12:57 AM: -

[jira] [Commented] (DRILL-6212) A simple join is recursing too deep in planning and eventually throwing stack overflow.

[ https://issues.apache.org/jira/browse/DRILL-6212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16509017#comment-16509017 ] Gautam Kumar Parai commented on DRILL-6212: --- I see that CALCITE-2223 is still open. We should

[jira] [Comment Edited] (DRILL-6212) A simple join is recursing too deep in planning and eventually throwing stack overflow.

[ https://issues.apache.org/jira/browse/DRILL-6212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16510147#comment-16510147 ] Gautam Kumar Parai edited comment on DRILL-6212 at 6/12/18 8:17 PM:

[jira] [Commented] (DRILL-6212) A simple join is recursing too deep in planning and eventually throwing stack overflow.

[ https://issues.apache.org/jira/browse/DRILL-6212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16510147#comment-16510147 ] Gautam Kumar Parai commented on DRILL-6212: --- [~cshi] I am reassigning this Jira to push it over

[jira] [Commented] (DRILL-6487) Negative row count when selecting from a json file with an OFFSET clause

[ https://issues.apache.org/jira/browse/DRILL-6487?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16513080#comment-16513080 ] Gautam Kumar Parai commented on DRILL-6487: --- [~ben-zvi] I cannot reproduce it on latest Apache

[jira] [Commented] (DRILL-6487) Negative row count when selecting from a json file with an OFFSET clause

[ https://issues.apache.org/jira/browse/DRILL-6487?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16513153#comment-16513153 ] Gautam Kumar Parai commented on DRILL-6487: --- I missed that it is an assert not an exception. I

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

Gautam Kumar Parai created DRILL-6501: - Summary: Revert/modify fix for DRILL-6212 after CALCITE-2223 is fixed Key: DRILL-6501 URL: https://issues.apache.org/jira/browse/DRILL-6501 Project: Apache

[jira] [Created] (DRILL-6480) Use double data type for ScanStats rowcounts

Gautam Kumar Parai created DRILL-6480: - Summary: Use double data type for ScanStats rowcounts Key: DRILL-6480 URL: https://issues.apache.org/jira/browse/DRILL-6480 Project: Apache Drill

[jira] [Created] (DRILL-6463) ProfileParser cannot parse costs when using MockScanBatch

Gautam Kumar Parai created DRILL-6463: - Summary: ProfileParser cannot parse costs when using MockScanBatch Key: DRILL-6463 URL: https://issues.apache.org/jira/browse/DRILL-6463 Project: Apache

[jira] [Closed] (DRILL-6056) Mock datasize could overflow to negative

[ https://issues.apache.org/jira/browse/DRILL-6056?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai closed DRILL-6056. - Resolution: Duplicate > Mock datasize could overflow to negative >

[jira] [Created] (DRILL-6375) ANY_VALUE aggregate function

Gautam Kumar Parai created DRILL-6375: - Summary: ANY_VALUE aggregate function Key: DRILL-6375 URL: https://issues.apache.org/jira/browse/DRILL-6375 Project: Apache Drill Issue Type: New

[jira] [Created] (DRILL-6093) Unneeded columns in Drill logical project

Gautam Kumar Parai created DRILL-6093: - Summary: Unneeded columns in Drill logical project Key: DRILL-6093 URL: https://issues.apache.org/jira/browse/DRILL-6093 Project: Apache Drill

[jira] [Updated] (DRILL-6093) Unneeded columns in Drill logical project

[ https://issues.apache.org/jira/browse/DRILL-6093?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai updated DRILL-6093: -- Labels: ready-to-commit (was: ) > Unneeded columns in Drill logical project >

[jira] [Updated] (DRILL-6099) Drill does not push limit past project (flatten) if it cannot be pushed into scan

[ https://issues.apache.org/jira/browse/DRILL-6099?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai updated DRILL-6099: -- Labels: ready-to-commit (was: ) [~ben-zvi] please consider this PR

[jira] [Updated] (DRILL-6589) Push transitive closure generated predicates past aggregates

[ https://issues.apache.org/jira/browse/DRILL-6589?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai updated DRILL-6589: -- Summary: Push transitive closure generated predicates past aggregates (was: Push

[jira] [Created] (DRILL-6589) Push transitive closure generated predicates past aggregates/projects

Gautam Kumar Parai created DRILL-6589: - Summary: Push transitive closure generated predicates past aggregates/projects Key: DRILL-6589 URL: https://issues.apache.org/jira/browse/DRILL-6589

[jira] [Updated] (DRILL-6589) Push transitive closure generated predicates past aggregates/projects

[ https://issues.apache.org/jira/browse/DRILL-6589?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai updated DRILL-6589: -- Description: Here is a sample query that may benefit from this optimization: SELECT *

[jira] [Created] (DRILL-6099) Drill does not push limit past project (flatten) if it cannot be pushed into scan

Gautam Kumar Parai created DRILL-6099: - Summary: Drill does not push limit past project (flatten) if it cannot be pushed into scan Key: DRILL-6099 URL: https://issues.apache.org/jira/browse/DRILL-6099

[jira] [Updated] (DRILL-6093) Unneeded columns in Drill logical project

[ https://issues.apache.org/jira/browse/DRILL-6093?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Gautam Kumar Parai updated DRILL-6093: -- Labels: ready-to-commit (was: ) > Unneeded columns in Drill logical project >

[jira] [Commented] (DRILL-6093) Unneeded columns in Drill logical project

[ https://issues.apache.org/jira/browse/DRILL-6093?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16335187#comment-16335187 ] Gautam Kumar Parai commented on DRILL-6093: --- [~amansinha100] I needed to update the testcase.

[jira] [Commented] (DRILL-6093) Unneeded columns in Drill logical project

[ https://issues.apache.org/jira/browse/DRILL-6093?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16335251#comment-16335251 ] Gautam Kumar Parai commented on DRILL-6093: --- [~arina] please consider this PR during the batch

[jira] [Commented] (DRILL-6093) Unneeded columns in Drill logical project

[ https://issues.apache.org/jira/browse/DRILL-6093?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16334634#comment-16334634 ] Gautam Kumar Parai commented on DRILL-6093: --- [~amansinha100] I see that you removed the

  1   2   >