[jira] [Created] (DRILL-3914) Support geospatial queries

2015-10-08 Thread Karol Potocki (JIRA)
Karol Potocki created DRILL-3914: Summary: Support geospatial queries Key: DRILL-3914 URL: https://issues.apache.org/jira/browse/DRILL-3914 Project: Apache Drill Issue Type: Improvement

[jira] [Updated] (DRILL-3762) NPE : Query nested JSON data

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3762?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3762: -- Fix Version/s: (was: Future) 1.3.0 > NPE : Query nested JSON data >

[jira] [Updated] (DRILL-3908) ResultSetMetadata.getColumnDisplaySize() does not return correct column length value

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3908: -- Assignee: Daniel Barclay (Drill) > ResultSetMetadata.getColumnDisplaySize() does not return

[jira] [Updated] (DRILL-3908) ResultSetMetadata.getColumnDisplaySize() does not return correct column length value

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3908?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3908: -- Fix Version/s: 1.3.0 > ResultSetMetadata.getColumnDisplaySize() does not return correct column

[jira] [Commented] (DRILL-3908) ResultSetMetadata.getColumnDisplaySize() does not return correct column length value

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3908?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14948181#comment-14948181 ] Khurram Faraaz commented on DRILL-3908: --- I tried that test on Drill 1.2 and I can reproduce it on

[jira] [Updated] (DRILL-3762) NPE : Query nested JSON data

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3762?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3762: -- Assignee: Jason Altekruse > NPE : Query nested JSON data > > >

[jira] [Commented] (DRILL-3914) Support geospatial queries

2015-10-08 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3914?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14948411#comment-14948411 ] ASF GitHub Bot commented on DRILL-3914: --- GitHub user k255 opened a pull request:

[jira] [Created] (DRILL-3915) Execute queries with multiple lines

2015-10-08 Thread Philip Deegan (JIRA)
Philip Deegan created DRILL-3915: Summary: Execute queries with multiple lines Key: DRILL-3915 URL: https://issues.apache.org/jira/browse/DRILL-3915 Project: Apache Drill Issue Type: Bug

[jira] [Closed] (DRILL-3915) Execute queries with multiple lines

2015-10-08 Thread Philip Deegan (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Philip Deegan closed DRILL-3915. Resolution: Fixed > Execute queries with multiple lines > --- > >

[jira] [Commented] (DRILL-3915) Execute queries with multiple lines

2015-10-08 Thread Philip Deegan (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3915?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14948536#comment-14948536 ] Philip Deegan commented on DRILL-3915: -- or use the -f flag > Execute queries with multiple lines >

[jira] [Commented] (DRILL-3914) Support geospatial queries

2015-10-08 Thread Jacques Nadeau (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3914?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14948703#comment-14948703 ] Jacques Nadeau commented on DRILL-3914: --- This is super cool! Thanks for contributing this. I'm not a

[jira] [Commented] (DRILL-951) CSV header row should be parsed

2015-10-08 Thread Matt Keranen (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-951?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14948783#comment-14948783 ] Matt Keranen commented on DRILL-951: This is not tagged for a release version, and should be basic

[jira] [Updated] (DRILL-3891) ROW_KEY filter IN(integer values) does not get pushed in to Scan

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3891: -- Fix Version/s: 1.3.0 > ROW_KEY filter IN(integer values) does not get pushed in to Scan >

[jira] [Updated] (DRILL-3873) SchemaChangeException : CONVERT_FROM(...row_key...) IS NOT NULL

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3873?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3873: -- Assignee: Mehant Baid > SchemaChangeException : CONVERT_FROM(...row_key...) IS NOT NULL >

[jira] [Updated] (DRILL-3805) Empty JSON on LHS UNION non empty JSON on RHS must return results

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3805: -- Fix Version/s: (was: Future) 1.3.0 > Empty JSON on LHS UNION non empty

[jira] [Updated] (DRILL-3854) IOB Exception : CONVERT_FROM (sal, int_be)

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3854?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3854: -- Assignee: Mehant Baid > IOB Exception : CONVERT_FROM (sal, int_be) >

[jira] [Updated] (DRILL-3805) Empty JSON on LHS UNION non empty JSON on RHS must return results

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3805: -- Assignee: Sean Hsuan-Yi Chu > Empty JSON on LHS UNION non empty JSON on RHS must return results

[jira] [Updated] (DRILL-3797) Filter not pushed down as part of scan (for JSON data)

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3797: -- Assignee: Sean Hsuan-Yi Chu > Filter not pushed down as part of scan (for JSON data) >

[jira] [Commented] (DRILL-3151) ResultSetMetaData not as specified by JDBC (null/dummy value, not ""/etc.)

2015-10-08 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3151?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949041#comment-14949041 ] Daniel Barclay (Drill) commented on DRILL-3151: --- Resolved except for remainder now reported

[jira] [Updated] (DRILL-3743) query hangs on sqlline once Drillbit on foreman node is killed

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3743?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3743: -- Priority: Critical (was: Major) > query hangs on sqlline once Drillbit on foreman node is

[jira] [Updated] (DRILL-3743) query hangs on sqlline once Drillbit on foreman node is killed

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3743?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3743: -- Assignee: Deneche A. Hakim > query hangs on sqlline once Drillbit on foreman node is killed >

[jira] [Closed] (DRILL-3234) Drill fails to implicit cast hive tinyint and smallint data as int

2015-10-08 Thread Krystal (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3234?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krystal closed DRILL-3234. -- Resolution: Fixed This bug is a duplicate of DRILL-3263 > Drill fails to implicit cast hive tinyint and

[jira] [Updated] (DRILL-3733) erro message fix - NTILE function

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3733?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3733: -- Assignee: Deneche A. Hakim > erro message fix - NTILE function >

[jira] [Updated] (DRILL-3728) millisecond portion of time value missing from query results

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3728: -- Assignee: Mehant Baid > millisecond portion of time value missing from query results >

[jira] [Updated] (DRILL-3664) CAST integer zero , one to boolean false , true

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3664?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3664: -- Assignee: Mehant Baid > CAST integer zero , one to boolean false , true >

[jira] [Updated] (DRILL-3664) CAST integer zero , one to boolean false , true

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3664?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3664: -- Fix Version/s: (was: Future) 1.3.0 > CAST integer zero , one to boolean

[jira] [Updated] (DRILL-3647) Handle null as input to window function NTILE

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3647?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3647: -- Assignee: Deneche A. Hakim > Handle null as input to window function NTILE >

[jira] [Resolved] (DRILL-3600) NPE : Invalid input to LEAD function

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz resolved DRILL-3600. --- Resolution: Fixed > NPE : Invalid input to LEAD function >

[jira] [Updated] (DRILL-3597) Disable RESPECT NULLS, IGNORE NULLS option for LEAD, LAG window functions

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3597?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3597: -- Fix Version/s: (was: Future) 1.3.0 > Disable RESPECT NULLS, IGNORE NULLS

[jira] [Updated] (DRILL-3597) Disable RESPECT NULLS, IGNORE NULLS option for LEAD, LAG window functions

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3597?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3597: -- Assignee: Sean Hsuan-Yi Chu > Disable RESPECT NULLS, IGNORE NULLS option for LEAD, LAG window

[jira] [Updated] (DRILL-3564) Error message fix required

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3564?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3564: -- Assignee: Sean Hsuan-Yi Chu > Error message fix required > -- > >

[jira] [Assigned] (DRILL-3793) Rewrite MergeJoinBatch using record batch iterator.

2015-10-08 Thread amit hadke (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3793?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] amit hadke reassigned DRILL-3793: - Assignee: amit hadke > Rewrite MergeJoinBatch using record batch iterator. >

[jira] [Assigned] (DRILL-3796) Provide an iterator over record batches

2015-10-08 Thread amit hadke (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] amit hadke reassigned DRILL-3796: - Assignee: amit hadke > Provide an iterator over record batches >

[jira] [Updated] (DRILL-3743) query hangs on sqlline once Drillbit on foreman node is killed

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3743?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3743: -- Fix Version/s: (was: Future) 1.3.0 > query hangs on sqlline once

[jira] [Updated] (DRILL-3728) millisecond portion of time value missing from query results

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3728?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3728: -- Fix Version/s: (was: Future) 1.3.0 > millisecond portion of time value

[jira] [Updated] (DRILL-3676) Group by ordinal number of an output column results in parse error

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3676?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3676: -- Assignee: Sean Hsuan-Yi Chu > Group by ordinal number of an output column results in parse

[jira] [Updated] (DRILL-3630) error message needs to be fixed LEAD , LAG window functions

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3630?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3630: -- Assignee: Deneche A. Hakim > error message needs to be fixed LEAD , LAG window functions >

[jira] [Updated] (DRILL-3599) Wrong results returned by LEAD(col-name, -1)

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3599: -- Fix Version/s: (was: Future) 1.2.0 > Wrong results returned by

[jira] [Resolved] (DRILL-3599) Wrong results returned by LEAD(col-name, -1)

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz resolved DRILL-3599. --- Resolution: Fixed > Wrong results returned by LEAD(col-name, -1) >

[jira] [Commented] (DRILL-3599) Wrong results returned by LEAD(col-name, -1)

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3599?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949070#comment-14949070 ] Khurram Faraaz commented on DRILL-3599: --- This is fixed on Drill 1.2 master git.commit.id=eafe0a24,

[jira] [Updated] (DRILL-3564) Error message fix required

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3564?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3564: -- Fix Version/s: (was: Future) 1.3.0 > Error message fix required >

[jira] [Updated] (DRILL-3881) Rowkey filter does not get pushed into Scan

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3881?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3881: -- Priority: Critical (was: Major) > Rowkey filter does not get pushed into Scan >

[jira] [Updated] (DRILL-3751) Query hang when zookeeper is stopped

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3751?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3751: -- Fix Version/s: (was: Future) 1.3.0 > Query hang when zookeeper is

[jira] [Updated] (DRILL-3751) Query hang when zookeeper is stopped

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3751?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3751: -- Assignee: Sudheesh Katkam > Query hang when zookeeper is stopped >

[jira] [Updated] (DRILL-3751) Query hang when zookeeper is stopped

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3751?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3751: -- Priority: Critical (was: Major) > Query hang when zookeeper is stopped >

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

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3681?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3681: -- Assignee: Deneche A. Hakim > need a better error message > --- > >

[jira] [Updated] (DRILL-3600) NPE : Invalid input to LEAD function

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3600?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3600: -- Assignee: Deneche A. Hakim > NPE : Invalid input to LEAD function >

[jira] [Commented] (DRILL-3600) NPE : Invalid input to LEAD function

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3600?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949065#comment-14949065 ] Khurram Faraaz commented on DRILL-3600: --- The NPE is not seen anymore, looks like some other fix has

[jira] [Updated] (DRILL-3599) Wrong results returned by LEAD(col-name, -1)

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3599?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3599: -- Assignee: Deneche A. Hakim > Wrong results returned by LEAD(col-name, -1) >

[jira] [Commented] (DRILL-3805) Empty JSON on LHS UNION non empty JSON on RHS must return results

2015-10-08 Thread Daniel Barclay (Drill) (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3805?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949163#comment-14949163 ] Daniel Barclay (Drill) commented on DRILL-3805: --- Sounds related to DRILL-2288. > Empty JSON

[jira] [Updated] (DRILL-3891) ROW_KEY filter IN(integer values) does not get pushed in to Scan

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3891: -- Fix Version/s: (was: 1.3.0) Future > ROW_KEY filter IN(integer values)

[jira] [Updated] (DRILL-3865) Difference in results - query parquet table vs query HBase table

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3865?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3865: -- Fix Version/s: (was: 1.3.0) Future > Difference in results - query

[jira] [Updated] (DRILL-3870) CONVERT_FROM(..., uint8_be) can not be used in project

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3870: -- Assignee: (was: Aditya Kishore) > CONVERT_FROM(..., uint8_be) can not be used in project >

[jira] [Updated] (DRILL-3854) IOB Exception : CONVERT_FROM (sal, int_be)

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3854?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3854: -- Fix Version/s: (was: 1.3.0) Future > IOB Exception : CONVERT_FROM (sal,

[jira] [Updated] (DRILL-3805) Empty JSON on LHS UNION non empty JSON on RHS must return results

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3805: -- Assignee: (was: Sean Hsuan-Yi Chu) > Empty JSON on LHS UNION non empty JSON on RHS must

[jira] [Updated] (DRILL-3854) IOB Exception : CONVERT_FROM (sal, int_be)

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3854?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3854: -- Assignee: (was: Mehant Baid) > IOB Exception : CONVERT_FROM (sal, int_be) >

[jira] [Updated] (DRILL-3865) Difference in results - query parquet table vs query HBase table

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3865?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3865: -- Assignee: (was: Aditya Kishore) > Difference in results - query parquet table vs query

[jira] [Updated] (DRILL-3797) Filter not pushed down as part of scan (for JSON data)

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3797: -- Assignee: (was: Sean Hsuan-Yi Chu) > Filter not pushed down as part of scan (for JSON data)

[jira] [Updated] (DRILL-3870) CONVERT_FROM(..., uint8_be) can not be used in project

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3870: -- Fix Version/s: (was: 1.3.0) Future > CONVERT_FROM(..., uint8_be) can not

[jira] [Updated] (DRILL-3873) SchemaChangeException : CONVERT_FROM(...row_key...) IS NOT NULL

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3873?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3873: -- Assignee: (was: Mehant Baid) > SchemaChangeException : CONVERT_FROM(...row_key...) IS NOT

[jira] [Created] (DRILL-3916) Assembly for JDBC storage plugin missing

2015-10-08 Thread Andrew (JIRA)
Andrew created DRILL-3916: - Summary: Assembly for JDBC storage plugin missing Key: DRILL-3916 URL: https://issues.apache.org/jira/browse/DRILL-3916 Project: Apache Drill Issue Type: Bug

[jira] [Commented] (DRILL-3916) Assembly for JDBC storage plugin missing

2015-10-08 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3916?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949218#comment-14949218 ] ASF GitHub Bot commented on DRILL-3916: --- GitHub user aleph-zero opened a pull request:

[jira] [Commented] (DRILL-2015) Casting numeric value that does not fit in integer data type produces incorrect result

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949351#comment-14949351 ] Victoria Markman commented on DRILL-2015: - Changed priority to critical, since it is incorrect

[jira] [Updated] (DRILL-2015) Casting numeric value that does not fit in integer data type produces incorrect result

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2015?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2015: Affects Version/s: 1.2.0 > Casting numeric value that does not fit in integer data type

[jira] [Updated] (DRILL-2015) Casting numeric value that does not fit in integer data type produces incorrect result

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2015?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2015: Priority: Critical (was: Major) > Casting numeric value that does not fit in integer data

[jira] [Updated] (DRILL-2101) Decimal literals are treated as double

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2101: Labels: decimal (was: ) > Decimal literals are treated as double >

[jira] [Updated] (DRILL-3751) Query hang when zookeeper is stopped

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3751?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3751: -- Assignee: (was: Sudheesh Katkam) > Query hang when zookeeper is stopped >

[jira] [Comment Edited] (DRILL-2123) Order of columns in the Web UI is wrong when columns are explicitly specified in projection list

2015-10-08 Thread Sudheesh Katkam (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2123?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949437#comment-14949437 ] Sudheesh Katkam edited comment on DRILL-2123 at 10/8/15 9:34 PM: - You just

[jira] [Comment Edited] (DRILL-3712) Drill does not recognize UTF-16-LE encoding

2015-10-08 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949489#comment-14949489 ] Deneche A. Hakim edited comment on DRILL-3712 at 10/8/15 10:13 PM: ---

[jira] [Commented] (DRILL-2543) Correlated subquery where outer table contains NULL values returns seemingly wrong result

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2543?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949526#comment-14949526 ] Victoria Markman commented on DRILL-2543: - [~jni] it does make sense after you spelled it out with

[jira] [Commented] (DRILL-2001) Poor error message when arithmetic expression with MIN/MAX functions on a string type

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2001?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949346#comment-14949346 ] Victoria Markman commented on DRILL-2001: - in 1.2.0 we return a better error, however it should be

[jira] [Commented] (DRILL-3712) Drill does not recognize UTF-16-LE encoding

2015-10-08 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949503#comment-14949503 ] Steven Phillips commented on DRILL-3712: I think one solution would be to write a UDF to convert

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

2015-10-08 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: Priority: Critical (was: Minor) > TRUNC function returns incorrect result when second

[jira] [Resolved] (DRILL-2246) select from sys.options fails in a weird way when slice_target=1

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2246?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-2246. - Resolution: Fixed > select from sys.options fails in a weird way when slice_target=1 >

[jira] [Updated] (DRILL-3762) NPE : Query nested JSON data

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3762?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3762: -- Assignee: (was: Jason Altekruse) > NPE : Query nested JSON data >

[jira] [Updated] (DRILL-2123) Order of columns in the Web UI is wrong when columns are explicitly specified in projection list

2015-10-08 Thread Sudheesh Katkam (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2123?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sudheesh Katkam updated DRILL-2123: --- Priority: Critical (was: Major) > Order of columns in the Web UI is wrong when columns are

[jira] [Commented] (DRILL-2123) Order of columns in the Web UI is wrong when columns are explicitly specified in projection list

2015-10-08 Thread Sudheesh Katkam (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2123?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949437#comment-14949437 ] Sudheesh Katkam commented on DRILL-2123: This still happens. > Order of columns in the Web UI is

[jira] [Updated] (DRILL-3384) CTAS Partitioning by a non-existing column results in NPE.

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3384?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3384: -- Assignee: (was: Sean Hsuan-Yi Chu) > CTAS Partitioning by a non-existing column results in

[jira] [Updated] (DRILL-3384) CTAS Partitioning by a non-existing column results in NPE.

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3384?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3384: -- Fix Version/s: (was: 1.3.0) Future > CTAS Partitioning by a non-existing

[jira] [Commented] (DRILL-3712) Drill does not recognize UTF-16-LE encoding

2015-10-08 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949489#comment-14949489 ] Deneche A. Hakim commented on DRILL-3712: - [~ebegoli] I did the following using the latest master:

[jira] [Updated] (DRILL-2860) Unable to cast integer column from parquet file to interval day

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2860?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2860: Labels: interval (was: ) > Unable to cast integer column from parquet file to interval day

[jira] [Commented] (DRILL-1895) Improve message where implicit cast fails (e.g. with IN clause)

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1895?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949304#comment-14949304 ] Victoria Markman commented on DRILL-1895: - Tried with 1.2.0, error is much more descriptive now.

[jira] [Resolved] (DRILL-2051) NPE when querying view with where clause and derived table

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2051?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-2051. - Resolution: Fixed > NPE when querying view with where clause and derived table >

[jira] [Updated] (DRILL-3564) Error message fix required

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3564?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3564: -- Fix Version/s: (was: 1.3.0) Future > Error message fix required >

[jira] [Commented] (DRILL-3712) Drill does not recognize UTF-16-LE encoding

2015-10-08 Thread Steven Phillips (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949499#comment-14949499 ] Steven Phillips commented on DRILL-3712: The second column is utf16 encoded. I don't think any of

[jira] [Comment Edited] (DRILL-2859) Unexpected exception in the query with an interval data type

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2859?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949550#comment-14949550 ] Victoria Markman edited comment on DRILL-2859 at 10/8/15 10:43 PM: --- As

[jira] [Commented] (DRILL-2859) Unexpected exception in the query with an interval data type

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2859?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949551#comment-14949551 ] Victoria Markman commented on DRILL-2859: - I marked this bug as critical because this looks like

[jira] [Updated] (DRILL-2859) Unexpected exception in the query with an interval data type

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2859?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2859: Priority: Critical (was: Major) > Unexpected exception in the query with an interval data

[jira] [Commented] (DRILL-2859) Unexpected exception in the query with an interval data type

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2859?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949550#comment-14949550 ] Victoria Markman commented on DRILL-2859: - {code} 0: jdbc:drill:schema=dfs> select cast(cast(a1 as

[jira] [Commented] (DRILL-2891) Allowing ROUND function on boolean type can cause all sorts of problems

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2891?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=14949561#comment-14949561 ] Victoria Markman commented on DRILL-2891: - Now that I think about it, first case is technically

[jira] [Updated] (DRILL-2139) Star is not expanded correctly in "select distinct" query

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2139?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2139: Priority: Critical (was: Major) > Star is not expanded correctly in "select distinct"

[jira] [Resolved] (DRILL-1998) Confusing error message when you pass character data type to SUM aggregate function

2015-10-08 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1998?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-1998. - Resolution: Fixed > Confusing error message when you pass character data type to SUM

[jira] [Updated] (DRILL-3712) Drill does not recognize UTF-16-LE encoding

2015-10-08 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-3712: Description: We are unable to process files that OSX identifies as character sete UTF16LE.

[jira] [Updated] (DRILL-3539) CTAS over empty json file throws NPE

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3539: -- Assignee: (was: Sean Hsuan-Yi Chu) > CTAS over empty json file throws NPE >

[jira] [Updated] (DRILL-3419) Handle scans optimally when all files are pruned out

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3419?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3419: -- Fix Version/s: (was: 1.3.0) Future > Handle scans optimally when all

[jira] [Updated] (DRILL-3468) CTAS IOB

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3468?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3468: -- Assignee: (was: Steven Phillips) > CTAS IOB > > > Key: DRILL-3468

[jira] [Updated] (DRILL-3419) Handle scans optimally when all files are pruned out

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3419?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3419: -- Assignee: (was: Jinfeng Ni) > Handle scans optimally when all files are pruned out >

[jira] [Updated] (DRILL-3468) CTAS IOB

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3468?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3468: -- Fix Version/s: (was: 1.3.0) Future > CTAS IOB > > >

[jira] [Updated] (DRILL-3456) Need support for default values for column in CTAS

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3456?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3456: -- Fix Version/s: (was: 1.4.0) Future > Need support for default values for

[jira] [Updated] (DRILL-3539) CTAS over empty json file throws NPE

2015-10-08 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3539?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-3539: -- Fix Version/s: (was: 1.3.0) Future > CTAS over empty json file throws

  1   2   >