[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 funct

[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 rowk

[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-tabpanel&focusedCommentId=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-tabpanel&focusedCommentId=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 functi

[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-tabpanel&focusedCommentId=14653970#comment-14653970 ] Jinfeng Ni commented on DRILL-3560: --- Yes, the change of title of this JIRA makes sense.

[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-tabpanel&focusedCommentId=14653902#comment-14653902 ] Jinfeng Ni commented on DRILL-3560: --- Copied from drill users list: {code} select count(

[jira] [Commented] (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:comment-tabpanel&focusedCommentId=14650033#comment-14650033 ] Jinfeng Ni commented on DRILL-2852: --- Mark it as Blocker, since Calcite 1.4.0-SNAPSHOT wi

[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 part

[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 ope

[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 Proje

[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-tabpanel&focusedCommentId=14646235#comment-14646235 ] Jinfeng Ni commented on DRILL-3551: --- I think Parth put the way how to re-produce the pro

[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-tabpanel&focusedCommentId=14643589#comment-14643589 ] Jinfeng Ni commented on DRILL-3412: --- Why does DRILL-3304 have anything to with project p

[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-tabpanel&focusedCommentId=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-tabpanel&focusedCommentId=14637679#comment-14637679 ] Jinfeng Ni commented on DRILL-3533: --- Hi Stefán, Did you manage to have successful mvn b

[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-tabpanel&focusedCommentId=14637641#comment-14637641 ] Jinfeng Ni commented on DRILL-3533: --- The full mvn build ( mvn clean install ) will take

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

2015-07-22 Thread Jinfeng Ni (JIRA)
Jinfeng Ni created DRILL-3542: - Summary: Rebase Drill on Calcite 1.4.0 release Key: DRILL-3542 URL: https://issues.apache.org/jira/browse/DRILL-3542 Project: Apache Drill Issue Type: Bug

[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-tabpanel&focusedCommentId=14637601#comment-14637601 ] Jinfeng Ni commented on DRILL-3412: --- View with fewer columns will not help, I believe, s

[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-tabpanel&focusedCommentId=14637569#comment-14637569 ] Jinfeng Ni commented on DRILL-3412: --- Although there is big impact for window functions w

[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-tabpanel&focusedCommentId=14637484#comment-14637484 ] Jinfeng Ni commented on DRILL-3533: --- Can you check the content of /var/www/as/drill/dist

[jira] [Updated] (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:all-tabpanel ] Jinfeng Ni updated DRILL-3533: -- Assignee: Parth Chandra (was: Jinfeng Ni) > null values in a sub-structure in Parquet returns unexpecte

[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-tabpanel&focusedCommentId=14637180#comment-14637180 ] Jinfeng Ni commented on DRILL-3533: --- [~parthc], could you please review the pull request

[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-tabpanel&focusedCommentId=14637013#comment-14637013 ] Jinfeng Ni commented on DRILL-3533: --- I will post the patch for review today. If the revi

[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-tabpanel&focusedCommentId=14636073#comment-14636073 ] Jinfeng Ni commented on DRILL-3533: --- The plan for the query against parquet file seems t

[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 une

[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-tabpanel&focusedCommentId=14635726#comment-14635726 ] Jinfeng Ni commented on DRILL-1651: --- [~amansinha100], could you please review the pull r

[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] [Created] (DRILL-3510) Add ANSI_QUOTES option so that Drill's SQL Parser will recognize ANSI_SQL identifiers

2015-07-17 Thread Jinfeng Ni (JIRA)
Jinfeng Ni created DRILL-3510: - Summary: Add ANSI_QUOTES option so that Drill's SQL Parser will recognize ANSI_SQL identifiers Key: DRILL-3510 URL: https://issues.apache.org/jira/browse/DRILL-3510 Projec

[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-tabpanel&focusedCommentId=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-tabpanel&focusedCommentId=14625333#comment-14625333 ] Jinfeng Ni commented on DRILL-3156: --- The cause of this problem seems to be that the HepP

[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-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 results/error/exce

[jira] [Commented] (DRILL-2543) Correlated subquery where outer table contains NULL values returns seemingly wrong result

2015-07-10 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2543?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14622897#comment-14622897 ] Jinfeng Ni commented on DRILL-2543: --- After checking the SQL specification, I feel that r

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

2015-07-10 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: -- Fix Version/s: (was: 1.4.0) 1.2.0 > Calcite tracing is broken in Drill > ---

[jira] [Updated] (DRILL-2543) Correlated subquery where outer table contains NULL values returns seemingly wrong result

2015-07-09 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2543?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2543: -- Fix Version/s: (was: 1.2.0) 1.3.0 > Correlated subquery where outer table contain

[jira] [Commented] (DRILL-2543) Correlated subquery where outer table contains NULL values returns seemingly wrong result

2015-07-09 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2543?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14621495#comment-14621495 ] Jinfeng Ni commented on DRILL-2543: --- Looks like now the query will hit a different error

[jira] [Updated] (DRILL-2543) Correlated subquery where outer table contains NULL values returns seemingly wrong result

2015-07-09 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2543?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2543: -- Priority: Major (was: Critical) > Correlated subquery where outer table contains NULL values returns s

[jira] [Resolved] (DRILL-3463) Unit test of project pushdown in TestUnionAll should put more precisely plan attribute in plan verification.

2015-07-08 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-3463. --- Resolution: Fixed Assignee: Jinfeng Ni (was: Mehant Baid) Fixed in aa7c253a2cdb81724643675bc85f

[jira] [Resolved] (DRILL-2802) Projecting dir[n] by itself results in projecting of all columns

2015-07-08 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2802?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-2802. --- Resolution: Fixed Fixed in f4bb535374541a827dfac6ac0365fa3729be3670 > Projecting dir[n] by itself res

[jira] [Commented] (DRILL-2053) Column names are case sensitive if column is coming from WITH clause

2015-07-08 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14619947#comment-14619947 ] Jinfeng Ni commented on DRILL-2053: --- Calcite not only let a|A in case-insensitive parsin

[jira] [Commented] (DRILL-2053) Column names are case sensitive if column is coming from WITH clause

2015-07-08 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14618983#comment-14618983 ] Jinfeng Ni commented on DRILL-2053: --- [~amansinha100], since the column ambiguous issue a

[jira] [Commented] (DRILL-2053) Column names are case sensitive if column is coming from WITH clause

2015-07-08 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14618979#comment-14618979 ] Jinfeng Ni commented on DRILL-2053: --- For the ambiguous column issue, seems the root caus

[jira] [Created] (DRILL-3472) Memory leak when same alias used in the select clause of query

2015-07-08 Thread Jinfeng Ni (JIRA)
Jinfeng Ni created DRILL-3472: - Summary: Memory leak when same alias used in the select clause of query Key: DRILL-3472 URL: https://issues.apache.org/jira/browse/DRILL-3472 Project: Apache Drill

[jira] [Comment Edited] (DRILL-2053) Column names are case sensitive if column is coming from WITH clause

2015-07-07 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14617978#comment-14617978 ] Jinfeng Ni edited comment on DRILL-2053 at 7/8/15 5:05 AM: --- The

[jira] [Commented] (DRILL-2053) Column names are case sensitive if column is coming from WITH clause

2015-07-07 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14617978#comment-14617978 ] Jinfeng Ni commented on DRILL-2053: --- The ambiguous column issue probably is caused some

[jira] [Comment Edited] (DRILL-2053) Column names are case sensitive if column is coming from WITH clause

2015-07-07 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14617776#comment-14617776 ] Jinfeng Ni edited comment on DRILL-2053 at 7/8/15 1:04 AM: --- Inte

[jira] [Commented] (DRILL-2053) Column names are case sensitive if column is coming from WITH clause

2015-07-07 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14617776#comment-14617776 ] Jinfeng Ni commented on DRILL-2053: --- Interesting, on master branch, this query runs succ

[jira] [Commented] (DRILL-2053) Column names are case sensitive if column is coming from WITH clause

2015-07-07 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14617761#comment-14617761 ] Jinfeng Ni commented on DRILL-2053: --- For the query you suggested, {code} select X.A Fro

[jira] [Commented] (DRILL-2053) Column names are case sensitive if column is coming from WITH clause

2015-07-07 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14617722#comment-14617722 ] Jinfeng Ni commented on DRILL-2053: --- [~amansinha100], the query you listed seems to prod

[jira] [Commented] (DRILL-3464) Index out of bounds exception while performing concat()

2015-07-07 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3464?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14617569#comment-14617569 ] Jinfeng Ni commented on DRILL-3464: --- LGTM. +1 > Index out of bounds exception while p

[jira] [Commented] (DRILL-2053) Column names are case sensitive if column is coming from WITH clause

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

[jira] [Commented] (DRILL-2053) Column names are case sensitive if column is coming from WITH clause

2015-07-07 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14617555#comment-14617555 ] Jinfeng Ni commented on DRILL-2053: --- The root cause of this incorrect query result issue

[jira] [Updated] (DRILL-2053) Column names are case sensitive if column is coming from WITH clause

2015-07-07 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2053: -- Assignee: Aman Sinha (was: Jinfeng Ni) > Column names are case sensitive if column is coming from WITH

[jira] [Updated] (DRILL-2053) Column names are case sensitive if column is coming from WITH clause

2015-07-07 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2053?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2053: -- Attachment: 0003-DRILL-2053-Fix-incorrect-query-result-when-join-CTE-.patch > Column names are case sens

[jira] [Commented] (DRILL-3463) Unit test of project pushdown in TestUnionAll should put more precisely plan attribute in plan verification.

2015-07-07 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14617217#comment-14617217 ] Jinfeng Ni commented on DRILL-3463: --- [~mehant], could you please review this patch? Than

[jira] [Updated] (DRILL-3463) Unit test of project pushdown in TestUnionAll should put more precisely plan attribute in plan verification.

2015-07-07 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3463: -- Assignee: Mehant Baid (was: Jinfeng Ni) > Unit test of project pushdown in TestUnionAll should put more

[jira] [Updated] (DRILL-3463) Unit test of project pushdown in TestUnionAll should put more precisely plan attribute in plan verification.

2015-07-07 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3463: -- Attachment: 0001-DRILL-3463-Unit-test-of-project-pushdown-in-TestUnio.patch > Unit test of project pushd

[jira] [Updated] (DRILL-2802) Projecting dir[n] by itself results in projecting of all columns

2015-07-07 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2802?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2802: -- Assignee: Venki Korukanti (was: Jinfeng Ni) > Projecting dir[n] by itself results in projecting of all

[jira] [Commented] (DRILL-2802) Projecting dir[n] by itself results in projecting of all columns

2015-07-07 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2802?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14617074#comment-14617074 ] Jinfeng Ni commented on DRILL-2802: --- [~venki387], could you please review the patch? Tha

[jira] [Updated] (DRILL-2802) Projecting dir[n] by itself results in projecting of all columns

2015-07-07 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2802?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2802: -- Attachment: 0002-DRILL-2802-Ensure-project-the-right-columns-in-the-f.patch > Projecting dir[n] by itsel

[jira] [Commented] (DRILL-2802) Projecting dir[n] by itself results in projecting of all columns

2015-07-07 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2802?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14617062#comment-14617062 ] Jinfeng Ni commented on DRILL-2802: --- Two places seem to need fix for this incorrect quer

[jira] [Updated] (DRILL-3463) Unit test of project pushdown in TestUnionAll should put more precisely plan attribute in plan verification.

2015-07-06 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-3463: -- Fix Version/s: 1.2.0 > Unit test of project pushdown in TestUnionAll should put more precisely plan > a

[jira] [Created] (DRILL-3463) Unit test of project pushdown in TestUnionAll should put more precisely plan attribute in plan verification.

2015-07-06 Thread Jinfeng Ni (JIRA)
Jinfeng Ni created DRILL-3463: - Summary: Unit test of project pushdown in TestUnionAll should put more precisely plan attribute in plan verification. Key: DRILL-3463 URL: https://issues.apache.org/jira/browse/DRILL-

[jira] [Updated] (DRILL-2747) Implicit cast in filters fails if enclosed literal has leading or trailing spaces

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2747?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2747: -- Assignee: Mehant Baid (was: Jinfeng Ni) > Implicit cast in filters fails if enclosed literal has leadin

[jira] [Updated] (DRILL-1677) Table aliases are not shown in the Scan node of Explain plan

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1677?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-1677: -- Fix Version/s: (was: 1.2.0) 1.3.0 > Table aliases are not shown in the Scan node

[jira] [Updated] (DRILL-2175) Provide an option to not display the list of files in the physical plan

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2175?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2175: -- Fix Version/s: (was: 1.2.0) 1.3.0 > Provide an option to not display the list of

[jira] [Commented] (DRILL-2454) Support for local join filter in outer joins

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2454?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14612634#comment-14612634 ] Jinfeng Ni commented on DRILL-2454: --- Assign to Aman, as he worked on Cartesian Join. Th

[jira] [Updated] (DRILL-2454) Support for local join filter in outer joins

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2454?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2454: -- Assignee: Aman Sinha (was: Jinfeng Ni) > Support for local join filter in outer joins > ---

[jira] [Updated] (DRILL-2655) Hash join is chosen when join columns are sorted in the same order

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2655?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2655: -- Fix Version/s: (was: 1.2.0) 1.4.0 > Hash join is chosen when join columns are sor

[jira] [Commented] (DRILL-2655) Hash join is chosen when join columns are sorted in the same order

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2655?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14612631#comment-14612631 ] Jinfeng Ni commented on DRILL-2655: --- The reason for the additional sort, or use hash-joi

[jira] [Updated] (DRILL-2369) It takes too long to plan inner join query with 10 join predicates

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2369?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2369: -- Fix Version/s: (was: 1.2.0) 1.4.0 > It takes too long to plan inner join query wi

[jira] [Updated] (DRILL-2702) Support more advanced constant expression folding

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2702?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2702: -- Fix Version/s: (was: 1.2.0) Future > Support more advanced constant expression fo

[jira] [Commented] (DRILL-2607) TPC-DS query 71 and simplified variant on parquet views fails with IOBE

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14612613#comment-14612613 ] Jinfeng Ni commented on DRILL-2607: --- The error log indicates the IOOB happens in executi

[jira] [Updated] (DRILL-2607) TPC-DS query 71 and simplified variant on parquet views fails with IOBE

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2607: -- Assignee: Chris Westin (was: Jinfeng Ni) > TPC-DS query 71 and simplified variant on parquet views fail

[jira] [Updated] (DRILL-2607) TPC-DS query 71 and simplified variant on parquet views fails with IOBE

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2607: -- Component/s: (was: Query Planning & Optimization) Execution - Relational Operators

[jira] [Resolved] (DRILL-2735) Broadcast plan get's "lost" when the same query is used in UNION ALL

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2735?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-2735. --- Resolution: Fixed > Broadcast plan get's "lost" when the same query is used in UNION ALL > ---

[jira] [Commented] (DRILL-2735) Broadcast plan get's "lost" when the same query is used in UNION ALL

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14612596#comment-14612596 ] Jinfeng Ni commented on DRILL-2735: --- I do not have the j1 data. But I tried with a diffe

[jira] [Commented] (DRILL-2751) Implicit cast in filters fails if some literals in an expression are enclosed in quotes.

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2751?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14612578#comment-14612578 ] Jinfeng Ni commented on DRILL-2751: --- The cases in this JIRA seems not a common one. Plus

[jira] [Updated] (DRILL-2751) Implicit cast in filters fails if some literals in an expression are enclosed in quotes.

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2751?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2751: -- Fix Version/s: (was: 1.2.0) 1.4.0 > Implicit cast in filters fails if some litera

[jira] [Commented] (DRILL-2770) Aggregate query returns AssertionError: star should have been expanded

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14612563#comment-14612563 ] Jinfeng Ni commented on DRILL-2770: --- Could you please re-run the query, and update the s

[jira] [Updated] (DRILL-2770) Aggregate query returns AssertionError: star should have been expanded

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2770?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2770: -- Assignee: Khurram Faraaz (was: Jinfeng Ni) > Aggregate query returns AssertionError: star should have b

[jira] [Resolved] (DRILL-2777) CTAS, order by and flatten of repeated list result in ExpandConversionRule error

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2777?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-2777. --- Resolution: Fixed > CTAS, order by and flatten of repeated list result in ExpandConversionRule > erro

[jira] [Commented] (DRILL-2777) CTAS, order by and flatten of repeated list result in ExpandConversionRule error

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14612540#comment-14612540 ] Jinfeng Ni commented on DRILL-2777: --- The query in the CTAS is not valid, as Drill does n

[jira] [Updated] (DRILL-2785) Aggregate MAX query on a directory fails with SQLException

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2785?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2785: -- Assignee: Steven Phillips (was: Jinfeng Ni) > Aggregate MAX query on a directory fails with SQLExceptio

[jira] [Commented] (DRILL-2789) Query fails when text-specific syntax is used on non-text formats.

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2789?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14612520#comment-14612520 ] Jinfeng Ni commented on DRILL-2789: --- Could you please post the sample data that you used

[jira] [Updated] (DRILL-2789) Query fails when text-specific syntax is used on non-text formats.

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2789?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2789: -- Assignee: Abhishek Girish (was: Jinfeng Ni) > Query fails when text-specific syntax is used on non-text

[jira] [Commented] (DRILL-2790) Implicit cast to numbers fails when Text data contains empty strings

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2790?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14612517#comment-14612517 ] Jinfeng Ni commented on DRILL-2790: --- The feature to ignore illegal formated number strin

[jira] [Updated] (DRILL-2790) Implicit cast to numbers fails when Text data contains empty strings

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2790?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2790: -- Fix Version/s: (was: 1.2.0) Future > Implicit cast to numbers fails when Text dat

[jira] [Updated] (DRILL-2790) Implicit cast to numbers fails when Text data contains empty strings

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2790?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2790: -- Issue Type: Improvement (was: Bug) > Implicit cast to numbers fails when Text data contains empty strin

[jira] [Updated] (DRILL-2790) Implicit cast to numbers fails when Text data contains empty strings

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2790?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2790: -- Priority: Minor (was: Major) > Implicit cast to numbers fails when Text data contains empty strings >

[jira] [Commented] (DRILL-2802) Projecting dir[n] by itself results in projecting of all columns

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2802?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14612504#comment-14612504 ] Jinfeng Ni commented on DRILL-2802: --- Upgraded to Critical, since it's wrong result. Che

[jira] [Updated] (DRILL-2802) Projecting dir[n] by itself results in projecting of all columns

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2802?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2802: -- Priority: Critical (was: Major) > Projecting dir[n] by itself results in projecting of all columns > --

[jira] [Updated] (DRILL-2859) Unexpected exception in the query with an interval data type

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2859?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2859: -- Fix Version/s: (was: 1.2.0) 1.3.0 > Unexpected exception in the query with an int

[jira] [Updated] (DRILL-2900) Joins are not getting parallelized in TestTpchDistributed unit tests

2015-07-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2900?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2900: -- Fix Version/s: (was: 1.2.0) 1.3.0 > Joins are not getting parallelized in TestTpc

<    1   2   3   4   5   6   7   8   9   10   >