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

2015-09-15 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3765?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-3765. --- Resolution: Won't Fix I looked at the Calcite trace file. Seems the multiple rule firing is what

[jira] [Commented] (DRILL-3679) IOB Exception : when window functions used in outer and inner query

2015-09-15 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3679?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14746594#comment-14746594 ] Jinfeng Ni commented on DRILL-3679: --- Can you run against the latest master branch? The fix for

[jira] [Resolved] (DRILL-3679) IOB Exception : when window functions used in outer and inner query

2015-09-15 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-3679. --- Resolution: Fixed The symptom is different, but the root cause is same as DRILL-3680. Marked as

[jira] [Updated] (DRILL-3788) Partition Pruning not taking place with metadata caching when we have ~20k files

2015-09-15 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3788?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3788: -- Assignee: Aman Sinha (was: Jinfeng Ni) > Partition Pruning not taking place with metadata caching when

[jira] [Commented] (DRILL-2748) Filter is not pushed down into subquery with the group by

2015-09-15 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2748?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14746631#comment-14746631 ] Jinfeng Ni commented on DRILL-2748: --- Turns out adding FilterAggregateTransposableRule is not enough to

[jira] [Updated] (DRILL-3786) Query with window function fails with IllegalFormatConversionException

2015-09-15 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3786: -- Assignee: Deneche A. Hakim (was: Jinfeng Ni) > Query with window function fails with

[jira] [Commented] (DRILL-3786) Query with window function fails with IllegalFormatConversionException

2015-09-15 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14746556#comment-14746556 ] Jinfeng Ni commented on DRILL-3786: --- The stack trace shows the error is raised in Sort operator. Assign

[jira] [Updated] (DRILL-3761) CastIntDecimal implementation should not update the input holder.

2015-09-15 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3761?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3761: -- Assignee: Mehant Baid (was: Jinfeng Ni) > CastIntDecimal implementation should not update the input

[jira] [Updated] (DRILL-3761) CastIntDecimal implementation should not update the input holder.

2015-09-15 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3761?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3761: -- Attachment: 0001-DRILL-3761-Modify-CastIntDecimal-implementation-so-t.patch > CastIntDecimal

[jira] [Commented] (DRILL-3761) CastIntDecimal implementation should not update the input holder.

2015-09-15 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3761?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14745844#comment-14745844 ] Jinfeng Ni commented on DRILL-3761: --- [~mehant], could you review this small patch? Thanks! >

[jira] [Commented] (DRILL-3754) Remove redundancy in run-time generated code for common column references.

2015-09-10 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3754?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14739967#comment-14739967 ] Jinfeng Ni commented on DRILL-3754: --- Pull request : https://github.com/apache/drill/pull/153 >

[jira] [Commented] (DRILL-1457) Limit operator optimization : push limit operator past exchange operator; disable parallel plan if no order is required.

2015-09-10 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1457?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14739979#comment-14739979 ] Jinfeng Ni commented on DRILL-1457: --- The fix for this issue could be related to Calcite-831:

[jira] [Updated] (DRILL-3680) window function query returns Incorrect results

2015-09-10 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3680?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3680: -- Attachment: 0001-DRILL-3680-Fix-incorrect-query-result-or-IOBE-when-t.patch.2 > window function query

[jira] [Created] (DRILL-3761) CastIntDecimal implementation should not update the input holder.

2015-09-10 Thread Jinfeng Ni (JIRA)
Jinfeng Ni created DRILL-3761: - Summary: CastIntDecimal implementation should not update the input holder. Key: DRILL-3761 URL: https://issues.apache.org/jira/browse/DRILL-3761 Project: Apache Drill

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

2015-09-10 Thread Jinfeng Ni (JIRA)
Jinfeng Ni created DRILL-3765: - Summary: Partition prune rule is unnecessary fired multiple times. Key: DRILL-3765 URL: https://issues.apache.org/jira/browse/DRILL-3765 Project: Apache Drill

[jira] [Commented] (DRILL-3680) window function query returns Incorrect results

2015-09-10 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3680?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14739871#comment-14739871 ] Jinfeng Ni commented on DRILL-3680: --- Turns out that doing uniquification in DrillWindowRel only is not

[jira] [Updated] (DRILL-3680) window function query returns Incorrect results

2015-09-10 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3680?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3680: -- Assignee: Aman Sinha (was: Jinfeng Ni) > window function query returns Incorrect results >

[jira] [Commented] (DRILL-3754) Remove redundancy in run-time generated code for common column references.

2015-09-10 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3754?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14739971#comment-14739971 ] Jinfeng Ni commented on DRILL-3754: --- [~jnadeau], could you please review the pull request ( the 2nd

[jira] [Commented] (DRILL-3680) window function query returns Incorrect results

2015-09-10 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3680?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14739872#comment-14739872 ] Jinfeng Ni commented on DRILL-3680: --- [~amansinha100], could you please take a look at the revised patch?

[jira] [Created] (DRILL-3754) Remove redundancy in run-time generated code for common column references.

2015-09-09 Thread Jinfeng Ni (JIRA)
Jinfeng Ni created DRILL-3754: - Summary: Remove redundancy in run-time generated code for common column references. Key: DRILL-3754 URL: https://issues.apache.org/jira/browse/DRILL-3754 Project: Apache

[jira] [Commented] (DRILL-3680) window function query returns Incorrect results

2015-09-08 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3680?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14735231#comment-14735231 ] Jinfeng Ni commented on DRILL-3680: --- Turns out that there is field name conflicts in Window RelNode.

[jira] [Commented] (DRILL-3680) window function query returns Incorrect results

2015-09-08 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3680?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14735234#comment-14735234 ] Jinfeng Ni commented on DRILL-3680: --- [~amansinha100], could you please review the patch? Thanks. >

[jira] [Updated] (DRILL-3680) window function query returns Incorrect results

2015-09-08 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3680?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3680: -- Attachment: 0001-DRILL-3680-Fix-incorrect-query-result-or-IOBE-when-t.patch > window function query

[jira] [Updated] (DRILL-3680) window function query returns Incorrect results

2015-09-08 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3680?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3680: -- Assignee: Aman Sinha (was: Jinfeng Ni) > window function query returns Incorrect results >

[jira] [Updated] (DRILL-3735) Directory pruning is not happening when number of files is larger than 64k

2015-09-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3735?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3735: -- Assignee: Aman Sinha (was: Jinfeng Ni) > Directory pruning is not happening when number of files is

[jira] [Commented] (DRILL-3731) Partition Pruning not taking place when we have case statement within the filter

2015-09-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3731?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14727642#comment-14727642 ] Jinfeng Ni commented on DRILL-3731: --- I understand the partition pruning should work for this filter. But

[jira] [Resolved] (DRILL-3492) Add support for encoding of Drill data types into byte ordered format

2015-09-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3492?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-3492. --- Resolution: Fixed Fixed in commit: 95623912ebf348962fe8a8846c5f47c5fdcf2f78 > Add support for

[jira] [Updated] (DRILL-1950) Implement filter pushdown for Parquet

2015-08-31 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1950?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-1950: -- Priority: Critical (was: Major) > Implement filter pushdown for Parquet >

[jira] [Commented] (DRILL-1950) Implement filter pushdown for Parquet

2015-08-31 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1950?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14723762#comment-14723762 ] Jinfeng Ni commented on DRILL-1950: --- Agree with what [~amansinha100] said. This is a performance

[jira] [Resolved] (DRILL-3716) Drill should push filter past aggregate in order to improve query performance.

2015-08-27 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3716?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-3716. --- Resolution: Fixed Drill should push filter past aggregate in order to improve query performance.

[jira] [Commented] (DRILL-3716) Drill should push filter past aggregate in order to improve query performance.

2015-08-27 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3716?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14717161#comment-14717161 ] Jinfeng Ni commented on DRILL-3716: --- Yes, it's duplicate. I marked DRILL-3716 as

[jira] [Updated] (DRILL-2748) Filter is not pushed down into subquery with the group by

2015-08-27 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2748?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2748: -- Affects Version/s: 1.0.0 1.1.0 Filter is not pushed down into subquery with the

[jira] [Updated] (DRILL-2748) Filter is not pushed down into subquery with the group by

2015-08-27 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2748?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2748: -- Assignee: Aman Sinha (was: Jinfeng Ni) Filter is not pushed down into subquery with the group by

[jira] [Updated] (DRILL-2748) Filter is not pushed down into subquery with the group by

2015-08-27 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2748?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2748: -- Attachment: 0001-DRILL-2748-Add-optimizer-rule-to-push-filter-past-ag.patch Filter is not pushed down

[jira] [Commented] (DRILL-2748) Filter is not pushed down into subquery with the group by

2015-08-27 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2748?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14717660#comment-14717660 ] Jinfeng Ni commented on DRILL-2748: --- [~amansinha100], could you please review the patch?

[jira] [Assigned] (DRILL-3702) PartitionPruning hit ClassCastException in Interpreter when the pruning filter expression is of non-nullable type.

2015-08-26 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3702?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni reassigned DRILL-3702: - Assignee: Jinfeng Ni (was: Mehant Baid) PartitionPruning hit ClassCastException in Interpreter

[jira] [Commented] (DRILL-3542) Rebase Drill on Calcite 1.4.0 release

2015-08-26 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3542?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14715616#comment-14715616 ] Jinfeng Ni commented on DRILL-3542: --- Apache review board link:

[jira] [Updated] (DRILL-3702) PartitionPruning hit ClassCastException in Interpreter when the pruning filter expression is of non-nullable type.

2015-08-25 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3702?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3702: -- Attachment: 0001-DRILL-3702-Fix-partition-pruning-rule-when-the-pruni.patch PartitionPruning hit

[jira] [Resolved] (DRILL-3667) Random Assertion Error while planning

2015-08-25 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3667?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-3667. --- Resolution: Fixed I think the root cause of this JIRA is same as DRILL-3690, which has merged the

[jira] [Updated] (DRILL-3667) Random Assertion Error while planning

2015-08-25 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3667?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3667: -- Assignee: Mehant Baid (was: Jinfeng Ni) Random Assertion Error while planning

[jira] [Updated] (DRILL-3702) PartitionPruning hit ClassCastException in Interpreter when the pruning filter expression is of non-nullable type.

2015-08-25 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3702?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3702: -- Assignee: Mehant Baid (was: Jinfeng Ni) PartitionPruning hit ClassCastException in Interpreter when

[jira] [Commented] (DRILL-3702) PartitionPruning hit ClassCastException in Interpreter when the pruning filter expression is of non-nullable type.

2015-08-25 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3702?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14711753#comment-14711753 ] Jinfeng Ni commented on DRILL-3702: --- [~mehant], could you please review this patch?

[jira] [Created] (DRILL-3702) PartitionPruning hit ClassCastException in Interpreter when the pruning filter expression is of non-nullable type.

2015-08-24 Thread Jinfeng Ni (JIRA)
Jinfeng Ni created DRILL-3702: - Summary: PartitionPruning hit ClassCastException in Interpreter when the pruning filter expression is of non-nullable type. Key: DRILL-3702 URL:

[jira] [Resolved] (DRILL-3666) Replace assert uses in Drill's interpreter to catch error when it happens.

2015-08-23 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3666?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-3666. --- Resolution: Fixed Fixed in commit : 32ee76d2eea21fc0655cd104d0807fcf351334b9 Replace assert uses in

[jira] [Commented] (DRILL-3680) window function query returns Incorrect results

2015-08-21 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3680?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14707577#comment-14707577 ] Jinfeng Ni commented on DRILL-3680: --- Agree. The output of two Window operators both has

[jira] [Assigned] (DRILL-3680) window function query returns Incorrect results

2015-08-21 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3680?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni reassigned DRILL-3680: - Assignee: Jinfeng Ni (was: Deneche A. Hakim) window function query returns Incorrect results

[jira] [Updated] (DRILL-3688) Drill should honor skip.header.line.count attribute of Hive table

2015-08-21 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3688: -- Component/s: (was: Query Planning Optimization) Storage - Hive Drill should

[jira] [Commented] (DRILL-3542) Rebase Drill on Calcite 1.4.0 release

2015-08-21 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3542?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14707705#comment-14707705 ] Jinfeng Ni commented on DRILL-3542: --- Pull request :

[jira] [Updated] (DRILL-3542) Rebase Drill on Calcite 1.4.0 release

2015-08-21 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3542?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3542: -- Assignee: Aman Sinha (was: Jinfeng Ni) Rebase Drill on Calcite 1.4.0 release

[jira] [Updated] (DRILL-3666) Replace assert uses in Drill's interpreter to catch error when it happens.

2015-08-18 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3666?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3666: -- Attachment: 0001-DRILL-3666-Replace-assert-check-in-InterpreterEvalua.patch Replace assert uses in

[jira] [Created] (DRILL-3666) Replace assert uses in Drill's interpreter to catch error when it happens.

2015-08-18 Thread Jinfeng Ni (JIRA)
Jinfeng Ni created DRILL-3666: - Summary: Replace assert uses in Drill's interpreter to catch error when it happens. Key: DRILL-3666 URL: https://issues.apache.org/jira/browse/DRILL-3666 Project: Apache

[jira] [Updated] (DRILL-3666) Replace assert uses in Drill's interpreter to catch error when it happens.

2015-08-18 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3666?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3666: -- Assignee: Aman Sinha (was: Jinfeng Ni) Replace assert uses in Drill's interpreter to catch error when

[jira] [Commented] (DRILL-3666) Replace assert uses in Drill's interpreter to catch error when it happens.

2015-08-18 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3666?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14701783#comment-14701783 ] Jinfeng Ni commented on DRILL-3666: --- [~amansinha100], could you please review this small

[jira] [Commented] (DRILL-3601) LEAD function used without OVER clause should not plan

2015-08-17 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3601?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14700328#comment-14700328 ] Jinfeng Ni commented on DRILL-3601: --- I think Sean has a fix for CALCITE-820, which

[jira] [Updated] (DRILL-3601) LEAD function used without OVER clause should not plan

2015-08-17 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3601: -- Assignee: Sean Hsuan-Yi Chu (was: Jinfeng Ni) LEAD function used without OVER clause should not plan

[jira] [Updated] (DRILL-3651) Window function should not be allowed in order by clause of over clause of window function

2015-08-14 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3651?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3651: -- Assignee: Aman Sinha (was: Jinfeng Ni) Window function should not be allowed in order by clause of

[jira] [Commented] (DRILL-3649) LEAD , LAG , NTILE , FIRST_VALUE , LAST_VALUE report RuntimeException for missing OVER clause

2015-08-14 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3649?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14697694#comment-14697694 ] Jinfeng Ni commented on DRILL-3649: --- Assign to Sean, since I believe the fix is in

[jira] [Commented] (DRILL-3649) LEAD , LAG , NTILE , FIRST_VALUE , LAST_VALUE report RuntimeException for missing OVER clause

2015-08-14 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3649?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14697722#comment-14697722 ] Jinfeng Ni commented on DRILL-3649: --- The symptom is different. But the root cause is the

[jira] [Updated] (DRILL-3297) Using rank, dense_rank, percent_rank, cume_dist, row_number window functions without OVER clause results in cryptic schema change error

2015-08-14 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3297?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3297: -- Assignee: Sean Hsuan-Yi Chu (was: Jinfeng Ni) Using rank, dense_rank, percent_rank, cume_dist,

[jira] [Resolved] (DRILL-3639) Internal error: Error while applying rule PruneScanRule:Filter_On_Scan_Parquet

2015-08-13 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3639?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-3639. --- Resolution: Fixed Internal error: Error while applying rule PruneScanRule:Filter_On_Scan_Parquet

[jira] [Commented] (DRILL-3639) Internal error: Error while applying rule PruneScanRule:Filter_On_Scan_Parquet

2015-08-13 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14695208#comment-14695208 ] Jinfeng Ni commented on DRILL-3639: --- Could you try with the latest master branch

[jira] [Updated] (DRILL-3412) Projections are not getting push down below Window operator

2015-08-13 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3412: -- Assignee: Sean Hsuan-Yi Chu (was: Jinfeng Ni) Projections are not getting push down below Window

[jira] [Commented] (DRILL-3621) Wrong results when Drill on Hbase query contains rowkey or or IN

2015-08-13 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14696246#comment-14696246 ] Jinfeng Ni commented on DRILL-3621: --- Fixed in e3fbc6a19ee77a9f3c71c39eaaa3424a991969ca.

[jira] [Commented] (DRILL-3621) Wrong results when Drill on Hbase query contains rowkey or or IN

2015-08-13 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14695756#comment-14695756 ] Jinfeng Ni commented on DRILL-3621: --- Thanks! Will add the additional row in the patch.

[jira] [Updated] (DRILL-3636) Partition Pruning : We are not pruning sometimes when we use is null/not null in the filter

2015-08-12 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3636?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3636: -- Assignee: Aman Sinha (was: Jinfeng Ni) Partition Pruning : We are not pruning sometimes when we use

[jira] [Updated] (DRILL-3621) Wrong results when Drill on Hbase query contains rowkey or or IN

2015-08-12 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3621?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3621: -- Fix Version/s: 1.2.0 Wrong results when Drill on Hbase query contains rowkey or or IN

[jira] [Commented] (DRILL-3621) Wrong results when Drill on Hbase query contains rowkey or or IN

2015-08-12 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14693902#comment-14693902 ] Jinfeng Ni commented on DRILL-3621: --- Here is the basic idea of the fix. 1. row_key =

[jira] [Commented] (DRILL-3621) Wrong results when Drill on Hbase query contains rowkey or or IN

2015-08-12 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14693882#comment-14693882 ] Jinfeng Ni commented on DRILL-3621: --- [~amansinha100] or [~adityakishore], can one of you

[jira] [Assigned] (DRILL-3621) Wrong results when Drill on Hbase query contains rowkey or or IN

2015-08-11 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3621?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni reassigned DRILL-3621: - Assignee: Jinfeng Ni (was: Chris Westin) Wrong results when Drill on Hbase query contains

[jira] [Updated] (DRILL-3580) wrong plan for window function queries containing function(col1 + colb)

2015-08-11 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3580?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3580: -- Assignee: Sean Hsuan-Yi Chu (was: Jinfeng Ni) wrong plan for window function queries containing

[jira] [Commented] (DRILL-3621) Wrong results when Drill on Hbase query contains rowkey or or IN

2015-08-11 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14692374#comment-14692374 ] Jinfeng Ni commented on DRILL-3621: --- as [~amansinha100] pointed out, given the or

[jira] [Commented] (DRILL-3621) Wrong results when Drill on Hbase query contains rowkey or or IN

2015-08-11 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14692564#comment-14692564 ] Jinfeng Ni commented on DRILL-3621: --- I have a patch which seems to fix the problem.

[jira] [Comment Edited] (DRILL-3621) Wrong results when Drill on Hbase query contains rowkey or or IN

2015-08-10 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14680800#comment-14680800 ] Jinfeng Ni edited comment on DRILL-3621 at 8/10/15 9:34 PM: I

[jira] [Commented] (DRILL-3621) Wrong results when Drill on Hbase query contains rowkey or or IN

2015-08-10 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3621?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14680800#comment-14680800 ] Jinfeng Ni commented on DRILL-3621: --- I think the incorrect query result is caused by the

[jira] [Updated] (DRILL-3613) Partition Pruning not taking effect when we use a round function and a cast on top of it

2015-08-06 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3613?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3613: -- Assignee: Aman Sinha (was: Jinfeng Ni) Partition Pruning not taking effect when we use a round

[jira] [Commented] (DRILL-3560) Make partition pruning work for directory queries

2015-08-04 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14653902#comment-14653902 ] Jinfeng Ni commented on DRILL-3560: --- Copied from drill users list: {code} select

[jira] [Commented] (DRILL-3560) Enhance partition pruning for functions and expressions

2015-08-04 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3560?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14653970#comment-14653970 ] Jinfeng Ni commented on DRILL-3560: --- Yes, the change of title of this JIRA makes sense.

[jira] [Updated] (DRILL-2852) CASTing the column 'dir0' in view causes partition pruning to fail

2015-07-31 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2852?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2852: -- Priority: Blocker (was: Major) CASTing the column 'dir0' in view causes partition pruning to fail

[jira] [Updated] (DRILL-2852) CASTing the column 'dir0' in view causes partition pruning to fail

2015-07-31 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2852?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2852: -- Fix Version/s: (was: 1.3.0) 1.2.0 CASTing the column 'dir0' in view causes

[jira] [Closed] (DRILL-3591) Partition pruning hit AssertionError when a cast function is used in comparison operand

2015-07-31 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3591?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni closed DRILL-3591. - Resolution: Fixed Partition pruning hit AssertionError when a cast function is used in comparison

[jira] [Created] (DRILL-3591) Partition pruning hit AssertionError when a cast function is used in comparison operand

2015-07-31 Thread Jinfeng Ni (JIRA)
Jinfeng Ni created DRILL-3591: - Summary: Partition pruning hit AssertionError when a cast function is used in comparison operand Key: DRILL-3591 URL: https://issues.apache.org/jira/browse/DRILL-3591

[jira] [Commented] (DRILL-3551) CTAS from complex Json source with schema change is not written (and hence not read back ) correctly

2015-07-29 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3551?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14646235#comment-14646235 ] Jinfeng Ni commented on DRILL-3551: --- I think Parth put the way how to re-produce the

[jira] [Commented] (DRILL-3412) Projections are not getting push down below Window operator

2015-07-27 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14643589#comment-14643589 ] Jinfeng Ni commented on DRILL-3412: --- Why does DRILL-3304 have anything to with project

[jira] [Commented] (DRILL-3542) Rebase Drill on Calcite 1.4.0 release

2015-07-25 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3542?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14641778#comment-14641778 ] Jinfeng Ni commented on DRILL-3542: --- It is targeting for 1.2.0 release. Rebase Drill

[jira] [Updated] (DRILL-3542) Rebase Drill on Calcite 1.4.0 release

2015-07-25 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3542?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3542: -- Fix Version/s: 1.2.0 Rebase Drill on Calcite 1.4.0 release -

[jira] [Commented] (DRILL-3533) null values in a sub-structure in Parquet returns unexpected/misleading results

2015-07-22 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3533?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14637484#comment-14637484 ] Jinfeng Ni commented on DRILL-3533: --- Can you check the content of

[jira] [Commented] (DRILL-3412) Projections are not getting push down below Window operator

2015-07-22 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3412?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14637569#comment-14637569 ] Jinfeng Ni commented on DRILL-3412: --- Although there is big impact for window functions

[jira] [Commented] (DRILL-3533) null values in a sub-structure in Parquet returns unexpected/misleading results

2015-07-22 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3533?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14637013#comment-14637013 ] Jinfeng Ni commented on DRILL-3533: --- I will post the patch for review today. If the

[jira] [Commented] (DRILL-3533) null values in a sub-structure in Parquet returns unexpected/misleading results

2015-07-21 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3533?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14636073#comment-14636073 ] Jinfeng Ni commented on DRILL-3533: --- The plan for the query against parquet file seems

[jira] [Assigned] (DRILL-3533) null values in a sub-structure in Parquet returns unexpected/misleading results

2015-07-21 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3533?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni reassigned DRILL-3533: - Assignee: Jinfeng Ni (was: Hanifi Gunes) null values in a sub-structure in Parquet returns

[jira] [Commented] (DRILL-1651) Allow Filter to push past Project with ITEM operator

2015-07-21 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1651?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14635726#comment-14635726 ] Jinfeng Ni commented on DRILL-1651: --- [~amansinha100], could you please review the pull

[jira] [Updated] (DRILL-3509) Empty JSON files trigger exception when used in a union

2015-07-17 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3509?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3509: -- Fix Version/s: 1.2.0 Empty JSON files trigger exception when used in a union

[jira] [Updated] (DRILL-3509) Empty JSON files trigger exception when used in a union

2015-07-17 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3509?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3509: -- Assignee: Sean Hsuan-Yi Chu (was: Jinfeng Ni) Empty JSON files trigger exception when used in a union

[jira] [Updated] (DRILL-3508) Selecting from an empty directory in a union failes

2015-07-17 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3508?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3508: -- Fix Version/s: 1.2.0 Selecting from an empty directory in a union failes

[jira] [Updated] (DRILL-3508) Selecting from an empty directory in a union failes

2015-07-17 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3508?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3508: -- Assignee: Sean Hsuan-Yi Chu (was: Jinfeng Ni) Selecting from an empty directory in a union failes

[jira] [Updated] (DRILL-3156) Calcite tracing is broken in Drill

2015-07-13 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3156?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3156: -- Attachment: 0001-DRILL-3156-Fix-Calcite-trace-by-registering-RelMetad.patch Calcite tracing is broken

[jira] [Updated] (DRILL-3156) Calcite tracing is broken in Drill

2015-07-13 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3156?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3156: -- Assignee: Aman Sinha (was: Jinfeng Ni) Calcite tracing is broken in Drill

[jira] [Commented] (DRILL-3156) Calcite tracing is broken in Drill

2015-07-13 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3156?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14625335#comment-14625335 ] Jinfeng Ni commented on DRILL-3156: --- [~amansinha100], could you please review the patch

[jira] [Commented] (DRILL-3156) Calcite tracing is broken in Drill

2015-07-13 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3156?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14625333#comment-14625333 ] Jinfeng Ni commented on DRILL-3156: --- The cause of this problem seems to be that the

[jira] [Updated] (DRILL-2929) Join query does not return results/error/exception, appears to be hung

2015-07-11 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2929?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2929: -- Fix Version/s: (was: 1.2.0) 1.4.0 Join query does not return

<    1   2   3   4   5   6   7   8   9   >