[jira] [Created] (DRILL-2492) JDBC : There seems to be no way to execute a CTAS statement with JDBC successfully

2015-03-17 Thread Rahul Challapalli (JIRA)
Rahul Challapalli created DRILL-2492: Summary: JDBC : There seems to be no way to execute a CTAS statement with JDBC successfully Key: DRILL-2492 URL: https://issues.apache.org/jira/browse/DRILL-2492

[jira] [Updated] (DRILL-2470) Implement SMALLINT [umbrella/tracking bug]

2015-03-17 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2470?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-2470: -- Summary: Implement SMALLINT [umbrella/tracking bug] (was: Implement SMALLINT

[jira] [Updated] (DRILL-2465) Fix multiple DatabaseMetaData.getColumns() bugs (some)

2015-03-17 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-2465: -- Description: Fixed most {{getColumn()}} bugs reported in DRILL-2420: - Added

[jira] [Updated] (DRILL-2463) Implement JDBC mapping of SQL NULL for ResultSet.getXxx() methods

2015-03-17 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-2463: -- Attachment: (was: DRILL-2463.2.patch.txt) Implement JDBC mapping of SQL

[jira] [Updated] (DRILL-2463) Implement JDBC mapping of SQL NULL for ResultSet.getXxx() methods

2015-03-17 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2463?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-2463: -- Attachment: (was: DRILL-2463.1.patch.txt) Implement JDBC mapping of SQL

[jira] [Closed] (DRILL-2158) Failure while attempting to start Drillbit in embedded mode.

2015-03-17 Thread kun22kun (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2158?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] kun22kun closed DRILL-2158. --- Resolution: Fixed It's because of the openJDK. There should be JDK of oracle. Failure while attempting to

[jira] [Created] (DRILL-2480) Identify, fix INFORMATION_SCHEMA and JDBC metadata bugs [umbrella/tracking bug]

2015-03-17 Thread Daniel Barclay (Drill) (JIRA)
Daniel Barclay (Drill) created DRILL-2480: - Summary: Identify, fix INFORMATION_SCHEMA and JDBC metadata bugs [umbrella/tracking bug] Key: DRILL-2480 URL: https://issues.apache.org/jira/browse/DRILL-2480

[jira] [Updated] (DRILL-2420) Identify, fix DatabaseMetaData.getColumns() bugs [umbrella/tracking bug]

2015-03-17 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2420?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-2420: -- Summary: Identify, fix DatabaseMetaData.getColumns() bugs [umbrella/tracking

[jira] [Updated] (DRILL-2459) INFO._SCHEMA's CHARACTER_MAXIMUM_LENGTH is -1 for type CHAR

2015-03-17 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2459?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-2459: -- Description: INFORMATION_SCHEMA.COLUMNS.CHARACTER_MAXIMUM_LENGTH does not

[jira] [Updated] (DRILL-2180) Star is not expanded when being used with flatten

2015-03-17 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2180?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu updated DRILL-2180: - Attachment: DRILL-2180.1.patch Patch Available Star is not expanded when being used

[jira] [Commented] (DRILL-1911) Querying same field multiple times with different case would hit memory leak and return incorrect result.

2015-03-17 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1911?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14365986#comment-14365986 ] Sean Hsuan-Yi Chu commented on DRILL-1911: -- Resolved in Commit#:

[jira] [Updated] (DRILL-1842) SELECT COUNT DISTINCT with HAVING fails to plan the query

2015-03-17 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1842?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu updated DRILL-1842: - Assignee: Aman Sinha (was: Sean Hsuan-Yi Chu) SELECT COUNT DISTINCT with HAVING fails

[jira] [Commented] (DRILL-1842) SELECT COUNT DISTINCT with HAVING fails to plan the query

2015-03-17 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1842?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14366155#comment-14366155 ] Sean Hsuan-Yi Chu commented on DRILL-1842: -- [~amansinha100], it might be related

[jira] [Resolved] (DRILL-2414) Union-All on SELECT * FROM schema-less data source will throw exception

2015-03-17 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2414?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-2414. -- Resolution: Fixed Union-All on SELECT * FROM schema-less data source will throw

[jira] [Commented] (DRILL-2311) Create table with same columns of different case results in a java.lang.IllegalStateException

2015-03-17 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2311?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14365788#comment-14365788 ] Aman Sinha commented on DRILL-2311: --- +1 on the patch. Committed to master branch:

[jira] [Created] (DRILL-2486) Return format differences between drill odbc from interval date queries

2015-03-17 Thread Krystal (JIRA)
Krystal created DRILL-2486: -- Summary: Return format differences between drill odbc from interval date queries Key: DRILL-2486 URL: https://issues.apache.org/jira/browse/DRILL-2486 Project: Apache Drill

[jira] [Commented] (DRILL-2478) Validating values assigned to SYSTEM/SESSION configuration parameters

2015-03-17 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2478?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14366065#comment-14366065 ] Khurram Faraaz commented on DRILL-2478: --- system config option

[jira] [Commented] (DRILL-2180) Star is not expanded when being used with flatten

2015-03-17 Thread Mehant Baid (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14366089#comment-14366089 ] Mehant Baid commented on DRILL-2180: +1 Star is not expanded when being used with

[jira] [Updated] (DRILL-2481) Querying individual column from view results in AssertionError

2015-03-17 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2481?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-2481: -- Description: Querying an individual column from a view results in an AssertionError Data used

[jira] [Resolved] (DRILL-2311) Create table with same columns of different case results in a java.lang.IllegalStateException

2015-03-17 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2311?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-2311. -- Resolution: Fixed Create table with same columns of different case results in a

[jira] [Commented] (DRILL-2414) Union-All on SELECT * FROM schema-less data source will throw exception

2015-03-17 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2414?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14365778#comment-14365778 ] Aman Sinha commented on DRILL-2414: --- +1. Committed to master branch, commit #:

[jira] [Commented] (DRILL-2311) Create table with same columns of different case results in a java.lang.IllegalStateException

2015-03-17 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2311?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14365816#comment-14365816 ] Sean Hsuan-Yi Chu commented on DRILL-2311: -- Review Board:

[jira] [Commented] (DRILL-2380) TPC-DS Query 33 and simplified variants return wrong results

2015-03-17 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2380?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14365761#comment-14365761 ] Sean Hsuan-Yi Chu commented on DRILL-2380: -- The failure was due to Union-All.

[jira] [Updated] (DRILL-2311) Create table with same columns of different case results in a java.lang.IllegalStateException

2015-03-17 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2311?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu updated DRILL-2311: - Attachment: DRILL-2311.1.patch Create table with same columns of different case results

[jira] [Commented] (DRILL-2441) Throw unsupported error message in case of inequality join

2015-03-17 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2441?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14365784#comment-14365784 ] Aman Sinha commented on DRILL-2441: --- +1. Committed to master branch commit #: ae2053d2a

[jira] [Commented] (DRILL-2176) IndexOutOfBoundsException for count(*) on a subquery which does order-by

2015-03-17 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2176?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14365783#comment-14365783 ] Sean Hsuan-Yi Chu commented on DRILL-2176: -- I cannot reproduce this bug. Was it

[jira] [Updated] (DRILL-2342) Nullability property of the view created from parquet file is not correct

2015-03-17 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2342?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2342: Attachment: t1.parquet Table 't1' parquet file that was used in the query Nullability

[jira] [Commented] (DRILL-1833) Views cannot be registered into the INFROMATION_SCHEMA.`TABLES` after wiping out ZooKeeper data

2015-03-17 Thread Venki Korukanti (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1833?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14365644#comment-14365644 ] Venki Korukanti commented on DRILL-1833: We currently store MapViewName,

[jira] [Updated] (DRILL-2414) Union-All on SELECT * FROM schema-less data source will throw exception

2015-03-17 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2414?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu updated DRILL-2414: - Fix Version/s: (was: 0.9.0) 0.8.0 Union-All on SELECT * FROM

[jira] [Updated] (DRILL-2311) Create table with same columns of different case results in a java.lang.IllegalStateException

2015-03-17 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2311?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu updated DRILL-2311: - Fix Version/s: (was: 0.9.0) 0.8.0 Create table with same columns

[jira] [Resolved] (DRILL-2441) Throw unsupported error message in case of inequality join

2015-03-17 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2441?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-2441. -- Resolution: Fixed Fix Version/s: (was: 0.9.0) 0.8.0

[jira] [Updated] (DRILL-2002) Confusing star behavior in UNION ALL operator

2015-03-17 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2002?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu updated DRILL-2002: - Fix Version/s: (was: 0.9.0) 0.8.0 Confusing star behavior in

[jira] [Updated] (DRILL-1833) Views cannot be registered into the INFROMATION_SCHEMA.`TABLES` after wiping out ZooKeeper data

2015-03-17 Thread Venki Korukanti (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1833?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Venki Korukanti updated DRILL-1833: --- Attachment: DRILL-1833-1.patch Views cannot be registered into the

[jira] [Updated] (DRILL-2275) need implementations of sys tables for drill memory and threads profiles

2015-03-17 Thread Sudheesh Katkam (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2275?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sudheesh Katkam updated DRILL-2275: --- Assignee: Jacques Nadeau (was: Sudheesh Katkam) need implementations of sys tables for

[jira] [Updated] (DRILL-2413) FileSystemPlugin refactoring: avoid sharing DrillFileSystem across schemas

2015-03-17 Thread Venki Korukanti (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2413?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Venki Korukanti updated DRILL-2413: --- Attachment: DRILL-2413-1.patch FileSystemPlugin refactoring: avoid sharing DrillFileSystem

[jira] [Commented] (DRILL-2380) TPC-DS Query 33 and simplified variants return wrong results

2015-03-17 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2380?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14365707#comment-14365707 ] Sean Hsuan-Yi Chu commented on DRILL-2380: -- Drill gave the same result as

[jira] [Updated] (DRILL-2309) 'null' is counted with subquery

2015-03-17 Thread Mehant Baid (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mehant Baid updated DRILL-2309: --- Attachment: DRILL-2309.patch [~amansinha100] can you please review. 'null' is counted with subquery

[jira] [Updated] (DRILL-2309) 'null' is counted with subquery

2015-03-17 Thread Mehant Baid (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mehant Baid updated DRILL-2309: --- Attachment: (was: DRILL-2309.patch) 'null' is counted with subquery

[jira] [Updated] (DRILL-2491) Fix use of injectable QueryDateTimeInfo in localtimestamp()

2015-03-17 Thread Mehant Baid (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2491?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mehant Baid updated DRILL-2491: --- Attachment: DRILL-2491.patch Fix use of injectable QueryDateTimeInfo in localtimestamp()

[jira] [Updated] (DRILL-2488) Wrong result on join between two subqueries with aggregation

2015-03-17 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2488?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-2488: -- Attachment: 0001-DRILL-2488-Return-DEFAULT-as-supported-encoding-for-.patch It turns out to be an issue

[jira] [Commented] (DRILL-2491) Fix use of injectable QueryDateTimeInfo in localtimestamp()

2015-03-17 Thread Jason Altekruse (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2491?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14366432#comment-14366432 ] Jason Altekruse commented on DRILL-2491: +1 Fix use of injectable

[jira] [Commented] (DRILL-2488) Wrong result on join between two subqueries with aggregation

2015-03-17 Thread Venki Korukanti (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14366531#comment-14366531 ] Venki Korukanti commented on DRILL-2488: Looks good, +1. Wrong result on join

[jira] [Updated] (DRILL-2309) Selecting count(), avg() of nullable columns causes wrong results

2015-03-17 Thread Mehant Baid (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mehant Baid updated DRILL-2309: --- Summary: Selecting count(), avg() of nullable columns causes wrong results (was: 'null' is counted

[jira] [Updated] (DRILL-2309) 'null' is counted with subquery

2015-03-17 Thread Mehant Baid (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2309?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mehant Baid updated DRILL-2309: --- Attachment: DRILL-2309.patch Minor update to the patch. 'null' is counted with subquery

[jira] [Commented] (DRILL-2483) Make buffer that rows are read into during execution configurable for testing purposes

2015-03-17 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14366224#comment-14366224 ] Victoria Markman commented on DRILL-2483: - Hakim (thank you) pointed me to a

[jira] [Updated] (DRILL-2488) Wrong result on join between two subqueries with aggregation

2015-03-17 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2488?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2488: Attachment: t1.parquet Wrong result on join between two subqueries with aggregation

[jira] [Updated] (DRILL-2438) Query on views with Avg on integer column returns wrong result

2015-03-17 Thread Venki Korukanti (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2438?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Venki Korukanti updated DRILL-2438: --- Assignee: Mehant Baid (was: Venki Korukanti) Query on views with Avg on integer column

[jira] [Commented] (DRILL-2488) Wrong result on join between two subqueries with aggregation

2015-03-17 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14366331#comment-14366331 ] Victoria Markman commented on DRILL-2488: - {code} #Fri Mar 13 17:54:51 EDT 2015

[jira] [Created] (DRILL-2491) Fix use of injectable QueryDateTimeInfo in localtimestamp()

2015-03-17 Thread Mehant Baid (JIRA)
Mehant Baid created DRILL-2491: -- Summary: Fix use of injectable QueryDateTimeInfo in localtimestamp() Key: DRILL-2491 URL: https://issues.apache.org/jira/browse/DRILL-2491 Project: Apache Drill

[jira] [Resolved] (DRILL-2143) Remove RecordBatch from setup method of DrillFunc interface

2015-03-17 Thread Jason Altekruse (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jason Altekruse resolved DRILL-2143. Resolution: Fixed Resolved in bff7b9ef5a9f345908aca160a97b98f6ab187708 and

[jira] [Commented] (DRILL-2486) Return format differences between drill odbc from interval date queries

2015-03-17 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2486?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14366197#comment-14366197 ] Daniel Barclay (Drill) commented on DRILL-2486: --- The result from ODBC seems

[jira] [Created] (DRILL-2487) Schema is ignored when using : between schema and zk on sqlline connection string

2015-03-17 Thread Krystal (JIRA)
Krystal created DRILL-2487: -- Summary: Schema is ignored when using : between schema and zk on sqlline connection string Key: DRILL-2487 URL: https://issues.apache.org/jira/browse/DRILL-2487 Project: Apache

[jira] [Updated] (DRILL-2488) Wrong result on join between two subqueries with aggregation

2015-03-17 Thread Chris Westin (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2488?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chris Westin updated DRILL-2488: Fix Version/s: 0.9.0 Wrong result on join between two subqueries with aggregation

[jira] [Commented] (DRILL-2416) Zookeeper in sqlline connection string does not override the entry from drill-override.conf

2015-03-17 Thread Krystal (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2416?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14366283#comment-14366283 ] Krystal commented on DRILL-2416: The zk= scenario does default to the connection from

[jira] [Created] (DRILL-2489) Accessing Connection, Statement, PreparedStatement after they are closed should throw a SQLException

2015-03-17 Thread Rahul Challapalli (JIRA)
Rahul Challapalli created DRILL-2489: Summary: Accessing Connection, Statement, PreparedStatement after they are closed should throw a SQLException Key: DRILL-2489 URL:

[jira] [Created] (DRILL-2490) convert confluence sql commands pages

2015-03-17 Thread Kristine Hahn (JIRA)
Kristine Hahn created DRILL-2490: Summary: convert confluence sql commands pages Key: DRILL-2490 URL: https://issues.apache.org/jira/browse/DRILL-2490 Project: Apache Drill Issue Type: Task

[jira] [Assigned] (DRILL-2488) Wrong result on join between two subqueries with aggregation

2015-03-17 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2488?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha reassigned DRILL-2488: - Assignee: Aman Sinha (was: Chris Westin) Wrong result on join between two subqueries with

[jira] [Resolved] (DRILL-2406) Fix expression interpreter to allow executing expressions at planning time

2015-03-17 Thread Jason Altekruse (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2406?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jason Altekruse resolved DRILL-2406. Resolution: Fixed Resolve din 0aa8b19d624d173da51de36aa164f3435d3366a4 and

[jira] [Comment Edited] (DRILL-2463) Implement JDBC mapping of SQL NULL for ResultSet.getXxx() methods

2015-03-17 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14365904#comment-14365904 ] Daniel Barclay (Drill) edited comment on DRILL-2463 at 3/17/15 10:33 PM:

[jira] [Created] (DRILL-2488) Wrong result on join between two subqueries with aggregation

2015-03-17 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2488: --- Summary: Wrong result on join between two subqueries with aggregation Key: DRILL-2488 URL: https://issues.apache.org/jira/browse/DRILL-2488 Project: Apache

[jira] [Commented] (DRILL-2416) Zookeeper in sqlline connection string does not override the entry from drill-override.conf

2015-03-17 Thread Krystal (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2416?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14366279#comment-14366279 ] Krystal commented on DRILL-2416: I opened drill-2487 for the : vs ; issue. For this

[jira] [Updated] (DRILL-2488) Wrong result on join between two subqueries with aggregation

2015-03-17 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2488?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2488: Description: {code} 0: jdbc:drill:schema=dfs select * from t1;

[jira] [Commented] (DRILL-2438) Query on views with Avg on integer column returns wrong result

2015-03-17 Thread Venki Korukanti (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2438?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14366315#comment-14366315 ] Venki Korukanti commented on DRILL-2438: This doesn't look related to views not

[jira] [Commented] (DRILL-2488) Wrong result on join between two subqueries with aggregation

2015-03-17 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14366370#comment-14366370 ] Aman Sinha commented on DRILL-2488: --- Adding a simplified query that does not do

[jira] [Comment Edited] (DRILL-1833) Views cannot be registered into the INFROMATION_SCHEMA.`TABLES` after wiping out ZooKeeper data

2015-03-17 Thread Venki Korukanti (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1833?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14365644#comment-14365644 ] Venki Korukanti edited comment on DRILL-1833 at 3/17/15 5:50 PM:

[jira] [Commented] (DRILL-1833) Views cannot be registered into the INFROMATION_SCHEMA.`TABLES` after wiping out ZooKeeper data

2015-03-17 Thread Venki Korukanti (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1833?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14365665#comment-14365665 ] Venki Korukanti commented on DRILL-1833: RB Link:

[jira] [Resolved] (DRILL-2380) TPC-DS Query 33 and simplified variants return wrong results

2015-03-17 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2380?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-2380. -- Resolution: Fixed Fix Version/s: (was: 0.9.0) 0.8.0

[jira] [Created] (DRILL-2483) Make buffer that rows are read into during execution configurable for testing purposes

2015-03-17 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2483: --- Summary: Make buffer that rows are read into during execution configurable for testing purposes Key: DRILL-2483 URL: https://issues.apache.org/jira/browse/DRILL-2483

[jira] [Comment Edited] (DRILL-2482) JDBC : calling getObject when the actual column type is 'NVARCHAR' results in NoClassDefFoundError

2015-03-17 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14365965#comment-14365965 ] Rahul Challapalli edited comment on DRILL-2482 at 3/17/15 8:14 PM:

[jira] [Created] (DRILL-2484) Document CASE expression

2015-03-17 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2484: --- Summary: Document CASE expression Key: DRILL-2484 URL: https://issues.apache.org/jira/browse/DRILL-2484 Project: Apache Drill Issue Type: Bug

[jira] [Commented] (DRILL-2180) Star is not expanded when being used with flatten

2015-03-17 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14365974#comment-14365974 ] Sean Hsuan-Yi Chu commented on DRILL-2180: -- [~mehant], can you review it? Star

[jira] [Created] (DRILL-2485) Configuration parameters need to be named consistently

2015-03-17 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-2485: - Summary: Configuration parameters need to be named consistently Key: DRILL-2485 URL: https://issues.apache.org/jira/browse/DRILL-2485 Project: Apache Drill

[jira] [Resolved] (DRILL-1943) Handle aliases and column names that differ in case only

2015-03-17 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1943?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-1943. -- Resolution: Fixed Resolved in Commit#: ae2053d2a078a40033a140f2dfaeef802a5e8254

[jira] [Commented] (DRILL-2482) JDBC : calling getObject when the actual column type is 'NVARCHAR' results in NoClassDefFoundError

2015-03-17 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14365965#comment-14365965 ] Rahul Challapalli commented on DRILL-2482: -- It is of type NVARCHAR. I did not

[jira] [Commented] (DRILL-2482) JDBC : calling getObject when the actual column type is 'NVARCHAR' results in NoClassDefFoundError

2015-03-17 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2482?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14365919#comment-14365919 ] Daniel Barclay (Drill) commented on DRILL-2482: --- That's weird--I've seen

[jira] [Resolved] (DRILL-1911) Querying same field multiple times with different case would hit memory leak and return incorrect result.

2015-03-17 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1911?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-1911. -- Resolution: Fixed Querying same field multiple times with different case would hit

[jira] [Updated] (DRILL-1943) Handle aliases and column names that differ in case only

2015-03-17 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1943?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu updated DRILL-1943: - Fix Version/s: (was: 0.9.0) 0.8.0 Handle aliases and column names

[jira] [Commented] (DRILL-2473) Set query timezone at session level

2015-03-17 Thread Andries Engelbrecht (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2473?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14365261#comment-14365261 ] Andries Engelbrecht commented on DRILL-2473: Need to think if we want

[jira] [Resolved] (DRILL-2429) Update Supported Date/Time Data Type Formats doc

2015-03-17 Thread Kristine Hahn (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2429?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kristine Hahn resolved DRILL-2429. -- Resolution: Fixed committed https://reviews.apache.org/r/32138/ Update Supported Date/Time

[jira] [Updated] (DRILL-2275) need implementations of sys tables for drill memory and threads profiles

2015-03-17 Thread Sudheesh Katkam (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2275?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sudheesh Katkam updated DRILL-2275: --- Attachment: DRILL-2275.4.patch.txt need implementations of sys tables for drill memory and

[jira] [Resolved] (DRILL-2397) Enhance SQL Ref Data Types docs

2015-03-17 Thread Kristine Hahn (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2397?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kristine Hahn resolved DRILL-2397. -- Resolution: Fixed committed: df1b7e5a9397b02a880230e6dc51a07f2b1ff997 Enhance SQL Ref Data

[jira] [Created] (DRILL-2481) Querying individual column from view results in AssertionError

2015-03-17 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-2481: - Summary: Querying individual column from view results in AssertionError Key: DRILL-2481 URL: https://issues.apache.org/jira/browse/DRILL-2481 Project: Apache Drill

[jira] [Updated] (DRILL-2358) Ensure DrillScanRel differentiates skip-all, scan-all scan-some in a backward compatible fashion

2015-03-17 Thread Hanifi Gunes (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2358?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hanifi Gunes updated DRILL-2358: Assignee: Aman Sinha (was: Rahul Challapalli) Ensure DrillScanRel differentiates skip-all,