[jira] [Updated] (DRILL-4678) Tune metadata by generating a dispatcher at runtime

2017-03-22 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4678?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-4678: - Summary: Tune metadata by generating a dispatcher at runtime (was: Query HANG - SELECT DISTINCT

[jira] [Assigned] (DRILL-4678) Query HANG - SELECT DISTINCT over date data

2017-03-14 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4678?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk reassigned DRILL-4678: Assignee: Serhii Harnyk > Query HANG - SELECT DISTINCT over date data >

[jira] [Updated] (DRILL-5263) Prevent left NLJoin with non scalar subqueries

2017-02-21 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5263?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-5263: - Labels: (was: ready-to-commit) > Prevent left NLJoin with non scalar subqueries >

[jira] [Updated] (DRILL-4842) SELECT * on JSON data results in NumberFormatException

2017-02-20 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4842?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-4842: - Labels: (was: ready-to-commit) > SELECT * on JSON data results in NumberFormatException >

[jira] [Updated] (DRILL-5263) Prevent left NLJoin with non scalar subqueries

2017-02-17 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5263?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-5263: - Labels: ready-to-commit (was: ) > Prevent left NLJoin with non scalar subqueries >

[jira] [Commented] (DRILL-4939) to_date function returns incorrect result

2017-02-16 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4939?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15869573#comment-15869573 ] Serhii Harnyk commented on DRILL-4939: -- [~khfaraaz] This function returns correct result, and it's

[jira] [Updated] (DRILL-5263) Prevent left NLJoin with non scalar subqueries

2017-02-15 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5263?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-5263: - Summary: Prevent left NLJoin with non scalar subqueries (was: Prevent left nested loop join) >

[jira] [Updated] (DRILL-5263) Prevent left NLJoin with non scalar subqueries

2017-02-15 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5263?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-5263: - Description: Nested loop join operator in Drill supports only inner join and returns incorrect

[jira] [Commented] (DRILL-5263) Prevent left nested loop join

2017-02-15 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5263?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15868199#comment-15868199 ] Serhii Harnyk commented on DRILL-5263: -- Before this changes allowed only left and inner NLJoins. >

[jira] [Updated] (DRILL-5263) Prevent left nested loop join

2017-02-15 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5263?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-5263: - Description: Nested loop join operator in Drill supports only inner join and returns incorrect

[jira] [Updated] (DRILL-5263) Prevent left nested loop join

2017-02-15 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5263?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-5263: - Summary: Prevent left nested loop join (was: Prevent left NLJoin with non scalar subqueries) >

[jira] [Updated] (DRILL-5263) Prevent left NLJoin with non scalar subqueries

2017-02-14 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5263?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-5263: - Attachment: tmp.tar.gz > Prevent left NLJoin with non scalar subqueries >

[jira] [Created] (DRILL-5263) Prevent left NLJoin with non scalar subqueries

2017-02-14 Thread Serhii Harnyk (JIRA)
Serhii Harnyk created DRILL-5263: Summary: Prevent left NLJoin with non scalar subqueries Key: DRILL-5263 URL: https://issues.apache.org/jira/browse/DRILL-5263 Project: Apache Drill Issue

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

2017-02-13 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4864?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15863355#comment-15863355 ] Serhii Harnyk commented on DRILL-4864: -- Fixed in

[jira] [Commented] (DRILL-4939) to_date function returns incorrect result

2017-02-13 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4939?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15863390#comment-15863390 ] Serhii Harnyk commented on DRILL-4939: -- to_date function requires date-time pattern in JodaTime

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

2017-02-13 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-4864: - Labels: doc-impacting (was: doc-impacting ready-to-commit) > Add ANSI format for date/time

[jira] [Updated] (DRILL-4842) SELECT * on JSON data results in NumberFormatException

2017-02-07 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4842?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-4842: - Labels: (was: ready-to-commit) > SELECT * on JSON data results in NumberFormatException >

[jira] [Updated] (DRILL-4842) SELECT * on JSON data results in NumberFormatException

2017-02-07 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4842?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-4842: - Labels: ready-to-commit (was: ) > SELECT * on JSON data results in NumberFormatException >

[jira] [Commented] (DRILL-5237) FlattenRecordBatch loses nested fields from the schema when returns empty batches for the first time

2017-02-06 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5237?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15853676#comment-15853676 ] Serhii Harnyk commented on DRILL-5237: -- Fixed in

[jira] [Updated] (DRILL-5237) FlattenRecordBatch loses nested fields from the schema when returns empty batches for the first time

2017-02-01 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5237?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-5237: - Summary: FlattenRecordBatch loses nested fields from the schema when returns empty batches for

[jira] [Comment Edited] (DRILL-5237) FlattenRecordBatch loses nested fields from the schema when returns empty batches for the first time

2017-02-01 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5237?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15848337#comment-15848337 ] Serhii Harnyk edited comment on DRILL-5237 at 2/1/17 12:56 PM: --- This bug

[jira] [Commented] (DRILL-5237) FlattenRecordBatch loses nested fields from the schema when returns empty batches at first time

2017-02-01 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5237?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15848337#comment-15848337 ] Serhii Harnyk commented on DRILL-5237: -- This bug caused that FlattenRecordBatch loses nested fields

[jira] [Updated] (DRILL-5237) FlattenRecordBatch loses nested fields from the schema when returns empty batches at first time

2017-02-01 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5237?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-5237: - Summary: FlattenRecordBatch loses nested fields from the schema when returns empty batches at

[jira] [Updated] (DRILL-5237) Same query produces different/wrong results

2017-02-01 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5237?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-5237: - Attachment: test_data.tar.gz Files for reproducing this issue > Same query produces

[jira] [Created] (DRILL-5237) Same query produces different/wrong results

2017-02-01 Thread Serhii Harnyk (JIRA)
Serhii Harnyk created DRILL-5237: Summary: Same query produces different/wrong results Key: DRILL-5237 URL: https://issues.apache.org/jira/browse/DRILL-5237 Project: Apache Drill Issue Type:

[jira] (DRILL-4578) "children" missing from results of full scan over JSON data

2017-01-31 Thread Serhii Harnyk (JIRA)
Title: Message Title Serhii Harnyk resolved as Fixed

[jira] (DRILL-3562) Query fails when using flatten on JSON data where some documents have an empty array

2017-01-31 Thread Serhii Harnyk (JIRA)
Title: Message Title Serhii Harnyk updated an issue

[jira] (DRILL-4764) Parquet file with INT_16, etc. logical types not supported by simple SELECT

2017-01-31 Thread Serhii Harnyk (JIRA)
Title: Message Title Serhii Harnyk updated an issue

[jira] (DRILL-4217) Query parquet file treat INT_16 & INT_8 as INT32

2017-01-31 Thread Serhii Harnyk (JIRA)
Title: Message Title Serhii Harnyk resolved as Fixed

[jira] [Updated] (DRILL-4824) JSON with complex nested data produces incorrect output with missing fields

2017-01-27 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4824?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-4824: - Reviewer: Paul Rogers (was: Dechang Gu) > JSON with complex nested data produces incorrect

[jira] [Commented] (DRILL-4824) JSON with complex nested data produces incorrect output with missing fields

2017-01-25 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4824?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15838034#comment-15838034 ] Serhii Harnyk commented on DRILL-4824: -- Map field in json is a part of the schema, and it is clear

[jira] [Updated] (DRILL-4824) JSON with complex nested data produces incorrect output with missing fields

2017-01-25 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4824?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-4824: - Fix Version/s: (was: 1.9.0) > JSON with complex nested data produces incorrect output with

[jira] [Assigned] (DRILL-4824) JSON with complex nested data produces incorrect output with missing fields

2017-01-25 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4824?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk reassigned DRILL-4824: Assignee: Serhii Harnyk (was: Roman) > JSON with complex nested data produces incorrect

[jira] [Updated] (DRILL-3562) Query fails when using flatten on JSON data where some documents have an empty array

2017-01-24 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-3562: - Labels: ready-to-commit (was: ) > Query fails when using flatten on JSON data where some

[jira] [Commented] (DRILL-5197) CASE statement fails due to error: Unable to get value vector class for minor type [NULL] and mode [OPTIONAL]

2017-01-17 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15825724#comment-15825724 ] Serhii Harnyk commented on DRILL-5197: -- [~mgelbana], No, Drill has such behavior according to ANSI

[jira] [Commented] (DRILL-5197) CASE statement fails due to error: Unable to get value vector class for minor type [NULL] and mode [OPTIONAL]

2017-01-16 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15824162#comment-15824162 ] Serhii Harnyk commented on DRILL-5197: -- Replacing {noformat} THEN `tname`.`full_name` {noformat}

[jira] [Commented] (DRILL-5197) CASE statement fails due to error: Unable to get value vector class for minor type [NULL] and mode [OPTIONAL]

2017-01-16 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5197?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15823932#comment-15823932 ] Serhii Harnyk commented on DRILL-5197: -- [~khfaraaz], It is a duplicate of DRILL-4936. As mentioned

[jira] [Commented] (DRILL-3562) Query fails when using flatten on JSON data where some documents have an empty array

2017-01-11 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3562?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15818118#comment-15818118 ] Serhii Harnyk commented on DRILL-3562: -- Besides the initialization of empty arrays we have the

[jira] [Assigned] (DRILL-4578) "children" missing from results of full scan over JSON data

2017-01-11 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4578?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk reassigned DRILL-4578: Assignee: Serhii Harnyk > "children" missing from results of full scan over JSON data >

[jira] [Updated] (DRILL-3562) Query fails when using flatten on JSON data where some documents have an empty array

2017-01-10 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3562?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-3562: - Labels: (was: ready-to-commit) > Query fails when using flatten on JSON data where some

[jira] [Assigned] (DRILL-5164) equi-join query results in CompileException

2016-12-26 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5164?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk reassigned DRILL-5164: Assignee: Serhii Harnyk > equi-join query results in CompileException >

[jira] [Commented] (DRILL-3562) Query fails when using flatten on JSON data where some documents have an empty array

2016-12-20 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3562?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15763911#comment-15763911 ] Serhii Harnyk commented on DRILL-3562: -- This issue is still reproducing on the Json file: {noformat}

[jira] [Updated] (DRILL-5032) Drill query on hive parquet table failed with OutOfMemoryError: Java heap space

2016-12-20 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5032?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-5032: - Labels: (was: ready-to-commit) > Drill query on hive parquet table failed with

[jira] [Resolved] (DRILL-1808) Large compilation unit tests fails due to high memory allocation

2016-12-20 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1808?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk resolved DRILL-1808. -- Resolution: Duplicate Fix Version/s: (was: Future) 1.10.0 Fixed

[jira] [Commented] (DRILL-5117) Compile error when query a json file with 1000+columns

2016-12-20 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5117?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15763699#comment-15763699 ] Serhii Harnyk commented on DRILL-5117: -- Fixed in

[jira] [Updated] (DRILL-5117) Compile error when query a json file with 1000+columns

2016-12-20 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5117?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-5117: - Labels: (was: ready-to-commit) > Compile error when query a json file with 1000+columns >

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

2016-12-16 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-4864: - Description: The TO_DATE() is exposing the Joda string formatting conventions into the SQL

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

2016-12-16 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-4864: - Description: The TO_DATE() is exposing the Joda string formatting conventions into the SQL

[jira] [Updated] (DRILL-5048) Fix type mismatch error in case statement with null timestamp

2016-12-13 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5048?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-5048: - Summary: Fix type mismatch error in case statement with null timestamp (was: AssertionError when

[jira] [Updated] (DRILL-4938) Report UserException when constant expression reduction fails

2016-12-13 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4938?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-4938: - Summary: Report UserException when constant expression reduction fails (was: need better error

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

2016-12-13 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4938?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-4938: - Labels: (was: ready-to-commit) > need better error message > - > >

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

2016-12-13 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5048?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-5048: - Labels: (was: ready-to-commit) > AssertionError when case statement is used with timestamp and

[jira] [Created] (DRILL-5117) Compile error when query a json file with 1000+columns

2016-12-09 Thread Serhii Harnyk (JIRA)
Serhii Harnyk created DRILL-5117: Summary: Compile error when query a json file with 1000+columns Key: DRILL-5117 URL: https://issues.apache.org/jira/browse/DRILL-5117 Project: Apache Drill

[jira] [Closed] (DRILL-4941) UnsupportedOperationException : CASE WHEN true or null then 1 else 0 end

2016-12-09 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4941?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk closed DRILL-4941. Resolution: Won't Fix > UnsupportedOperationException : CASE WHEN true or null then 1 else 0 end >

[jira] [Updated] (DRILL-4941) UnsupportedOperationException : CASE WHEN true or null then 1 else 0 end

2016-12-07 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4941?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-4941: - Fix Version/s: (was: 1.9.0) > UnsupportedOperationException : CASE WHEN true or null then 1

[jira] [Commented] (DRILL-4941) UnsupportedOperationException : CASE WHEN true or null then 1 else 0 end

2016-12-07 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4941?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15728785#comment-15728785 ] Serhii Harnyk commented on DRILL-4941: -- So all this queries should fail. To execute all this queries

[jira] [Commented] (DRILL-4941) UnsupportedOperationException : CASE WHEN true or null then 1 else 0 end

2016-12-07 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4941?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15728760#comment-15728760 ] Serhii Harnyk commented on DRILL-4941: -- Julian Hyde mentioned: The SQL standard allows NULL values if

[jira] [Assigned] (DRILL-4941) UnsupportedOperationException : CASE WHEN true or null then 1 else 0 end

2016-12-06 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4941?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk reassigned DRILL-4941: Assignee: Serhii Harnyk > UnsupportedOperationException : CASE WHEN true or null then 1

[jira] [Commented] (DRILL-4942) incorrect result - case when (not null is null) then true else false end

2016-12-01 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4942?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15712377#comment-15712377 ] Serhii Harnyk commented on DRILL-4942: -- The problem is in Calcite - CALCITE-1095. It was fixed in

[jira] [Assigned] (DRILL-4942) incorrect result - case when (not null is null) then true else false end

2016-12-01 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4942?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk reassigned DRILL-4942: Assignee: Serhii Harnyk > incorrect result - case when (not null is null) then true else

[jira] [Comment Edited] (DRILL-5032) Drill query on hive parquet table failed with OutOfMemoryError: Java heap space

2016-11-23 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15690731#comment-15690731 ] Serhii Harnyk edited comment on DRILL-5032 at 11/23/16 5:24 PM: [~cshi]

[jira] [Updated] (DRILL-5032) Drill query on hive parquet table failed with OutOfMemoryError: Java heap space

2016-11-23 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5032?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-5032: - Labels: К (was: ) > Drill query on hive parquet table failed with OutOfMemoryError: Java heap >

[jira] [Commented] (DRILL-5032) Drill query on hive parquet table failed with OutOfMemoryError: Java heap space

2016-11-23 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15690731#comment-15690731 ] Serhii Harnyk commented on DRILL-5032: -- [~cshi] plz, can you add "+1" in commit in PR? > Drill query

[jira] [Commented] (DRILL-4764) Parquet file with INT_16, etc. logical types not supported by simple SELECT

2016-11-23 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4764?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15690349#comment-15690349 ] Serhii Harnyk commented on DRILL-4764: -- [~paul-rogers], could you tell me how did you generate this

[jira] [Assigned] (DRILL-4764) Parquet file with INT_16, etc. logical types not supported by simple SELECT

2016-11-23 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4764?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk reassigned DRILL-4764: Assignee: Serhii Harnyk > Parquet file with INT_16, etc. logical types not supported by

[jira] [Assigned] (DRILL-4217) Query parquet file treat INT_16 & INT_8 as INT32

2016-11-23 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4217?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk reassigned DRILL-4217: Assignee: Serhii Harnyk > Query parquet file treat INT_16 & INT_8 as INT32 >

[jira] [Commented] (DRILL-4923) Use of CASE WHEN inside a sub-query results in AssertionError

2016-11-23 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4923?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15690303#comment-15690303 ] Serhii Harnyk commented on DRILL-4923: -- The problem is in Calcite - CALCITE-1502. It will be fixed in

[jira] [Updated] (DRILL-5032) Drill query on hive parquet table failed with OutOfMemoryError: Java heap space

2016-11-22 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5032?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk updated DRILL-5032: - Attachment: plan with fix plan Physical plan before and after fix > Drill query

[jira] [Commented] (DRILL-4842) SELECT * on JSON data results in NumberFormatException

2016-11-21 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4842?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15684086#comment-15684086 ] Serhii Harnyk commented on DRILL-4842: -- [~cshi] there is no bug for 1000 nulls. Our fix is aimed for

[jira] [Commented] (DRILL-4936) case expression when true then null, fails

2016-11-21 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4936?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15683630#comment-15683630 ] Serhii Harnyk commented on DRILL-4936: -- [~khfaraaz] There is a comment in Calcite code: //

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

2016-11-18 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15677020#comment-15677020 ] Serhii Harnyk commented on DRILL-4938: -- [~khfaraaz] DrillRuntimeException throws in

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

2016-11-18 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4938?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk reassigned DRILL-4938: Assignee: Serhii Harnyk > need better error message > - > >

[jira] [Assigned] (DRILL-4936) case expression when true then null, fails

2016-11-18 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4936?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Serhii Harnyk reassigned DRILL-4936: Assignee: Serhii Harnyk > case expression when true then null, fails >

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

2016-11-17 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5048?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15673472#comment-15673472 ] Serhii Harnyk commented on DRILL-5048: -- Originally found by [~khfaraaz] in DRILL-4923 >

[jira] [Commented] (DRILL-4923) Use of CASE WHEN inside a sub-query results in AssertionError

2016-11-17 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4923?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15673457#comment-15673457 ] Serhii Harnyk commented on DRILL-4923: -- [~khfaraaz] The problem with case statement when using

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

2016-11-17 Thread Serhii Harnyk (JIRA)
Serhii Harnyk created DRILL-5048: Summary: AssertionError when case statement is used with timestamp and null Key: DRILL-5048 URL: https://issues.apache.org/jira/browse/DRILL-5048 Project: Apache

[jira] [Commented] (DRILL-5032) Drill query on hive parquet table failed with OutOfMemoryError: Java heap space

2016-11-17 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15673402#comment-15673402 ] Serhii Harnyk commented on DRILL-5032: -- List of columns in every hive partition increases size of

[jira] [Commented] (DRILL-5032) Drill query on hive parquet table failed with OutOfMemoryError: Java heap space

2016-11-10 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5032?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15654543#comment-15654543 ] Serhii Harnyk commented on DRILL-5032: -- As [~jni] mentioned Today, the physical plan looks like:

[jira] [Created] (DRILL-5032) Drill query on hive parquet table failed with OutOfMemoryError: Java heap space

2016-11-10 Thread Serhii Harnyk (JIRA)
Serhii Harnyk created DRILL-5032: Summary: Drill query on hive parquet table failed with OutOfMemoryError: Java heap space Key: DRILL-5032 URL: https://issues.apache.org/jira/browse/DRILL-5032

[jira] [Commented] (DRILL-4944) incorrect results - case expression

2016-10-31 Thread Serhii Harnyk (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15622344#comment-15622344 ] Serhii Harnyk commented on DRILL-4944: -- Result of SELECT 0.1 FROM (values(1)) where 1=1 1 row(s):

[jira] [Created] (DRILL-4906) CASE Expression with constant generates class exception

2016-09-27 Thread Serhii Harnyk (JIRA)
Serhii Harnyk created DRILL-4906: Summary: CASE Expression with constant generates class exception Key: DRILL-4906 URL: https://issues.apache.org/jira/browse/DRILL-4906 Project: Apache Drill