[jira] [Updated] (DRILL-2094) Drill has problems with reading json fields when used in a subquery

2015-04-28 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu updated DRILL-2094: - Attachment: (was: DRILL-2094.1.patch) > Drill has problems with reading json fields wh

[jira] [Updated] (DRILL-2094) Drill has problems with reading json fields when used in a subquery

2015-04-28 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu updated DRILL-2094: - Attachment: DRILL-2094.1.patch > Drill has problems with reading json fields when used in

[jira] [Updated] (DRILL-2094) Drill has problems with reading json fields when used in a subquery

2015-04-28 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu updated DRILL-2094: - Assignee: Aman Sinha (was: Sean Hsuan-Yi Chu) > Drill has problems with reading json fiel

[jira] [Commented] (DRILL-2094) Drill has problems with reading json fields when used in a subquery

2015-04-28 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2094?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14517188#comment-14517188 ] Sean Hsuan-Yi Chu commented on DRILL-2094: -- Just verify that this issue was resol

[jira] [Updated] (DRILL-2879) Drill extended json's support $oid

2015-04-28 Thread Bhallamudi Venkata Siva Kamesh (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2879?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Bhallamudi Venkata Siva Kamesh updated DRILL-2879: -- Attachment: extended.json Exported MongoDB data into a file and

[jira] [Commented] (DRILL-2840) Duplicate HashAgg operator seen in physical plan for aggregate & grouping query

2015-04-28 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2840?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14517201#comment-14517201 ] Sean Hsuan-Yi Chu commented on DRILL-2840: -- [~khfaraaz] any new finding on this o

[jira] [Commented] (DRILL-2840) Duplicate HashAgg operator seen in physical plan for aggregate & grouping query

2015-04-28 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2840?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14517261#comment-14517261 ] Khurram Faraaz commented on DRILL-2840: --- I will re-run that test mentioned in Case2

[jira] [Updated] (DRILL-2872) Result from json file returns data from map type fields as "null"

2015-04-28 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2872?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2872: - Attachment: DRILL-2872.patch.diff > Result from json file returns data from map type fields as "nu

[jira] [Commented] (DRILL-2874) Concat operator is not supported with complex types, we should throw an error early

2015-04-28 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2874?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14517421#comment-14517421 ] Sean Hsuan-Yi Chu commented on DRILL-2874: -- Downgrade to minor because it is abou

[jira] [Updated] (DRILL-2874) Concat operator is not supported with complex types, we should throw an error early

2015-04-28 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2874?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu updated DRILL-2874: - Priority: Minor (was: Major) > Concat operator is not supported with complex types, we sh

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

2015-04-28 Thread Krystal (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2465?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krystal closed DRILL-2465. -- Confirmed with Daniel that this is covered by his unit tests and can be closed. > Fix multiple DatabaseMetaData.get

[jira] [Closed] (DRILL-2083) order by on large dataset returns wrong results

2015-04-28 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2083?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-2083. - Assignee: Chun Chang (was: Steven Phillips) verified fix {code} 0: jdbc:drill:schema=dfs.drillTestDirAdv

[jira] [Updated] (DRILL-2349) null comparison behavior difference between drill and postgres

2015-04-28 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2349?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2349: - Fix Version/s: (was: 1.0.0) Future > null comparison behavior difference be

[jira] [Updated] (DRILL-2479) Correlated EXISTS containing an IN subquery fails to plan

2015-04-28 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2479?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-2479: -- Attachment: 0001-DRILL-2479-Added-test-case-for-correlated-EXISTS-wit.patch Added unit test case (fix is

[jira] [Resolved] (DRILL-2479) Correlated EXISTS containing an IN subquery fails to plan

2015-04-28 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2479?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha resolved DRILL-2479. --- Resolution: Fixed Committed in : 927d1998f > Correlated EXISTS containing an IN subquery fails to pla

[jira] [Resolved] (DRILL-2801) ORDER BY produces extra records

2015-04-28 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2801?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Phillips resolved DRILL-2801. Resolution: Duplicate > ORDER BY produces extra records > --- >

[jira] [Updated] (DRILL-2849) Difference in query results over CSV file created by CTAS, compared to results over original CSV file

2015-04-28 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2849?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Phillips updated DRILL-2849: --- Fix Version/s: 1.0.0 > Difference in query results over CSV file created by CTAS, compared to

[jira] [Commented] (DRILL-2355) TRUNC function returns incorrect result when second parameter is specified

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2355?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14517612#comment-14517612 ] Victoria Markman commented on DRILL-2355: - round has the same behavior: {code} 0

[jira] [Updated] (DRILL-2865) Drillbit runs out of memory on multiple consecutive CTAS

2015-04-28 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2865?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Phillips updated DRILL-2865: --- Fix Version/s: 1.0.0 > Drillbit runs out of memory on multiple consecutive CTAS >

[jira] [Updated] (DRILL-2355) TRUNC function returns incorrect result when second parameter is specified

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2355?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2355: Labels: document_if_not_fixed (was: ) > TRUNC function returns incorrect result when second

[jira] [Closed] (DRILL-2616) strings loaded incorrectly from parquet files

2015-04-28 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2616?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-2616. - Assignee: Chun Chang (was: Jason Altekruse) dup > strings loaded incorrectly from parquet files > --

[jira] [Updated] (DRILL-2873) CTAS reports error when timestamp values in CSV file are quoted

2015-04-28 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2873?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Phillips updated DRILL-2873: --- Fix Version/s: 1.1.0 > CTAS reports error when timestamp values in CSV file are quoted > -

[jira] [Updated] (DRILL-2882) Query with nested flatten function fails with SYSTEM ERROR: initialCapacity

2015-04-28 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Phillips updated DRILL-2882: --- Assignee: Jason Altekruse (was: Steven Phillips) > Query with nested flatten function fails w

[jira] [Updated] (DRILL-2877) "mvn validate" builds .tar file

2015-04-28 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2877?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Phillips updated DRILL-2877: --- Fix Version/s: 1.1.0 > "mvn validate" builds .tar file > --- > >

[jira] [Updated] (DRILL-2882) Query with nested flatten function fails with SYSTEM ERROR: initialCapacity

2015-04-28 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2882?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Phillips updated DRILL-2882: --- Fix Version/s: 1.0.0 > Query with nested flatten function fails with SYSTEM ERROR: initialCapa

[jira] [Updated] (DRILL-2875) IllegalStateException when querying the public yelp json dataset

2015-04-28 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2875?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Phillips updated DRILL-2875: --- Fix Version/s: 1.0.0 > IllegalStateException when querying the public yelp json dataset >

[jira] [Commented] (DRILL-1866) Tests that include limit sporadically fail when run as part of entire test suite on Linux

2015-04-28 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1866?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14517635#comment-14517635 ] Steven Phillips commented on DRILL-1866: Are you still seeing this problem? > Tes

[jira] [Closed] (DRILL-2827) Allow implicit cast from strings to boolean

2015-04-28 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2827?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-2827. - Assignee: Chun Chang (was: Aman Sinha) verified fix. {code} 0: jdbc:drill:schema=dfs.drillTestDirAdvance

[jira] [Updated] (DRILL-2153) flatten function null handling options

2015-04-28 Thread Jason Altekruse (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2153?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jason Altekruse updated DRILL-2153: --- Fix Version/s: (was: 1.0.0) 1.1.0 > flatten function null handling opti

[jira] [Updated] (DRILL-1782) Error in drill-root pom - Typo in excludeSubprojects

2015-04-28 Thread Mehant Baid (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1782?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mehant Baid updated DRILL-1782: --- Fix Version/s: (was: 1.0.0) 1.1.0 > Error in drill-root pom - Typo in excludeSu

[jira] [Updated] (DRILL-2538) Project's setupNewSchema() does not create the correct schema for complex vectors with children

2015-04-28 Thread Mehant Baid (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2538?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mehant Baid updated DRILL-2538: --- Fix Version/s: (was: 1.0.0) 1.1.0 > Project's setupNewSchema() does not create

[jira] [Commented] (DRILL-2301) Query fails when multiple table aliases are provided for CTEs

2015-04-28 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2301?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14517954#comment-14517954 ] Abhishek Girish commented on DRILL-2301: Observed to be duplicate. Closing. > Q

[jira] [Closed] (DRILL-2301) Query fails when multiple table aliases are provided for CTEs

2015-04-28 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2301?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish closed DRILL-2301. -- > Query fails when multiple table aliases are provided for CTEs > --

[jira] [Resolved] (DRILL-2725) Faster work assignment logic

2015-04-28 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2725?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Phillips resolved DRILL-2725. Resolution: Fixed fixed in 5f1d6d7 > Faster work assignment logic > ---

[jira] [Updated] (DRILL-2094) Drill has problems with reading json fields when used in a subquery

2015-04-28 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu updated DRILL-2094: - Attachment: (was: DRILL-2094.1.patch) > Drill has problems with reading json fields wh

[jira] [Updated] (DRILL-2094) Drill has problems with reading json fields when used in a subquery

2015-04-28 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2094?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu updated DRILL-2094: - Attachment: DRILL-2094.1.patch > Drill has problems with reading json fields when used in

[jira] [Updated] (DRILL-2532) Glob not always fired for DFS storage engine

2015-04-28 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2532?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Phillips updated DRILL-2532: --- Fix Version/s: 1.0.0 > Glob not always fired for DFS storage engine >

[jira] [Updated] (DRILL-2028) "mvn clean install test" fails with RAT error; read-me missing instruction?

2015-04-28 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2028?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Phillips updated DRILL-2028: --- Fix Version/s: Future > "mvn clean install test" fails with RAT error; read-me missing instruc

[jira] [Commented] (DRILL-2532) Glob not always fired for DFS storage engine

2015-04-28 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2532?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14517970#comment-14517970 ] Steven Phillips commented on DRILL-2532: +1 > Glob not always fired for DFS stora

[jira] [Updated] (DRILL-2872) Result from json file returns data from map type fields as "null"

2015-04-28 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2872?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2872: - Assignee: Hanifi Gunes (was: Parth Chandra) > Result from json file returns data from map type fi

[jira] [Updated] (DRILL-2872) Result from json file returns data from map type fields as "null"

2015-04-28 Thread Hanifi Gunes (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2872?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hanifi Gunes updated DRILL-2872: Assignee: Parth Chandra (was: Hanifi Gunes) > Result from json file returns data from map type fiel

[jira] [Updated] (DRILL-2867) Session level parameter drill.exec.testing.controls appears to be set even though it was not

2015-04-28 Thread Sudheesh Katkam (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2867?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sudheesh Katkam updated DRILL-2867: --- Fix Version/s: 1.0.0 > Session level parameter drill.exec.testing.controls appears to be set

[jira] [Updated] (DRILL-2757) Verify operators correctly handle low memory conditions and cancellations

2015-04-28 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2757?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-2757: Summary: Verify operators correctly handle low memory conditions and cancellations (was: Ve

[jira] [Closed] (DRILL-2803) Severe skew due to null values in columns even when other columns are non-null

2015-04-28 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2803?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-2803. - Assignee: Chun Chang (was: Jacques Nadeau) verified fix {code} 0: jdbc:drill:schema=dfs.drillTestDirAdva

[jira] [Closed] (DRILL-2668) CAST to FLOAT with numeric literal yields DOUBLE

2015-04-28 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2668?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-2668. - Assignee: Chun Chang (was: Daniel Barclay (Drill)) fix checked in with new unit test covering this. > CA

[jira] [Closed] (DRILL-2372) current_date() should convert input to UTC before storing in vector

2015-04-28 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2372?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-2372. - Assignee: Chun Chang (was: Mehant Baid) I added a set of test cases in this area. > current_date() shoul

[jira] [Updated] (DRILL-2869) Incorrect data when we have fields missing in some of the files - another case

2015-04-28 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2869?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rahul Challapalli updated DRILL-2869: - Labels: erro (was: ) > Incorrect data when we have fields missing in some of the files -

[jira] [Comment Edited] (DRILL-1065) Provide a reset command to reset an option to its default value

2015-04-28 Thread Sudheesh Katkam (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1065?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14077933#comment-14077933 ] Sudheesh Katkam edited comment on DRILL-1065 at 4/28/15 9:54 PM: ---

[jira] [Closed] (DRILL-2339) setting drill.exec.http options fails

2015-04-28 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-2339. - Assignee: Chun Chang (was: Daniel Barclay (Drill)) invalid > setting drill.exec.http options fails > ---

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

2015-04-28 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2143?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-2143. - Assignee: Chun Chang (was: Jason Altekruse) hard to verify > Remove RecordBatch from setup method of Dri

[jira] [Closed] (DRILL-2112) Throw helpful error message with unsupported KVGen functionality

2015-04-28 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2112?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-2112. - Assignee: Chun Chang (was: Mehant Baid) dup > Throw helpful error message with unsupported KVGen functio

[jira] [Updated] (DRILL-1753) Flatten fails on a repeated map, where the maps being flattened contain repeated lists

2015-04-28 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1753?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rahul Challapalli updated DRILL-1753: - Assignee: Rahul Challapalli (was: Jason Altekruse) > Flatten fails on a repeated map, whe

[jira] [Updated] (DRILL-1343) Drill should timeout after short time if a storage plugin is unresponsive.

2015-04-28 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1343?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Phillips updated DRILL-1343: --- Fix Version/s: (was: 0.9.0) 1.0.0 > Drill should timeout after short ti

[jira] [Updated] (DRILL-2819) Complex Data : Accessing an element within a map using array notation should return a more meaningful error message

2015-04-28 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2819?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Phillips updated DRILL-2819: --- Fix Version/s: 1.0.0 > Complex Data : Accessing an element within a map using array notation s

[jira] [Closed] (DRILL-1741) kvgen does not work with nested map/unions

2015-04-28 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1741?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-1741. - Assignee: Chun Chang (was: Mehant Baid) verified fix. {code} 0: jdbc:drill:schema=dfs.drillTestDirAdvanc

[jira] [Updated] (DRILL-2817) Drill should throw a more meaningful error message when we have json records separated by ',' in a file

2015-04-28 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2817?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Phillips updated DRILL-2817: --- Fix Version/s: 1.0.0 > Drill should throw a more meaningful error message when we have json re

[jira] [Closed] (DRILL-1718) FLATTEN query returns "buffer is neither a method, a field, nor a member class..." error

2015-04-28 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1718?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-1718. - Assignee: Chun Chang (was: Steven Phillips) error message. will not add automation > FLATTEN query retur

[jira] [Closed] (DRILL-1693) Could not find any reference for configuring RDBMS (Oracle/DB2) as a data source in any of the product document.

2015-04-28 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1693?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-1693. - Assignee: Chun Chang dup. let's track in the other jira. > Could not find any reference for configuring R

[jira] [Commented] (DRILL-2849) Difference in query results over CSV file created by CTAS, compared to results over original CSV file

2015-04-28 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2849?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14518256#comment-14518256 ] Steven Phillips commented on DRILL-2849: could you please attach the file you used

[jira] [Created] (DRILL-2893) ScanBatch throws a NullPointerException instead of returning OUT_OF_MEMORY

2015-04-28 Thread Deneche A. Hakim (JIRA)
Deneche A. Hakim created DRILL-2893: --- Summary: ScanBatch throws a NullPointerException instead of returning OUT_OF_MEMORY Key: DRILL-2893 URL: https://issues.apache.org/jira/browse/DRILL-2893 Projec

[jira] [Updated] (DRILL-2292) CTAS broken when we have repeated maps

2015-04-28 Thread Hanifi Gunes (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Hanifi Gunes updated DRILL-2292: Assignee: Deneche A. Hakim (was: Hanifi Gunes) > CTAS broken when we have repeated maps > -

[jira] [Commented] (DRILL-2670) querying sys.options table with order by causes exception

2015-04-28 Thread Sudheesh Katkam (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14518272#comment-14518272 ] Sudheesh Katkam commented on DRILL-2670: This bug was fixed as part of DRILL-2714.

[jira] [Commented] (DRILL-2115) Disable function CARDINALITY in grammar

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2115?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14518396#comment-14518396 ] Victoria Markman commented on DRILL-2115: - Verified in 0.9.0 #Mon Apr 27 23:19:19

[jira] [Closed] (DRILL-2115) Disable function CARDINALITY in grammar

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2115?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2115. --- > Disable function CARDINALITY in grammar > --- > >

[jira] [Updated] (DRILL-2115) Disable function CARDINALITY in grammar

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2115?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2115: Labels: error_message_must_fix no_verified_test (was: ) > Disable function CARDINALITY in g

[jira] [Commented] (DRILL-2167) Order by on a repeated index from the output of a flatten on large no of records results in incorrect results

2015-04-28 Thread Sudheesh Katkam (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2167?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14518397#comment-14518397 ] Sudheesh Katkam commented on DRILL-2167: After DRILL-2083 was fixed, the queries m

[jira] [Closed] (DRILL-2214) Aggregate function documentation needs to be corrected

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2214?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2214. --- > Aggregate function documentation needs to be corrected > ---

[jira] [Commented] (DRILL-2214) Aggregate function documentation needs to be corrected

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2214?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14518406#comment-14518406 ] Victoria Markman commented on DRILL-2214: - Verified fixed. Excerpt from docs: MIN

[jira] [Commented] (DRILL-2212) NULLIF function should be documented

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14518408#comment-14518408 ] Victoria Markman commented on DRILL-2212: - Verified fixed. > NULLIF function shou

[jira] [Closed] (DRILL-2212) NULLIF function should be documented

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2212. --- > NULLIF function should be documented > > >

[jira] [Commented] (DRILL-2215) COALESCE function needs to be documented

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2215?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14518410#comment-14518410 ] Victoria Markman commented on DRILL-2215: - Verified fixed. > COALESCE function ne

[jira] [Closed] (DRILL-2215) COALESCE function needs to be documented

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2215?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2215. --- > COALESCE function needs to be documented > > >

[jira] [Reopened] (DRILL-2754) Allocation bug in splitAndTransfer method causing some flatten queries to fail

2015-04-28 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2754?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rahul Challapalli reopened DRILL-2754: -- Though we have a unit test for this, I am getting the below ouput from sqlline. There could

[jira] [Resolved] (DRILL-2806) Querying data from compressed csv file returns nulls and unreadable data

2015-04-28 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2806?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Phillips resolved DRILL-2806. Resolution: Invalid > Querying data from compressed csv file returns nulls and unreadable da

[jira] [Commented] (DRILL-2611) Value vectors report invalid value count

2015-04-28 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2611?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14518416#comment-14518416 ] Rahul Challapalli commented on DRILL-2611: -- [~hgunes] Can you give more informati

[jira] [Commented] (DRILL-2806) Querying data from compressed csv file returns nulls and unreadable data

2015-04-28 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2806?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14518422#comment-14518422 ] Khurram Faraaz commented on DRILL-2806: --- We will need to throw an error with a prope

[jira] [Updated] (DRILL-2196) Assert when . notation is used in union all query

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2196?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2196: Labels: error_message_must_fix no_verified_test (was: ) > Assert when . notation is used in

[jira] [Commented] (DRILL-2196) Assert when . notation is used in union all query

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2196?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14518423#comment-14518423 ] Victoria Markman commented on DRILL-2196: - Verified in 0.9.0 #Mon Apr 27 23:19:19

[jira] [Resolved] (DRILL-2196) Assert when . notation is used in union all query

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2196?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-2196. - Resolution: Fixed > Assert when . notation is used in union all query > --

[jira] [Reopened] (DRILL-2196) Assert when . notation is used in union all query

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2196?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman reopened DRILL-2196: - This is not invalid bug, this was a real problem. > Assert when . notation is used in union a

[jira] [Closed] (DRILL-2196) Assert when . notation is used in union all query

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2196?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2196. --- > Assert when . notation is used in union all query >

[jira] [Commented] (DRILL-2278) Join on a large data set results in an NPE

2015-04-28 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14518429#comment-14518429 ] Steven Phillips commented on DRILL-2278: Could you give the number of nodes in the

[jira] [Closed] (DRILL-2277) COUNT(*) should return 0 instead of an empty result set when there are no records

2015-04-28 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2277?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rahul Challapalli closed DRILL-2277. Verified and added the below testcase Functional/Passing/aggregate/aggregate19.q > COUNT(*) sh

[jira] [Closed] (DRILL-2131) Selecting boolean column through Web UI throws an error

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2131?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2131. --- > Selecting boolean column through Web UI throws an error > --

[jira] [Commented] (DRILL-2131) Selecting boolean column through Web UI throws an error

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2131?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14518446#comment-14518446 ] Victoria Markman commented on DRILL-2131: - Verified fixed in 0.9.0 #Mon Apr 27 23

[jira] [Updated] (DRILL-2016) Remove "multiset" data type from supported grammar

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2016?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2016: Labels: error_message_must_fix (was: ) > Remove "multiset" data type from supported grammar

[jira] [Commented] (DRILL-2016) Remove "multiset" data type from supported grammar

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2016?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14518470#comment-14518470 ] Victoria Markman commented on DRILL-2016: - With drill 0.9.0 (git.commit.id.abbrev

[jira] [Reopened] (DRILL-2016) Remove "multiset" data type from supported grammar

2015-04-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2016?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman reopened DRILL-2016: - > Remove "multiset" data type from supported grammar > ---

[jira] [Closed] (DRILL-1679) regexp_replace can not work well with flatten function

2015-04-28 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1679?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-1679. - Assignee: Chun Chang verified fix. added a new test case: Functional/Passing/flatten_operators/general/jir

[jira] [Closed] (DRILL-2151) VariableLengthVector.copyFromSafe() unnecessary sets the offsetVector

2015-04-28 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2151?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rahul Challapalli closed DRILL-2151. Verified and added the below testcase Functional/Passing/tpch0.01/parquet/4way_lfe_DRILL-2151.e

[jira] [Closed] (DRILL-1472) Function resolution cannot handle repeated list as an input type to a UDF

2015-04-28 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1472?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-1472. - Assignee: Chun Chang won't fix > Function resolution cannot handle repeated list as an input type to a UD

[jira] [Updated] (DRILL-2893) ScanBatch throws a NullPointerException instead of returning OUT_OF_MEMORY

2015-04-28 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2893?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-2893: Description: - set _drill.exec.memory.top.max_ in _drill-override.conf_ to some low value (I

[jira] [Updated] (DRILL-2884) Have cancel() cause "query canceled" rather than just "ResultSet closed"

2015-04-28 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2884?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-2884: -- Attachment: DRILL-2884.2Hygiene.1.patch.txt DRILL-2884.1Core.1.pa

[jira] [Updated] (DRILL-2036) select * query returns wrong result when column name in json file changes case

2015-04-28 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2036?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Phillips updated DRILL-2036: --- Attachment: DRILL-2036.patch > select * query returns wrong result when column name in json fi

[jira] [Commented] (DRILL-2036) select * query returns wrong result when column name in json file changes case

2015-04-28 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2036?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14518499#comment-14518499 ] Steven Phillips commented on DRILL-2036: Created reviewboard https://reviews.apach

[jira] [Commented] (DRILL-2036) select * query returns wrong result when column name in json file changes case

2015-04-28 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2036?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14518502#comment-14518502 ] Steven Phillips commented on DRILL-2036: [~hgunes] please review. > select * quer

[jira] [Updated] (DRILL-2036) select * query returns wrong result when column name in json file changes case

2015-04-28 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2036?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Steven Phillips updated DRILL-2036: --- Assignee: Hanifi Gunes (was: Steven Phillips) > select * query returns wrong result when colu

[jira] [Created] (DRILL-2894) FixedValueVectors shouldn't set it's data buffer to null when it fails to allocate it

2015-04-28 Thread Deneche A. Hakim (JIRA)
Deneche A. Hakim created DRILL-2894: --- Summary: FixedValueVectors shouldn't set it's data buffer to null when it fails to allocate it Key: DRILL-2894 URL: https://issues.apache.org/jira/browse/DRILL-2894

[jira] [Updated] (DRILL-2884) Have cancel() cause "query canceled" rather than just "ResultSet closed"

2015-04-28 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2884?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Daniel Barclay (Drill) updated DRILL-2884: -- Attachment: DRILL-2884.2Hygiene.2.patch.txt > Have cancel() cause "query cancele

[jira] [Closed] (DRILL-1443) order by does not sort when select *

2015-04-28 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1443?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-1443. - Assignee: Chun Chang (was: Jinfeng Ni) verified fix and added a new test case - Functional/Passing/orderb

  1   2   >