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

[ https://issues.apache.org/jira/browse/DRILL-4906?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kunal Khatua updated DRILL-4906: Reviewer: Khurram Faraaz (was: Krystal) > CASE Expression with constant generates class exception >

[jira] [Commented] (DRILL-4924) Can not use case expression within an IN predicate.

[ https://issues.apache.org/jira/browse/DRILL-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15544262#comment-15544262 ] Khurram Faraaz commented on DRILL-4924: --- Should we reopen this JIRA ?, now that we k

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

[ https://issues.apache.org/jira/browse/DRILL-4771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kunal Khatua updated DRILL-4771: Reviewer: Khurram Faraaz > Drill should avoid doing the same join twice if count(distinct) exists >

[jira] [Updated] (DRILL-3898) No space error during external sort does not cancel the query

[ https://issues.apache.org/jira/browse/DRILL-3898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kunal Khatua updated DRILL-3898: Reviewer: Khurram Faraaz > No space error during external sort does not cancel the query > -

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

[ https://issues.apache.org/jira/browse/DRILL-4906?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kunal Khatua updated DRILL-4906: Reviewer: Krystal > CASE Expression with constant generates class exception > --

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

[ https://issues.apache.org/jira/browse/DRILL-4792?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kunal Khatua updated DRILL-4792: Reviewer: Krystal > Include session options used for a query as part of the profile > --

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

[ https://issues.apache.org/jira/browse/DRILL-4824?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kunal Khatua updated DRILL-4824: Reviewer: Dechang Gu > JSON with complex nested data produces incorrect output with missing fields >

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

[ https://issues.apache.org/jira/browse/DRILL-4864?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kunal Khatua updated DRILL-4864: Reviewer: Dechang Gu > Add ANSI format for date/time functions > ---

[jira] [Updated] (DRILL-4874) "No UserGroupInformation while generating ORC splits" - hive known issue in 1.2.0-mapr-1607 release.

[ https://issues.apache.org/jira/browse/DRILL-4874?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kunal Khatua updated DRILL-4874: Reviewer: Rahul Challapalli > "No UserGroupInformation while generating ORC splits" - hive known iss

[jira] [Updated] (DRILL-4823) Fix OOM while trying to prune partitions with reasonable data size

[ https://issues.apache.org/jira/browse/DRILL-4823?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kunal Khatua updated DRILL-4823: Reviewer: Rahul Challapalli > Fix OOM while trying to prune partitions with reasonable data size > -

[jira] [Created] (DRILL-4925) Add types filter to getTables metadata API

Laurent Goujon created DRILL-4925: - Summary: Add types filter to getTables metadata API Key: DRILL-4925 URL: https://issues.apache.org/jira/browse/DRILL-4925 Project: Apache Drill Issue Type:

[jira] [Closed] (DRILL-4886) Merge maprdb format plugin source code

[ https://issues.apache.org/jira/browse/DRILL-4886?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish closed DRILL-4886. -- > Merge maprdb format plugin source code > -- > >

[jira] [Commented] (DRILL-4592) Explain plan statement should show plan in WebUi

[ https://issues.apache.org/jira/browse/DRILL-4592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15543571#comment-15543571 ] ASF GitHub Bot commented on DRILL-4592: --- Github user jinfengni closed the pull reque

[jira] [Commented] (DRILL-4279) Improve performance for skipAll query against Text/JSON/Parquet table

[ https://issues.apache.org/jira/browse/DRILL-4279?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15543567#comment-15543567 ] ASF GitHub Bot commented on DRILL-4279: --- Github user jinfengni closed the pull reque

[jira] [Commented] (DRILL-4279) Improve performance for skipAll query against Text/JSON/Parquet table

[ https://issues.apache.org/jira/browse/DRILL-4279?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15543568#comment-15543568 ] ASF GitHub Bot commented on DRILL-4279: --- Github user jinfengni commented on the issu

[jira] [Commented] (DRILL-4592) Explain plan statement should show plan in WebUi

[ https://issues.apache.org/jira/browse/DRILL-4592?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15543572#comment-15543572 ] ASF GitHub Bot commented on DRILL-4592: --- Github user jinfengni commented on the issu

[jira] [Commented] (DRILL-4279) Improve performance for skipAll query against Text/JSON/Parquet table

[ https://issues.apache.org/jira/browse/DRILL-4279?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15543562#comment-15543562 ] ASF GitHub Bot commented on DRILL-4279: --- Github user jinfengni closed the pull reque

[jira] [Assigned] (DRILL-4730) Update JDBC DatabaseMetaData implementation to use new Metadata APIs

[ https://issues.apache.org/jira/browse/DRILL-4730?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Laurent Goujon reassigned DRILL-4730: - Assignee: Laurent Goujon (was: Venki Korukanti) > Update JDBC DatabaseMetaData implement

[jira] [Commented] (DRILL-4203) Parquet File : Date is stored wrongly

[ https://issues.apache.org/jira/browse/DRILL-4203?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15543392#comment-15543392 ] ASF GitHub Bot commented on DRILL-4203: --- Github user vdiravka commented on a diff in

[jira] [Commented] (DRILL-4924) Can not use case expression within an IN predicate.

[ https://issues.apache.org/jira/browse/DRILL-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15543337#comment-15543337 ] Jinfeng Ni commented on DRILL-4924: --- [~julianhyde], thanks for pointing to CALCITE-1120.

[jira] [Comment Edited] (DRILL-4924) Can not use case expression within an IN predicate.

[ https://issues.apache.org/jira/browse/DRILL-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15543278#comment-15543278 ] Julian Hyde edited comment on DRILL-4924 at 10/3/16 8:09 PM: -

[jira] [Commented] (DRILL-4924) Can not use case expression within an IN predicate.

[ https://issues.apache.org/jira/browse/DRILL-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15543278#comment-15543278 ] Julian Hyde commented on DRILL-4924: Actually, Calcite does now support "SELECT withou

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

[ https://issues.apache.org/jira/browse/DRILL-4842?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15543272#comment-15543272 ] ASF GitHub Bot commented on DRILL-4842: --- Github user chunhui-shi commented on a diff

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

[ https://issues.apache.org/jira/browse/DRILL-4842?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15543271#comment-15543271 ] ASF GitHub Bot commented on DRILL-4842: --- Github user chunhui-shi commented on a diff

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

[ https://issues.apache.org/jira/browse/DRILL-4842?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15543269#comment-15543269 ] ASF GitHub Bot commented on DRILL-4842: --- Github user chunhui-shi commented on a diff

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

[ https://issues.apache.org/jira/browse/DRILL-4842?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15543270#comment-15543270 ] ASF GitHub Bot commented on DRILL-4842: --- Github user chunhui-shi commented on a diff

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

[ https://issues.apache.org/jira/browse/DRILL-4842?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15543268#comment-15543268 ] ASF GitHub Bot commented on DRILL-4842: --- Github user chunhui-shi commented on a diff

[jira] [Commented] (DRILL-4203) Parquet File : Date is stored wrongly

[ https://issues.apache.org/jira/browse/DRILL-4203?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15543232#comment-15543232 ] ASF GitHub Bot commented on DRILL-4203: --- Github user vdiravka commented on a diff in

[jira] [Commented] (DRILL-4203) Parquet File : Date is stored wrongly

[ https://issues.apache.org/jira/browse/DRILL-4203?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15543230#comment-15543230 ] ASF GitHub Bot commented on DRILL-4203: --- Github user vdiravka commented on a diff in

[jira] [Commented] (DRILL-4924) Can not use case expression within an IN predicate.

[ https://issues.apache.org/jira/browse/DRILL-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15543101#comment-15543101 ] Jinfeng Ni commented on DRILL-4924: --- For your first query, you need put an alias for tab

[jira] [Commented] (DRILL-4924) Can not use case expression within an IN predicate.

[ https://issues.apache.org/jira/browse/DRILL-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15542907#comment-15542907 ] Khurram Faraaz commented on DRILL-4924: --- Another observation, when we do a select *

[jira] [Commented] (DRILL-4924) Can not use case expression within an IN predicate.

[ https://issues.apache.org/jira/browse/DRILL-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15542707#comment-15542707 ] Khurram Faraaz commented on DRILL-4924: --- Added a FROM clause inside the IN clause an

[jira] [Commented] (DRILL-4924) Can not use case expression within an IN predicate.

[ https://issues.apache.org/jira/browse/DRILL-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15542685#comment-15542685 ] Khurram Faraaz commented on DRILL-4924: --- Ok we definitely need a better error messag

[jira] [Commented] (DRILL-4924) Can not use case expression within an IN predicate.

[ https://issues.apache.org/jira/browse/DRILL-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15542662#comment-15542662 ] Jinfeng Ni commented on DRILL-4924: --- I think this has nothing to do with IN list or case

[jira] [Resolved] (DRILL-4924) Can not use case expression within an IN predicate.

[ https://issues.apache.org/jira/browse/DRILL-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni resolved DRILL-4924. --- Resolution: Won't Fix > Can not use case expression within an IN predicate. >

[jira] [Created] (DRILL-4924) Can not use case expression within an IN predicate.

Khurram Faraaz created DRILL-4924: - Summary: Can not use case expression within an IN predicate. Key: DRILL-4924 URL: https://issues.apache.org/jira/browse/DRILL-4924 Project: Apache Drill Is

[jira] [Commented] (DRILL-1937) Throw exception and give error message when Non-scalar sub-query used in an expression

[ https://issues.apache.org/jira/browse/DRILL-1937?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15542088#comment-15542088 ] Khurram Faraaz commented on DRILL-1937: --- Verified on Drill 1.9.0 ( do we need the re

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

[ https://issues.apache.org/jira/browse/DRILL-4923?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15542044#comment-15542044 ] Khurram Faraaz edited comment on DRILL-4923 at 10/3/16 10:19 AM: ---

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

[ https://issues.apache.org/jira/browse/DRILL-4923?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15542044#comment-15542044 ] Khurram Faraaz edited comment on DRILL-4923 at 10/3/16 10:18 AM: ---

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

[ https://issues.apache.org/jira/browse/DRILL-4923?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-4923: -- Attachment: 0_0_0.parquet data file attached. > Use of CASE WHEN inside a sub-query results in

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

Khurram Faraaz created DRILL-4923: - Summary: Use of CASE WHEN inside a sub-query results in AssertionError Key: DRILL-4923 URL: https://issues.apache.org/jira/browse/DRILL-4923 Project: Apache Drill

[jira] [Comment Edited] (DRILL-4918) Adding 2 dates results in AssertionError: Multiple functions with best cost found

[ https://issues.apache.org/jira/browse/DRILL-4918?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15541977#comment-15541977 ] Khurram Faraaz edited comment on DRILL-4918 at 10/3/16 9:30 AM:

[jira] [Commented] (DRILL-4918) Adding 2 dates results in AssertionError: Multiple functions with best cost found

[ https://issues.apache.org/jira/browse/DRILL-4918?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15541977#comment-15541977 ] Khurram Faraaz commented on DRILL-4918: --- Postgres returns an error {nodormat} postg

[jira] [Created] (DRILL-4922) Difference in results returned by AGE function

Khurram Faraaz created DRILL-4922: - Summary: Difference in results returned by AGE function Key: DRILL-4922 URL: https://issues.apache.org/jira/browse/DRILL-4922 Project: Apache Drill Issue T