[jira] [Assigned] (DRILL-5775) Select * query on a maprdb binary table fails

2017-09-12 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5775?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni reassigned DRILL-5775: - Assignee: Jinfeng Ni > Select * query on a maprdb binary table fails > --

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

2017-09-12 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5532?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16163935#comment-16163935 ] Jinfeng Ni commented on DRILL-5532: --- DRILL-5468 is a similar issue, where the commit 84

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

2017-09-12 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5532?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16163928#comment-16163928 ] Jinfeng Ni commented on DRILL-5532: --- This seems to be exposing a problem in execution ti

[jira] [Commented] (DRILL-1162) 25 way join ended up with OOM

2017-09-09 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1162?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16160233#comment-16160233 ] Jinfeng Ni commented on DRILL-1162: --- This OOM problem exposes two problems. The first on

[jira] [Commented] (DRILL-5769) IndexOutOfBoundsException when querying JSON files

2017-09-07 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5769?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16157872#comment-16157872 ] Jinfeng Ni commented on DRILL-5769: --- In JSON dataset, `assetData.debt.couponPaymentFeatu

[jira] [Commented] (DRILL-5769) IndexOutOfBoundsException when querying JSON files

2017-09-07 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5769?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16157860#comment-16157860 ] Jinfeng Ni commented on DRILL-5769: --- I can reproduce this problem with the following opt

[jira] [Created] (DRILL-5773) Project pushdown into a subquery with select *

2017-09-07 Thread Jinfeng Ni (JIRA)
Jinfeng Ni created DRILL-5773: - Summary: Project pushdown into a subquery with select * Key: DRILL-5773 URL: https://issues.apache.org/jira/browse/DRILL-5773 Project: Apache Drill Issue Type: Imp

[jira] [Assigned] (DRILL-5769) IndexOutOfBoundsException when querying JSON files

2017-09-05 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5769?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni reassigned DRILL-5769: - Assignee: Jinfeng Ni > IndexOutOfBoundsException when querying JSON files > -

[jira] [Commented] (DRILL-5769) IndexOutOfBoundsException when querying JSON files

2017-09-05 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5769?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16154562#comment-16154562 ] Jinfeng Ni commented on DRILL-5769: --- Thanks for providing the reproduce sample dataset.

[jira] [Commented] (DRILL-4255) SELECT DISTINCT query over JSON data returns UNSUPPORTED OPERATION

2017-09-05 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4255?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16154488#comment-16154488 ] Jinfeng Ni commented on DRILL-4255: --- I think this issue was fixed by patch for DRILL-554

[jira] [Resolved] (DRILL-4255) SELECT DISTINCT query over JSON data returns UNSUPPORTED OPERATION

2017-09-05 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4255?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-4255. --- Resolution: Fixed Fix Version/s: 1.12.0 > SELECT DISTINCT query over JSON data returns UNSUPPOR

[jira] [Resolved] (DRILL-4686) Aggregation query over HBase table results in IllegalStateException: Failure while reading vector

2017-09-05 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4686?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-4686. --- Resolution: Fixed Fix Version/s: 1.12.0 Fixed as part of patch for DRILL-5546. commit id : fde

[jira] [Resolved] (DRILL-4734) Query against HBase table on a 5 node cluster fails with SchemaChangeException

2017-09-05 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4734?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-4734. --- Resolution: Fixed Fix Version/s: 1.12.0 Although I could not get enough information to reproduc

[jira] [Commented] (DRILL-5185) Union all not passing type info when the output contains 0 rows

2017-09-05 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5185?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16154477#comment-16154477 ] Jinfeng Ni commented on DRILL-5185: --- Run against commit id : fde0a1df1734e0742b49aabdd28

[jira] [Resolved] (DRILL-5185) Union all not passing type info when the output contains 0 rows

2017-09-05 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5185?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-5185. --- Resolution: Fixed Fix Version/s: 1.12.0 Fixed as part of DRILL-5546. Commit id: fde0a1df1734e07

[jira] [Resolved] (DRILL-5464) Fix JSON reader when it deals with empty file

2017-09-05 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5464?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-5464. --- Resolution: Fixed Fix Version/s: 1.12.0 Fixed as a part of patch for DRILL-5546, commit id: fd

[jira] [Resolved] (DRILL-5327) Hash aggregate can return empty batch which can cause schema change exception

2017-09-05 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5327?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-5327. --- Resolution: Fixed Fix Version/s: 1.12.0 Fixed as part of patch for DRILL-5546. Commit id: fde0

[jira] [Comment Edited] (DRILL-5327) Hash aggregate can return empty batch which can cause schema change exception

2017-09-05 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5327?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16154461#comment-16154461 ] Jinfeng Ni edited comment on DRILL-5327 at 9/5/17 10:18 PM: I

[jira] [Commented] (DRILL-5327) Hash aggregate can return empty batch which can cause schema change exception

2017-09-05 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5327?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16154461#comment-16154461 ] Jinfeng Ni commented on DRILL-5327: --- I run tpcds query66 on scale factor 1 parquet datas

[jira] [Resolved] (DRILL-5480) Empty batch returning from HBase may cause SchemChangeException even when data does not have different schema

2017-09-05 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5480?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-5480. --- Resolution: Fixed Fix Version/s: 1.12.0 Mark it resolved, as the issue was fixed as part of DRI

[jira] [Updated] (DRILL-5480) Empty batch returning from HBase may cause SchemChangeException even when data does not have different schema

2017-09-05 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5480?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-5480: -- Summary: Empty batch returning from HBase may cause SchemChangeException even when data does not have di

[jira] [Commented] (DRILL-5480) Empty batch returning from HBase may cause SchemChangeException or incorrect query result

2017-09-05 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5480?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16154452#comment-16154452 ] Jinfeng Ni commented on DRILL-5480: --- Run the above two queries on the patch of DRILL-554

[jira] [Resolved] (DRILL-5546) Schema change problems caused by empty batch

2017-09-05 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5546?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-5546. --- Resolution: Fixed Fix Version/s: 1.12.0 Fixed in commit: fde0a1df1734e0742b49aabdd28b02202ee2b0

[jira] [Created] (DRILL-5768) Drill planer should not allow select * with group by clause

2017-09-05 Thread Jinfeng Ni (JIRA)
Jinfeng Ni created DRILL-5768: - Summary: Drill planer should not allow select * with group by clause Key: DRILL-5768 URL: https://issues.apache.org/jira/browse/DRILL-5768 Project: Apache Drill I

[jira] [Created] (DRILL-5754) Test framework does not enforce column orders

2017-08-30 Thread Jinfeng Ni (JIRA)
Jinfeng Ni created DRILL-5754: - Summary: Test framework does not enforce column orders Key: DRILL-5754 URL: https://issues.apache.org/jira/browse/DRILL-5754 Project: Apache Drill Issue Type: Bug

[jira] [Created] (DRILL-5747) Drill should put directory name field in same sequence w.r.t regular column for select * query

2017-08-28 Thread Jinfeng Ni (JIRA)
Jinfeng Ni created DRILL-5747: - Summary: Drill should put directory name field in same sequence w.r.t regular column for select * query Key: DRILL-5747 URL: https://issues.apache.org/jira/browse/DRILL-5747

[jira] [Resolved] (DRILL-5685) Provide a way to set common environment variable between sqlline and Drillbit differently.

2017-08-15 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-5685. --- Resolution: Fixed Fixed in ae123e166af2ddb22c79b8cb93278a66fccc3be4 > Provide a way to set common env

[jira] [Commented] (DRILL-5712) Update the pom files with dependency exclusions for commons-codec

2017-08-14 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16126810#comment-16126810 ] Jinfeng Ni commented on DRILL-5712: --- Some of the unit testcases that failed: Tests in e

[jira] [Commented] (DRILL-5712) Update the pom files with dependency exclusions for commons-codec

2017-08-14 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16126808#comment-16126808 ] Jinfeng Ni commented on DRILL-5712: --- I'm seeing both failures in unit test and functiona

[jira] [Reopened] (DRILL-5685) Provide a way to set common environment variable between sqlline and Drillbit differently.

2017-08-14 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5685?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni reopened DRILL-5685: --- > Provide a way to set common environment variable between sqlline and Drillbit > differently. >

[jira] [Updated] (DRILL-4735) Count(dir0) on parquet returns 0 result

2017-08-11 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4735?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-4735: -- Labels: ready-to-commit (was: ) > Count(dir0) on parquet returns 0 result > ---

[jira] [Commented] (DRILL-5546) Schema change problems caused by empty batch

2017-08-04 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16115154#comment-16115154 ] Jinfeng Ni commented on DRILL-5546: --- I have a work-in-progress branch. Tried the variou

[jira] [Commented] (DRILL-5327) Hash aggregate can return empty batch which can cause schema change exception

2017-08-04 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5327?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16115149#comment-16115149 ] Jinfeng Ni commented on DRILL-5327: --- I run tpcds- q66 on tpcds-sf1 text dataset on 1.11.

[jira] [Comment Edited] (DRILL-4686) Aggregation query over HBase table results in IllegalStateException: Failure while reading vector

2017-08-04 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16115140#comment-16115140 ] Jinfeng Ni edited comment on DRILL-4686 at 8/5/17 12:01 AM: I

[jira] [Commented] (DRILL-4686) Aggregation query over HBase table results in IllegalStateException: Failure while reading vector

2017-08-04 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4686?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16115140#comment-16115140 ] Jinfeng Ni commented on DRILL-4686: --- I was able to reproduce the problem on 1.11.0. Wit

[jira] [Commented] (DRILL-4255) SELECT DISTINCT query over JSON data returns UNSUPPORTED OPERATION

2017-08-04 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4255?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16115103#comment-16115103 ] Jinfeng Ni commented on DRILL-4255: --- Seems to me the issues is same as DRILL-5464; the d

[jira] [Commented] (DRILL-5185) Union all not passing type info when the output contains 0 rows

2017-08-04 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5185?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16115068#comment-16115068 ] Jinfeng Ni commented on DRILL-5185: --- Run against a patch for DRILL-5466. The query, whic

[jira] [Comment Edited] (DRILL-5464) Fix JSON reader when it deals with empty file

2017-08-04 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5464?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16115064#comment-16115064 ] Jinfeng Ni edited comment on DRILL-5464 at 8/4/17 10:52 PM: Ru

[jira] [Commented] (DRILL-5464) Fix JSON reader when it deals with empty file

2017-08-04 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5464?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16115064#comment-16115064 ] Jinfeng Ni commented on DRILL-5464: --- Run the above query with the patch for DRILL-5546,

[jira] [Commented] (DRILL-5480) Empty batch returning from HBase may cause SchemChangeException or incorrect query result

2017-08-04 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5480?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16114919#comment-16114919 ] Jinfeng Ni commented on DRILL-5480: --- I have a branch to address the umbrella jira DRILL-

[jira] [Commented] (DRILL-5696) change default compiler strategy

2017-07-31 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5696?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16108069#comment-16108069 ] Jinfeng Ni commented on DRILL-5696: --- Can you provide more specific detail about the comp

[jira] [Commented] (DRILL-1162) 25 way join ended up with OOM

2017-07-24 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1162?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16099190#comment-16099190 ] Jinfeng Ni commented on DRILL-1162: --- {quote} I found that in many cases right operator o

[jira] [Commented] (DRILL-1162) 25 way join ended up with OOM

2017-07-24 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1162?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16099172#comment-16099172 ] Jinfeng Ni commented on DRILL-1162: --- Let me explain a little of background about DRILL-2

[jira] [Assigned] (DRILL-5667) Project operator would change output field order if convertfromJSON is used

2017-07-21 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5667?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni reassigned DRILL-5667: - Assignee: Jinfeng Ni > Project operator would change output field order if convertfromJSON is use

[jira] [Assigned] (DRILL-5681) Incorrect query result when query uses star and correlated subquery

2017-07-20 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5681?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni reassigned DRILL-5681: - Assignee: Jinfeng Ni > Incorrect query result when query uses star and correlated subquery >

[jira] [Assigned] (DRILL-5683) Incorrect query result when query uses NOT(IS NOT NULL) expression

2017-07-20 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni reassigned DRILL-5683: - Assignee: Jinfeng Ni > Incorrect query result when query uses NOT(IS NOT NULL) expression >

[jira] [Updated] (DRILL-5683) Incorrect query result when query uses NOT(IS NOT NULL) expression

2017-07-20 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5683?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-5683: -- Description: The following repo was modified from a testcase provided by Arjun Rajan(ara...@mapr.com).

[jira] [Created] (DRILL-5683) Incorrect query result when query uses NOT(IS NOT NULL) expression

2017-07-20 Thread Jinfeng Ni (JIRA)
Jinfeng Ni created DRILL-5683: - Summary: Incorrect query result when query uses NOT(IS NOT NULL) expression Key: DRILL-5683 URL: https://issues.apache.org/jira/browse/DRILL-5683 Project: Apache Drill

[jira] [Commented] (DRILL-5681) Incorrect query result when query uses star and correlated subquery

2017-07-20 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5681?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16095433#comment-16095433 ] Jinfeng Ni commented on DRILL-5681: --- The incorrect query result was caused by a wrong qu

[jira] [Created] (DRILL-5681) Incorrect query result when query uses star and correlated subquery

2017-07-20 Thread Jinfeng Ni (JIRA)
Jinfeng Ni created DRILL-5681: - Summary: Incorrect query result when query uses star and correlated subquery Key: DRILL-5681 URL: https://issues.apache.org/jira/browse/DRILL-5681 Project: Apache Drill

[jira] [Commented] (DRILL-4735) Count(dir0) on parquet returns 0 result

2017-07-17 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4735?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16090177#comment-16090177 ] Jinfeng Ni commented on DRILL-4735: --- [~arina], the proposal looks good to me. It's great

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

2017-07-13 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16086558#comment-16086558 ] Jinfeng Ni commented on DRILL-5468: --- [~amansinha100], thanks. I think Option 1 makes sen

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

2017-07-13 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16086540#comment-16086540 ] Jinfeng Ni commented on DRILL-5468: --- Looks like we have a couple of options: - Option 1

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

2017-07-13 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16086530#comment-16086530 ] Jinfeng Ni commented on DRILL-5468: --- [~amansinha100], turns out that the reason Drill di

[jira] [Commented] (DRILL-5660) Drill 1.10 queries fail due to Parquet Metadata "corruption" from DRILL-3867

2017-07-12 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16084875#comment-16084875 ] Jinfeng Ni commented on DRILL-5660: --- I'm more concerned about backward compatibility : c

[jira] [Commented] (DRILL-5660) Drill 1.10 queries fail due to Parquet Metadata "corruption" from DRILL-3867

2017-07-12 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16084777#comment-16084777 ] Jinfeng Ni commented on DRILL-5660: --- I thought you are asking for change to make Drill1.

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

2017-07-12 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16084522#comment-16084522 ] Jinfeng Ni commented on DRILL-5468: --- [~amansinha100], you are right that the HAVING pred

[jira] [Commented] (DRILL-5547) Drill config options and session options do not work as intended

2017-07-12 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5547?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16084402#comment-16084402 ] Jinfeng Ni commented on DRILL-5547: --- I have not looked into the detail. I have a general

[jira] [Commented] (DRILL-5660) Drill 1.10 queries fail due to Parquet Metadata "corruption" from DRILL-3867

2017-07-12 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16084373#comment-16084373 ] Jinfeng Ni commented on DRILL-5660: --- Correct me if I'm wrong. I thought the goal for par

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

2017-07-12 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16084309#comment-16084309 ] Jinfeng Ni commented on DRILL-5468: --- The difference between the plan prior to DRILL-4678

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

2017-07-11 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16083099#comment-16083099 ] Jinfeng Ni commented on DRILL-5468: --- The performance regression was caused by a plan cha

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

2017-07-11 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5468?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16082600#comment-16082600 ] Jinfeng Ni commented on DRILL-5468: --- I'll start looking into this performance regression

[jira] [Created] (DRILL-5667) Project operator would change output field order if convertfromJSON is used

2017-07-10 Thread Jinfeng Ni (JIRA)
Jinfeng Ni created DRILL-5667: - Summary: Project operator would change output field order if convertfromJSON is used Key: DRILL-5667 URL: https://issues.apache.org/jira/browse/DRILL-5667 Project: Apache

[jira] [Updated] (DRILL-5165) wrong results - LIMIT ALL and OFFSET clause in same query

2017-07-05 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5165?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-5165: -- Labels: ready-to-commit (was: ) > wrong results - LIMIT ALL and OFFSET clause in same query > -

[jira] [Commented] (DRILL-5336) Columns returned by select over CTAS created parquet are not in correct order.

2017-06-22 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5336?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16059962#comment-16059962 ] Jinfeng Ni commented on DRILL-5336: --- Such behavior is a result of using select * from a

[jira] [Commented] (DRILL-5211) Queries fail due to direct memory fragmentation

2017-06-16 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5211?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16052193#comment-16052193 ] Jinfeng Ni commented on DRILL-5211: --- My 2cents: I could understand the cause of direct

[jira] [Assigned] (DRILL-5586) UnionAll operator does more than necessary value vector allocation and copy

2017-06-13 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5586?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni reassigned DRILL-5586: - Assignee: Jinfeng Ni > UnionAll operator does more than necessary value vector allocation and cop

[jira] [Created] (DRILL-5586) UnionAll operator does more than necessary value vector allocation and copy

2017-06-13 Thread Jinfeng Ni (JIRA)
Jinfeng Ni created DRILL-5586: - Summary: UnionAll operator does more than necessary value vector allocation and copy Key: DRILL-5586 URL: https://issues.apache.org/jira/browse/DRILL-5586 Project: Apache D

[jira] [Created] (DRILL-5585) UnionAll operator generates run-time code for every incoming batch

2017-06-13 Thread Jinfeng Ni (JIRA)
Jinfeng Ni created DRILL-5585: - Summary: UnionAll operator generates run-time code for every incoming batch Key: DRILL-5585 URL: https://issues.apache.org/jira/browse/DRILL-5585 Project: Apache Drill

[jira] [Commented] (DRILL-5538) Exclude ProjectRemoveRule during PHYSICAL phase if it comes from storage plugins

2017-06-12 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16047230#comment-16047230 ] Jinfeng Ni commented on DRILL-5538: --- I put some comments and analysis in CALCITE-1584.

[jira] [Assigned] (DRILL-5581) Query with CASE statement returns wrong results

2017-06-12 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5581?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni reassigned DRILL-5581: - Assignee: Jinfeng Ni > Query with CASE statement returns wrong results >

[jira] [Commented] (DRILL-5547) Drill config options and session options do not work as intended

2017-06-09 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5547?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16045083#comment-16045083 ] Jinfeng Ni commented on DRILL-5547: --- What discussed here seems to be initialization of s

[jira] [Comment Edited] (DRILL-5546) Schema change problems caused by empty batch

2017-06-05 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16037290#comment-16037290 ] Jinfeng Ni edited comment on DRILL-5546 at 6/5/17 6:40 PM: --- Than

[jira] [Commented] (DRILL-5546) Schema change problems caused by empty batch

2017-06-05 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16037290#comment-16037290 ] Jinfeng Ni commented on DRILL-5546: --- Thanks for putting a set of form definitions of ter

[jira] [Resolved] (DRILL-5485) Remove WebServer dependency on DrillClient

2017-06-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5485?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-5485. --- Resolution: Fixed Fixed in 874bf6296dcd1a42c7cf7f097c1a6b5458010cbb > Remove WebServer dependency on

[jira] [Commented] (DRILL-5229) Upgrade kudu client to org.apache.kudu:kudu-client:1.2.0

2017-06-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5229?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16035827#comment-16035827 ] Jinfeng Ni commented on DRILL-5229: --- Committer is [~sudheeshkatkam] (lost the trace afte

[jira] [Commented] (DRILL-5356) Refactor Parquet Record Reader

2017-06-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5356?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16035823#comment-16035823 ] Jinfeng Ni commented on DRILL-5356: --- Committer is [~sudheeshkatkam] (lost the trace afte

[jira] [Commented] (DRILL-5379) Set Hdfs Block Size based on Parquet Block Size

2017-06-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5379?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16035821#comment-16035821 ] Jinfeng Ni commented on DRILL-5379: --- Committer is [~sudheeshkatkam] (lost the trace afte

[jira] [Commented] (DRILL-5481) Allow Drill to persist profiles in-memory only with a max capacity

2017-06-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5481?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16035819#comment-16035819 ] Jinfeng Ni commented on DRILL-5481: --- Committer is [~sudheeshkatkam] (lost the trace afte

[jira] [Commented] (DRILL-5533) Fix flag assignment in FunctionInitializer.checkInit() method

2017-06-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5533?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16035816#comment-16035816 ] Jinfeng Ni commented on DRILL-5533: --- Committer is [~sudheeshkatkam] (lost the trace afte

[jira] [Commented] (DRILL-5512) Standardize error handling in ScanBatch

2017-06-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5512?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16035817#comment-16035817 ] Jinfeng Ni commented on DRILL-5512: --- Committer is [~sudheeshkatkam] (lost the trace afte

[jira] [Commented] (DRILL-5546) Schema change problems caused by empty batch

2017-06-02 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16035221#comment-16035221 ] Jinfeng Ni commented on DRILL-5546: --- Thanks for reviewing the proposal. Some clarifica

[jira] [Updated] (DRILL-5485) Remove WebServer dependency on DrillClient

2017-06-01 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5485?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-5485: -- Labels: ready-to-commit (was: ) > Remove WebServer dependency on DrillClient >

[jira] [Commented] (DRILL-5559) Incorrect query result when querying json files with schema change

2017-05-31 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5559?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16031982#comment-16031982 ] Jinfeng Ni commented on DRILL-5559: --- The build is today's master branch, with commit id

[jira] [Created] (DRILL-5559) Incorrect query result when querying json files with schema change

2017-05-31 Thread Jinfeng Ni (JIRA)
Jinfeng Ni created DRILL-5559: - Summary: Incorrect query result when querying json files with schema change Key: DRILL-5559 URL: https://issues.apache.org/jira/browse/DRILL-5559 Project: Apache Drill

[jira] [Commented] (DRILL-5525) Inconsistent, unhelpful semantics for batch, field schema comparison

2017-05-30 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5525?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16030337#comment-16030337 ] Jinfeng Ni commented on DRILL-5525: --- At least one issue has been opened for BatchSchema/

[jira] [Commented] (DRILL-5538) Exclude ProjectRemoveRule during PHYSICAL phase if it comes from storage plugins

2017-05-30 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5538?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16029868#comment-16029868 ] Jinfeng Ni commented on DRILL-5538: --- Thanks for finding CALCITE-1584, [~arina]. It seem

[jira] [Commented] (DRILL-5556) Drill allows "SELECT *, *" query

2017-05-30 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5556?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16029852#comment-16029852 ] Jinfeng Ni commented on DRILL-5556: --- When same columns appear twice in Select list, Dril

[jira] [Commented] (DRILL-5556) Drill allows "SELECT *, *" query

2017-05-30 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5556?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16029842#comment-16029842 ] Jinfeng Ni commented on DRILL-5556: --- Agreed with [~amansinha100] that *, * is correct in

[jira] [Updated] (DRILL-5537) Display columns alias for queries with sum() when RDBMS storage plugin is enabled

2017-05-30 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5537?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-5537: -- Labels: ready-to-commit (was: ) > Display columns alias for queries with sum() when RDBMS storage plugi

[jira] [Commented] (DRILL-5537) Display columns alias for queries with sum() when RDBMS storage plugin is enabled

2017-05-30 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16029831#comment-16029831 ] Jinfeng Ni commented on DRILL-5537: --- Thanks for posting the explain plan output, [~arina

[jira] [Commented] (DRILL-5537) Display columns alias for queries with sum() when RDBMS storage plugin is enabled

2017-05-26 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5537?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16026925#comment-16026925 ] Jinfeng Ni commented on DRILL-5537: --- >From the change made in the PR, I'm not clear how/

[jira] [Commented] (DRILL-5546) Schema change problems caused by empty batch

2017-05-26 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16026901#comment-16026901 ] Jinfeng Ni commented on DRILL-5546: --- Link to the proposal draft in google doc: https://

[jira] [Commented] (DRILL-5546) Schema change problems caused by empty batch

2017-05-26 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5546?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16026896#comment-16026896 ] Jinfeng Ni commented on DRILL-5546: --- h2. Scope and Motivation Several Drill operators s

[jira] [Created] (DRILL-5546) Schema change problems caused by empty batch

2017-05-26 Thread Jinfeng Ni (JIRA)
Jinfeng Ni created DRILL-5546: - Summary: Schema change problems caused by empty batch Key: DRILL-5546 URL: https://issues.apache.org/jira/browse/DRILL-5546 Project: Apache Drill Issue Type: Bug

[jira] [Updated] (DRILL-5140) Fix CompileException in run-time generated code when record batch has large number of fields.

2017-05-26 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5140?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-5140: -- Labels: ready-to-commit (was: ) > Fix CompileException in run-time generated code when record batch has

[jira] [Commented] (DRILL-5542) Scan unnecessary adds implicit columns to ScanRecordBatch for select * query

2017-05-26 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5542?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16026333#comment-16026333 ] Jinfeng Ni commented on DRILL-5542: --- Sounds like planner should differentiate "*" and im

[jira] [Comment Edited] (DRILL-5542) Scan unnecessary adds implicit columns to ScanRecordBatch for select * query

2017-05-26 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5542?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16026333#comment-16026333 ] Jinfeng Ni edited comment on DRILL-5542 at 5/26/17 2:35 PM: So

[jira] [Created] (DRILL-5542) Scan unnecessary adds implicit columns to ScanRecordBatch for select * query

2017-05-25 Thread Jinfeng Ni (JIRA)
Jinfeng Ni created DRILL-5542: - Summary: Scan unnecessary adds implicit columns to ScanRecordBatch for select * query Key: DRILL-5542 URL: https://issues.apache.org/jira/browse/DRILL-5542 Project: Apache

[jira] [Commented] (DRILL-5480) Empty batch returning from HBase may cause SchemChangeException or incorrect query result

2017-05-18 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5480?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16016674#comment-16016674 ] Jinfeng Ni commented on DRILL-5480: --- Another case where hbase has 3 regions with the las

  1   2   3   4   5   6   7   8   9   10   >