[jira] [Created] (DRILL-2599) Wrong results while using stddev with views

2015-03-27 Thread Mehant Baid (JIRA)
Mehant Baid created DRILL-2599: -- Summary: Wrong results while using stddev with views Key: DRILL-2599 URL: https://issues.apache.org/jira/browse/DRILL-2599 Project: Apache Drill Issue Type: Bug

[jira] [Updated] (DRILL-2599) Wrong results while using stddev with views

2015-03-27 Thread Mehant Baid (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mehant Baid updated DRILL-2599: --- Attachment: DRILL-2599.patch [~amansinha100] can you please review. > Wrong results while using stdde

[jira] [Commented] (DRILL-2597) Sqlline fails when script contains comments

2015-03-27 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2597?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14383483#comment-14383483 ] Julian Hyde commented on DRILL-2597: SQL supports both kinds of comments: {code} ::=

[jira] [Commented] (DRILL-2599) Wrong results while using stddev with views

2015-03-27 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14383857#comment-14383857 ] Aman Sinha commented on DRILL-2599: --- +1. I think we should do the same for AVG instead

[jira] [Created] (DRILL-2600) Print list of ALL system settings on each drill restart into drillbit.log

2015-03-27 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2600: --- Summary: Print list of ALL system settings on each drill restart into drillbit.log Key: DRILL-2600 URL: https://issues.apache.org/jira/browse/DRILL-2600 Project

[jira] [Created] (DRILL-2601) Print SQL query text along with query id in drillbit.log

2015-03-27 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2601: --- Summary: Print SQL query text along with query id in drillbit.log Key: DRILL-2601 URL: https://issues.apache.org/jira/browse/DRILL-2601 Project: Apache Drill

[jira] [Updated] (DRILL-2600) Print list of ALL system settings on each drill restart into drillbit.log

2015-03-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2600: Component/s: Storage - Other > Print list of ALL system settings on each drill restart into

[jira] [Created] (DRILL-2602) Throw an error on schema change during streaming aggregation

2015-03-27 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2602: --- Summary: Throw an error on schema change during streaming aggregation Key: DRILL-2602 URL: https://issues.apache.org/jira/browse/DRILL-2602 Project: Apache Dril

[jira] [Created] (DRILL-2603) Review, resolve NULL checks/isNull()/null around vectors, accessors, JDBC SQLAccessor, etc.

2015-03-27 Thread Daniel Barclay (Drill) (JIRA)
Daniel Barclay (Drill) created DRILL-2603: - Summary: Review, resolve NULL checks/isNull()/null around vectors, accessors, JDBC SQLAccessor, etc. Key: DRILL-2603 URL: https://issues.apache.org/jira/browse/D

[jira] [Created] (DRILL-2604) Make sure implicit casting rules are the same across drill

2015-03-27 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2604: --- Summary: Make sure implicit casting rules are the same across drill Key: DRILL-2604 URL: https://issues.apache.org/jira/browse/DRILL-2604 Project: Apache Drill

[jira] [Updated] (DRILL-2603) Review, resolve NULL checks/isNull()/null around vectors, accessors, JDBC SQLAccessor, etc.

2015-03-27 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2603?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-2603: -- Description: Review the checking for SQL NULL and mapping to Java null (for non-

[jira] [Commented] (DRILL-2600) Print list of ALL system settings on each drill restart into drillbit.log

2015-03-27 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2600?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384201#comment-14384201 ] Khurram Faraaz commented on DRILL-2600: --- Yes, we will need commands/statements like,

[jira] [Commented] (DRILL-2604) Make sure implicit casting rules are the same across drill

2015-03-27 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2604?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384205#comment-14384205 ] Daniel Barclay (Drill) commented on DRILL-2604: --- Don't forget to check what

[jira] [Updated] (DRILL-2579) JDBC unit tests will time out after one testcase failed with unexpected results.

2015-03-27 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2579?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-2579: -- Summary: JDBC unit tests will time out after one testcase failed with unexpected

[jira] [Updated] (DRILL-2579) JDBC unit tests will time out after one testcase fails with unexpected results.

2015-03-27 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2579?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-2579: -- Summary: JDBC unit tests will time out after one testcase fails with unexpected

[jira] [Assigned] (DRILL-2591) Aggregate in left input to Union All does not work

2015-03-27 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2591?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu reassigned DRILL-2591: Assignee: Sean Hsuan-Yi Chu (was: Jinfeng Ni) > Aggregate in left input to Union A

[jira] [Commented] (DRILL-2600) Print list of ALL system settings on each drill restart into drillbit.log

2015-03-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2600?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384220#comment-14384220 ] Victoria Markman commented on DRILL-2600: - Khurram, I'm asking to always dump all

[jira] [Created] (DRILL-2605) Projecting a boolean column from a hbase view after a join is causing an ExpressionParsingException

2015-03-27 Thread Rahul Challapalli (JIRA)
Rahul Challapalli created DRILL-2605: Summary: Projecting a boolean column from a hbase view after a join is causing an ExpressionParsingException Key: DRILL-2605 URL: https://issues.apache.org/jira/browse/DRI

[jira] [Updated] (DRILL-2605) Projecting a boolean column from a hbase view after a join is causing an ExpressionParsingException

2015-03-27 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2605?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rahul Challapalli updated DRILL-2605: - Attachment: fewtypes_null.parquet fewtypes_null_hbase.tbl d

[jira] [Updated] (DRILL-2597) Sqlline fails when script contains comments

2015-03-27 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2597?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish updated DRILL-2597: --- Description: Sqlline fails if option -f or - -run= is used, and the DDL file contains a comme

[jira] [Created] (DRILL-2606) Casting a column from hbase to boolean after a join with parquet makes DRILL unresponsive

2015-03-27 Thread Rahul Challapalli (JIRA)
Rahul Challapalli created DRILL-2606: Summary: Casting a column from hbase to boolean after a join with parquet makes DRILL unresponsive Key: DRILL-2606 URL: https://issues.apache.org/jira/browse/DRILL-2606

[jira] [Updated] (DRILL-2606) Casting a column from hbase to boolean after a join with parquet makes DRILL unresponsive

2015-03-27 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2606?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rahul Challapalli updated DRILL-2606: - Attachment: fewtypes_null.parquet fewtypes_null_hbase.tbl d

[jira] [Commented] (DRILL-2244) Implicit cast between decimal data types is not implemented

2015-03-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2244?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384290#comment-14384290 ] Victoria Markman commented on DRILL-2244: - Note for QA: test suite under Functiona

[jira] [Commented] (DRILL-2600) Print list of ALL system settings on each drill restart into drillbit.log

2015-03-27 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2600?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384287#comment-14384287 ] Khurram Faraaz commented on DRILL-2600: --- That is correct. There is this other case t

[jira] [Commented] (DRILL-2606) Casting a column from hbase to boolean after a join with parquet makes DRILL unresponsive

2015-03-27 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2606?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384301#comment-14384301 ] Rahul Challapalli commented on DRILL-2606: -- FYI : I have kill the drillbit manual

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

2015-03-27 Thread Abhishek Girish (JIRA)
Abhishek Girish created DRILL-2607: -- Summary: TPC-DS query 71 and simplified variant on parquet views fails with IOBE Key: DRILL-2607 URL: https://issues.apache.org/jira/browse/DRILL-2607 Project: A

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

2015-03-27 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2607?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish updated DRILL-2607: --- Attachment: query71.sql drillbit.log > TPC-DS query 71 and simplified variant

[jira] [Commented] (DRILL-1944) JsonReader fails to read arrays of size 2000

2015-03-27 Thread Jason Altekruse (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384349#comment-14384349 ] Jason Altekruse commented on DRILL-1944: I'm having trouble re-producing this, I'm

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

2015-03-27 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384351#comment-14384351 ] Abhishek Girish commented on DRILL-2607: Git.Commit.ID: 462e50c (Mar 26 2015) > T

[jira] [Commented] (DRILL-2598) Order by with limit on complex type throw IllegalStateException

2015-03-27 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2598?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384350#comment-14384350 ] Chun Chang commented on DRILL-2598: --- without order by, the query completes fine. {code}

[jira] [Created] (DRILL-2608) Union all query fails when json.all_text_mode=false

2015-03-27 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-2608: - Summary: Union all query fails when json.all_text_mode=false Key: DRILL-2608 URL: https://issues.apache.org/jira/browse/DRILL-2608 Project: Apache Drill Is

[jira] [Commented] (DRILL-2594) Web UI visualized plan may show incorrect plan due to rearranging

2015-03-27 Thread Sudheesh Katkam (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2594?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384374#comment-14384374 ] Sudheesh Katkam commented on DRILL-2594: The visualized plan never showed left and

[jira] [Updated] (DRILL-2594) Web UI visualized plan may show incorrect plan due to rearranging

2015-03-27 Thread Sudheesh Katkam (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2594?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sudheesh Katkam updated DRILL-2594: --- Issue Type: Improvement (was: Bug) > Web UI visualized plan may show incorrect plan due to re

[jira] [Assigned] (DRILL-2590) Union all query returns results and Exception

2015-03-27 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2590?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu reassigned DRILL-2590: Assignee: Sean Hsuan-Yi Chu (was: Jinfeng Ni) > Union all query returns results an

[jira] [Updated] (DRILL-2608) Union all query fails when json.all_text_mode=false

2015-03-27 Thread Jinfeng Ni (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2608?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jinfeng Ni updated DRILL-2608: -- Assignee: Sean Hsuan-Yi Chu (was: Jinfeng Ni) > Union all query fails when json.all_text_mode=false > -

[jira] [Commented] (DRILL-2608) Union all query fails when json.all_text_mode=false

2015-03-27 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384497#comment-14384497 ] Khurram Faraaz commented on DRILL-2608: --- Physical plan for the failing query 00-00

[jira] [Commented] (DRILL-2608) Union all query fails when json.all_text_mode=false

2015-03-27 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384508#comment-14384508 ] Abhishek Girish commented on DRILL-2608: Can you please share a small snippet of t

[jira] [Commented] (DRILL-2608) Union all query fails when json.all_text_mode=false

2015-03-27 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384522#comment-14384522 ] Khurram Faraaz commented on DRILL-2608: --- Here are first five lines from each of the

[jira] [Commented] (DRILL-1499) Different column order could appear in the result set for a schema-less select * query, even there are no changing schemas.

2015-03-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1499?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384534#comment-14384534 ] Victoria Markman commented on DRILL-1499: - I just ran into this again, in complete

[jira] [Commented] (DRILL-2608) Union all query fails when json.all_text_mode=false

2015-03-27 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384553#comment-14384553 ] Abhishek Girish commented on DRILL-2608: This looks to be an invalid use-case. The

[jira] [Created] (DRILL-2609) convert_from should throw an appropriate error when an invalid data type is used as the second argument

2015-03-27 Thread Rahul Challapalli (JIRA)
Rahul Challapalli created DRILL-2609: Summary: convert_from should throw an appropriate error when an invalid data type is used as the second argument Key: DRILL-2609 URL: https://issues.apache.org/jira/browse

[jira] [Commented] (DRILL-1944) JsonReader fails to read arrays of size 2000

2015-03-27 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384568#comment-14384568 ] Abhishek Girish commented on DRILL-1944: Can you try with this: https://github.co

[jira] [Updated] (DRILL-2571) convert_from fails with ' Wrong length 1(1-0) in the buffer '1', expected 4.'

2015-03-27 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2571?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rahul Challapalli updated DRILL-2571: - Priority: Critical (was: Major) I tried loading the data into hbase using hive. Since the

[jira] [Updated] (DRILL-2571) convert_from fails with ' Wrong length 1(1-0) in the buffer '1', expected 4.'

2015-03-27 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2571?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rahul Challapalli updated DRILL-2571: - Attachment: dataload.hql > convert_from fails with ' Wrong length 1(1-0) in the buffer '1'

[jira] [Created] (DRILL-2610) Local File System Storage Plugin

2015-03-27 Thread Sudheesh Katkam (JIRA)
Sudheesh Katkam created DRILL-2610: -- Summary: Local File System Storage Plugin Key: DRILL-2610 URL: https://issues.apache.org/jira/browse/DRILL-2610 Project: Apache Drill Issue Type: New Fea

[jira] [Commented] (DRILL-2608) Union all query fails when json.all_text_mode=false

2015-03-27 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384717#comment-14384717 ] Khurram Faraaz commented on DRILL-2608: --- Abhishek, Union All supports implicit casti

[jira] [Created] (DRILL-2611) Fixed length value vectors report invalid value count

2015-03-27 Thread Hanifi Gunes (JIRA)
Hanifi Gunes created DRILL-2611: --- Summary: Fixed length value vectors report invalid value count Key: DRILL-2611 URL: https://issues.apache.org/jira/browse/DRILL-2611 Project: Apache Drill Issu

[jira] [Commented] (DRILL-1499) Different column order could appear in the result set for a schema-less select * query, even there are no changing schemas.

2015-03-27 Thread Kristine Hahn (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1499?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384748#comment-14384748 ] Kristine Hahn commented on DRILL-1499: -- [~vicky] re: [your comment|https://issues.ap

[jira] [Commented] (DRILL-2412) CTAS has issues when the underlying query casts a column to time datatype

2015-03-27 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2412?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384752#comment-14384752 ] Deneche A. Hakim commented on DRILL-2412: - I tried the queries with the current ma

[jira] [Commented] (DRILL-2412) CTAS has issues when the underlying query casts a column to time datatype

2015-03-27 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2412?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384763#comment-14384763 ] Rahul Challapalli commented on DRILL-2412: -- This is no longer a bug. Looks like i

[jira] [Resolved] (DRILL-2133) getString() for NULL value fails with "AssertionError: Tried to get null value."

2015-03-27 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) resolved DRILL-2133. --- Resolution: Fixed > getString() for NULL value fails with "AssertionError: Tri

[jira] [Created] (DRILL-2612) Union All involving empty JSON file on right input to union all returns zero results

2015-03-27 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-2612: - Summary: Union All involving empty JSON file on right input to union all returns zero results Key: DRILL-2612 URL: https://issues.apache.org/jira/browse/DRILL-2612

[jira] [Commented] (DRILL-2464) JDBC : ResultSet.wasNull always returns false for all datatypes

2015-03-27 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2464?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384768#comment-14384768 ] Daniel Barclay (Drill) commented on DRILL-2464: --- [~rkins] This should be fi

[jira] [Commented] (DRILL-2612) Union All involving empty JSON file on right input to union all returns zero results

2015-03-27 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2612?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384773#comment-14384773 ] Khurram Faraaz commented on DRILL-2612: --- Same result when empty JSON file is input o

[jira] [Resolved] (DRILL-2471) JDBC : ResultSet.getXXX should return 0 when we encounter null for primitives which are numeric

2015-03-27 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2471?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) resolved DRILL-2471. --- Resolution: Fixed > JDBC : ResultSet.getXXX should return 0 when we encounter

[jira] [Assigned] (DRILL-2612) Union All involving empty JSON file on right input to union all returns zero results

2015-03-27 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2612?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu reassigned DRILL-2612: Assignee: Sean Hsuan-Yi Chu (was: Jinfeng Ni) > Union All involving empty JSON fil

[jira] [Updated] (DRILL-2598) Order by with limit on complex type throw IllegalStateException

2015-03-27 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2598?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2598: - Fix Version/s: 0.9.0 > Order by with limit on complex type throw IllegalStateException > -

[jira] [Updated] (DRILL-2573) Update C++ Client to handle separation of QueryR\esult and QueryData

2015-03-27 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2573?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2573: - Fix Version/s: 0.9.0 > Update C++ Client to handle separation of QueryR\esult and QueryData >

[jira] [Resolved] (DRILL-2412) CTAS has issues when the underlying query casts a column to time datatype

2015-03-27 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2412?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim resolved DRILL-2412. - Resolution: Cannot Reproduce This seems to be resolved in current master > CTAS has issue

[jira] [Updated] (DRILL-2581) count(*) on a single wide record file took too long

2015-03-27 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2581?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2581: - Fix Version/s: 0.9.0 > count(*) on a single wide record file took too long > -

[jira] [Updated] (DRILL-2595) Sqlline Usage needs to be corrected

2015-03-27 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2595?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2595: - Fix Version/s: 1.1.0 > Sqlline Usage needs to be corrected > --- >

[jira] [Updated] (DRILL-2597) Sqlline fails when script contains comments

2015-03-27 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2597?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2597: - Fix Version/s: 1.1.0 > Sqlline fails when script contains comments > -

[jira] [Updated] (DRILL-2555) JDBC driver throws RuntimeExceptions rather than SQLExceptions

2015-03-27 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2555?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2555: - Fix Version/s: 1.1.0 > JDBC driver throws RuntimeExceptions rather than SQLExceptions > --

[jira] [Updated] (DRILL-2555) JDBC driver throws RuntimeExceptions rather than SQLExceptions

2015-03-27 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2555?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2555: - Assignee: Daniel Barclay (Drill) > JDBC driver throws RuntimeExceptions rather than SQLExceptions

[jira] [Updated] (DRILL-2592) Jdbc-all driver includes transitive dependencies

2015-03-27 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2592?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2592: - Fix Version/s: 1.0.0 > Jdbc-all driver includes transitive dependencies >

[jira] [Updated] (DRILL-2560) JDBC execute calls return asynchronously for DDLs

2015-03-27 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2560?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2560: - Fix Version/s: 0.9.0 > JDBC execute calls return asynchronously for DDLs > ---

[jira] [Updated] (DRILL-2558) Four different errors are returned when running one COALESCE with multiple arguments of incompatible data types

2015-03-27 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2558?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2558: - Fix Version/s: 1.1.0 > Four different errors are returned when running one COALESCE with multiple

[jira] [Updated] (DRILL-2557) COALESCE function returns ArrayIndexOutOfBoundsException when no arguments are passed in

2015-03-27 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2557?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2557: - Fix Version/s: 0.9.0 > COALESCE function returns ArrayIndexOutOfBoundsException when no arguments

[jira] [Updated] (DRILL-2557) COALESCE function returns ArrayIndexOutOfBoundsException when no arguments are passed in

2015-03-27 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2557?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2557: - Assignee: Mehant Baid (was: Daniel Barclay (Drill)) > COALESCE function returns ArrayIndexOutOfBo

[jira] [Updated] (DRILL-2549) Implicit Cast between integer and varchar columns in a join should work

2015-03-27 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2549?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2549: - Assignee: Chris Westin (was: Daniel Barclay (Drill)) > Implicit Cast between integer and varchar

[jira] [Updated] (DRILL-2549) Implicit Cast between integer and varchar columns in a join should work

2015-03-27 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2549?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2549: - Component/s: (was: Execution - Data Types) > Implicit Cast between integer and varchar columns

[jira] [Updated] (DRILL-2549) Implicit Cast between integer and varchar columns in a join should work

2015-03-27 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2549?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2549: - Assignee: Mehant Baid (was: Chris Westin) > Implicit Cast between integer and varchar columns in

[jira] [Updated] (DRILL-2549) Implicit Cast between integer and varchar columns in a join should work

2015-03-27 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2549?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2549: - Fix Version/s: 1.1.0 > Implicit Cast between integer and varchar columns in a join should work > -

[jira] [Commented] (DRILL-2549) Implicit Cast between integer and varchar columns in a join should work

2015-03-27 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2549?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384820#comment-14384820 ] Parth Chandra commented on DRILL-2549: -- Do we want to support his for 1.0? > Implici

[jira] [Updated] (DRILL-2579) JDBC unit tests will time out after one testcase fails with unexpected results.

2015-03-27 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2579?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-2579: -- Attachment: DRILL-2579-pt2Hygiene.1.patch.txt DRILL-2579-pt1Core.

[jira] [Commented] (DRILL-2608) Union all query fails when json.all_text_mode=false

2015-03-27 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384831#comment-14384831 ] Abhishek Girish commented on DRILL-2608: Drill supports implicit casting between d

[jira] [Updated] (DRILL-2442) C++ Client Support - Add impersonation (and other user properties) support

2015-03-27 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2442?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2442: - Assignee: Parth Chandra (was: Mehant Baid) > C++ Client Support - Add impersonation (and other us

[jira] [Resolved] (DRILL-2442) C++ Client Support - Add impersonation (and other user properties) support

2015-03-27 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2442?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra resolved DRILL-2442. -- Resolution: Fixed Fixed in 2f2338f > C++ Client Support - Add impersonation (and other user pro

[jira] [Resolved] (DRILL-2307) Detect DNS name resolution failure for better error messages in Drill Client

2015-03-27 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2307?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra resolved DRILL-2307. -- Resolution: Fixed Fixed in c7cf883 > Detect DNS name resolution failure for better error messag

[jira] [Commented] (DRILL-1499) Different column order could appear in the result set for a schema-less select * query, even there are no changing schemas.

2015-03-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1499?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384843#comment-14384843 ] Victoria Markman commented on DRILL-1499: - Kristine, thank you, this is exactly wh

[jira] [Updated] (DRILL-1649) JSON : Joining 2 sub-queries (one of them uses flatten) fails with "Hash Join doe not support schema changes"

2015-03-27 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1649?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-1649: - Assignee: Daniel Barclay (Drill) (was: Parth Chandra) > JSON : Joining 2 sub-queries (one of them

[jira] [Updated] (DRILL-1649) JSON : Joining 2 sub-queries (one of them uses flatten) fails with "Hash Join doe not support schema changes"

2015-03-27 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1649?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-1649: - Assignee: Parth Chandra (was: Daniel Barclay (Drill)) > JSON : Joining 2 sub-queries (one of them

[jira] [Updated] (DRILL-1754) Flatten nested within another flatten fails

2015-03-27 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1754?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-1754: - Assignee: Jason Altekruse (was: Parth Chandra) > Flatten nested within another flatten fails > --

[jira] [Updated] (DRILL-1754) Flatten nested within another flatten fails

2015-03-27 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1754?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-1754: - Component/s: (was: Functions - Drill) Execution - Relational Operators > Flat

[jira] [Created] (DRILL-2613) Implement (higher-priority) ResultSet.getXxx(...) data conversions

2015-03-27 Thread Daniel Barclay (Drill) (JIRA)
Daniel Barclay (Drill) created DRILL-2613: - Summary: Implement (higher-priority) ResultSet.getXxx(...) data conversions Key: DRILL-2613 URL: https://issues.apache.org/jira/browse/DRILL-2613 Pr

[jira] [Updated] (DRILL-2608) Union all query fails when json.all_text_mode=false

2015-03-27 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2608?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-2608: -- Priority: Minor (was: Major) > Union all query fails when json.all_text_mode=false > --

[jira] [Commented] (DRILL-2608) Union all query fails when json.all_text_mode=false

2015-03-27 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384881#comment-14384881 ] Khurram Faraaz commented on DRILL-2608: --- Thanks for catching that Abhishek, I need t

[jira] [Commented] (DRILL-2608) Union all query fails when json.all_text_mode=false

2015-03-27 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2608?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384883#comment-14384883 ] Abhishek Girish commented on DRILL-2608: Anytime! Can you please edit the title to

[jira] [Updated] (DRILL-2608) Need a better error message when Union all query fails, json.all_text_mode=false

2015-03-27 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2608?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-2608: -- Summary: Need a better error message when Union all query fails, json.all_text_mode=false (was:

[jira] [Commented] (DRILL-2613) Implement (higher-priority) ResultSet.getXxx(...) data conversions

2015-03-27 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2613?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384892#comment-14384892 ] Daniel Barclay (Drill) commented on DRILL-2613: --- Notes on requirements, poss

[jira] [Comment Edited] (DRILL-2613) Implement (higher-priority) ResultSet.getXxx(...) data conversions

2015-03-27 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2613?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384892#comment-14384892 ] Daniel Barclay (Drill) edited comment on DRILL-2613 at 3/27/15 11:36 PM: ---

[jira] [Comment Edited] (DRILL-2613) Implement (higher-priority) ResultSet.getXxx(...) data conversions

2015-03-27 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2613?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384892#comment-14384892 ] Daniel Barclay (Drill) edited comment on DRILL-2613 at 3/27/15 11:42 PM: ---

[jira] [Commented] (DRILL-1308) CannotPlanException for TPC-DS query 8 due to large IN-list and Intersect operation

2015-03-27 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1308?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384908#comment-14384908 ] Aman Sinha commented on DRILL-1308: --- The large IN list will be addressed through Values

[jira] [Updated] (DRILL-1308) CannotPlanException for TPC-DS query 8 due to large IN-list and Intersect operation

2015-03-27 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1308?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-1308: -- Assignee: Sean Hsuan-Yi Chu (was: Aman Sinha) > CannotPlanException for TPC-DS query 8 due to large IN-

[jira] [Comment Edited] (DRILL-2613) Implement (higher-priority) ResultSet.getXxx(...) data conversions

2015-03-27 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2613?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384892#comment-14384892 ] Daniel Barclay (Drill) edited comment on DRILL-2613 at 3/27/15 11:46 PM: ---

[jira] [Updated] (DRILL-1397) Query with IN clause and correlation fails

2015-03-27 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1397?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-1397: -- Fix Version/s: (was: 0.9.0) 1.0.0 > Query with IN clause and correlation fails >

[jira] [Updated] (DRILL-1438) HBase queries fail with illegal char error

2015-03-27 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1438?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-1438: -- Assignee: Sean Hsuan-Yi Chu (was: Aman Sinha) > HBase queries fail with illegal char error > --

[jira] [Commented] (DRILL-2613) Implement (higher-priority) ResultSet.getXxx(...) data conversions

2015-03-27 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2613?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384911#comment-14384911 ] Daniel Barclay (Drill) commented on DRILL-2613: --- MySQL JDBC notes: - [http:

[jira] [Comment Edited] (DRILL-2613) Implement (higher-priority) ResultSet.getXxx(...) data conversions

2015-03-27 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2613?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14384911#comment-14384911 ] Daniel Barclay (Drill) edited comment on DRILL-2613 at 3/27/15 11:53 PM: ---

[jira] [Updated] (DRILL-1486) Hbase : Using substring together with convert_from fails to execute

2015-03-27 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1486?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-1486: -- Component/s: (was: SQL Parser) Functions - Drill > Hbase : Using substring together

  1   2   >