[jira] [Updated] (DRILL-5705) Select * on hbase table having multiple regions and multiple schema returns wrong result

2017-08-04 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5705?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Nagaraj Subramanya updated DRILL-5705: - Description: Repro steps- 1) Create a hbase table with 4 regions- {code}

[jira] [Created] (DRILL-5705) Select * on hbase table having multiple regions and multiple schema returns wrong result

2017-08-04 Thread Prasad Nagaraj Subramanya (JIRA)
Prasad Nagaraj Subramanya created DRILL-5705: Summary: Select * on hbase table having multiple regions and multiple schema returns wrong result Key: DRILL-5705 URL: https://issues.apache.org/jira/brows

[jira] [Updated] (DRILL-5705) Select * on hbase table having multiple regions and multiple schema returns wrong result

2017-08-04 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5705?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Nagaraj Subramanya updated DRILL-5705: - Description: Repro steps- 1) Create a hbase table with 4 regions- {code}

[jira] [Updated] (DRILL-5705) Select * on hbase table having multiple regions and multiple schema returns wrong result

2017-08-04 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5705?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Nagaraj Subramanya updated DRILL-5705: - Description: Repro steps- 1) Create a hbase table with 4 regions- {code}

[jira] [Created] (DRILL-5706) Select * on hbase table having multiple regions(one or more empty) returns wrong result intermittently

2017-08-04 Thread Prasad Nagaraj Subramanya (JIRA)
Prasad Nagaraj Subramanya created DRILL-5706: Summary: Select * on hbase table having multiple regions(one or more empty) returns wrong result intermittently Key: DRILL-5706 URL: https://issues.apache.

[jira] [Created] (DRILL-5711) Incorrect operator profiles for queries on json files

2017-08-09 Thread Prasad Nagaraj Subramanya (JIRA)
Prasad Nagaraj Subramanya created DRILL-5711: Summary: Incorrect operator profiles for queries on json files Key: DRILL-5711 URL: https://issues.apache.org/jira/browse/DRILL-5711 Project: A

[jira] [Updated] (DRILL-5711) Incorrect operator profiles for queries on json files

2017-08-09 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5711?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Nagaraj Subramanya updated DRILL-5711: - Attachment: OperatorProfiles.png QueryProfile.png

[jira] [Updated] (DRILL-5711) Incorrect operator profiles for queries on json files

2017-08-09 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5711?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Nagaraj Subramanya updated DRILL-5711: - Description: 1) Join query on two json files {code} select ps.ps_suppkey f

[jira] [Updated] (DRILL-5711) Incorrect operator profiles for queries on json files

2017-08-09 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5711?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Nagaraj Subramanya updated DRILL-5711: - Description: 1) Join query on two json files {code} select ps.ps_suppkey f

[jira] [Created] (DRILL-5719) Join query on a non existing column in a json file runs infinitely

2017-08-13 Thread Prasad Nagaraj Subramanya (JIRA)
Prasad Nagaraj Subramanya created DRILL-5719: Summary: Join query on a non existing column in a json file runs infinitely Key: DRILL-5719 URL: https://issues.apache.org/jira/browse/DRILL-5719

[jira] [Updated] (DRILL-5719) Join query on a non existing column in a json file runs longer than usual

2017-08-14 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5719?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Nagaraj Subramanya updated DRILL-5719: - Summary: Join query on a non existing column in a json file runs longer th

[jira] [Updated] (DRILL-5719) Join query on a non existing column in a json file runs longer than usual

2017-08-14 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5719?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Nagaraj Subramanya updated DRILL-5719: - Description: 1) Join query on two json files Column exists {code} select t

[jira] [Updated] (DRILL-5719) Join query on a non existing column in a json file runs longer than usual

2017-08-14 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5719?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Nagaraj Subramanya updated DRILL-5719: - Description: 1) Join query on two json files Column exists {code} select t

[jira] [Created] (DRILL-5724) Scan on a local directory containing multiple text files (one or more empty) throws FileNotFoundException

2017-08-16 Thread Prasad Nagaraj Subramanya (JIRA)
Prasad Nagaraj Subramanya created DRILL-5724: Summary: Scan on a local directory containing multiple text files (one or more empty) throws FileNotFoundException Key: DRILL-5724 URL: https://issues.apac

[jira] [Created] (DRILL-5742) CONVERT_FROM_JSON on a non-existing column in a file throws null pointer exception

2017-08-25 Thread Prasad Nagaraj Subramanya (JIRA)
Prasad Nagaraj Subramanya created DRILL-5742: Summary: CONVERT_FROM_JSON on a non-existing column in a file throws null pointer exception Key: DRILL-5742 URL: https://issues.apache.org/jira/bro

[jira] [Created] (DRILL-5743) Using order by clause in a select * query on hbase table returns only the row_key and order by field(s)

2017-08-27 Thread Prasad Nagaraj Subramanya (JIRA)
Prasad Nagaraj Subramanya created DRILL-5743: Summary: Using order by clause in a select * query on hbase table returns only the row_key and order by field(s) Key: DRILL-5743 URL: https://issues.apache

[jira] [Updated] (DRILL-5743) Using order by clause in a select * query on hbase table returns only the row_key and order by field(s)

2017-08-27 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5743?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Nagaraj Subramanya updated DRILL-5743: - Description: 1) Consider a hbase table 'part' having column family 'data',

[jira] [Created] (DRILL-5775) Select * query on a maprdb binary table fails

2017-09-07 Thread Prasad Nagaraj Subramanya (JIRA)
Prasad Nagaraj Subramanya created DRILL-5775: Summary: Select * query on a maprdb binary table fails Key: DRILL-5775 URL: https://issues.apache.org/jira/browse/DRILL-5775 Project: Apache Dr

[jira] [Created] (DRILL-5792) CONVERT_FROM_JSON on an empty file throws runtime exception

2017-09-14 Thread Prasad Nagaraj Subramanya (JIRA)
Prasad Nagaraj Subramanya created DRILL-5792: Summary: CONVERT_FROM_JSON on an empty file throws runtime exception Key: DRILL-5792 URL: https://issues.apache.org/jira/browse/DRILL-5792 Pro

[jira] [Commented] (DRILL-5724) Scan on a local directory containing multiple text files (one or more empty) throws FileNotFoundException

2017-09-15 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5724?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16168302#comment-16168302 ] Prasad Nagaraj Subramanya commented on DRILL-5724: -- Issue not reproducibl

[jira] [Resolved] (DRILL-5724) Scan on a local directory containing multiple text files (one or more empty) throws FileNotFoundException

2017-09-15 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5724?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Nagaraj Subramanya resolved DRILL-5724. -- Resolution: Cannot Reproduce > Scan on a local directory containing mult

[jira] [Assigned] (DRILL-5745) Invalid "location" information in Drill web server

2017-09-20 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5745?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Nagaraj Subramanya reassigned DRILL-5745: Assignee: Prasad Nagaraj Subramanya > Invalid "location" informatio

[jira] [Updated] (DRILL-5711) Incorrect operator profiles for queries on json files

2017-09-20 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5711?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Nagaraj Subramanya updated DRILL-5711: - Description: 1) Join query on two json files {code} select ps.ps_suppkey f

[jira] [Created] (DRILL-5819) Default value of security.admin.user_groups and security.admin.users is "true"

2017-09-25 Thread Prasad Nagaraj Subramanya (JIRA)
Prasad Nagaraj Subramanya created DRILL-5819: Summary: Default value of security.admin.user_groups and security.admin.users is "true" Key: DRILL-5819 URL: https://issues.apache.org/jira/browse/DRILL-58

[jira] [Created] (DRILL-5822) Select * on directory containing multiple json files (one or more empty) with same schema doesn't preserve column order

2017-09-27 Thread Prasad Nagaraj Subramanya (JIRA)
Prasad Nagaraj Subramanya created DRILL-5822: Summary: Select * on directory containing multiple json files (one or more empty) with same schema doesn't preserve column order Key: DRILL-5822 URL: https

[jira] [Updated] (DRILL-5822) Select * on directory containing multiple json files (one or more empty) with same schema doesn't preserve column order

2017-09-28 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5822?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Nagaraj Subramanya updated DRILL-5822: - Description: Repro steps 1) Have multiple json files in a directory having

[jira] [Commented] (DRILL-5822) Select * on directory containing multiple json files (one or more empty) with same schema doesn't preserve column order

2017-09-28 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5822?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16184544#comment-16184544 ] Prasad Nagaraj Subramanya commented on DRILL-5822: -- [~vitalii] Sorry for

[jira] [Assigned] (DRILL-5743) Using order by clause in a select * query on hbase table returns only the row_key and order by field(s)

2017-10-03 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5743?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Nagaraj Subramanya reassigned DRILL-5743: Assignee: Prasad Nagaraj Subramanya > Using order by clause in a se

[jira] [Commented] (DRILL-5851) Empty table during a join operation with a non empty table produces cast exception

2017-10-06 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5851?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16195542#comment-16195542 ] Prasad Nagaraj Subramanya commented on DRILL-5851: -- This looks to be only

[jira] [Commented] (DRILL-5851) Empty table during a join operation with a non empty table produces cast exception

2017-10-09 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5851?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16196581#comment-16196581 ] Prasad Nagaraj Subramanya commented on DRILL-5851: -- I did some analysis o

[jira] [Commented] (DRILL-5851) Empty table during a join operation with a non empty table produces cast exception

2017-10-09 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5851?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16197060#comment-16197060 ] Prasad Nagaraj Subramanya commented on DRILL-5851: -- This issue is being o

[jira] [Created] (DRILL-5859) Time for query queuing timeout not display correctly in WebUI

2017-10-10 Thread Prasad Nagaraj Subramanya (JIRA)
Prasad Nagaraj Subramanya created DRILL-5859: Summary: Time for query queuing timeout not display correctly in WebUI Key: DRILL-5859 URL: https://issues.apache.org/jira/browse/DRILL-5859 P

[jira] [Commented] (DRILL-5859) Time for query queuing timeout not display correctly in WebUI

2017-10-10 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5859?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16199718#comment-16199718 ] Prasad Nagaraj Subramanya commented on DRILL-5859: -- Opened a PR - https:

[jira] [Created] (DRILL-5861) Need HBase storage plugin validation when enabled / updated

2017-10-11 Thread Prasad Nagaraj Subramanya (JIRA)
Prasad Nagaraj Subramanya created DRILL-5861: Summary: Need HBase storage plugin validation when enabled / updated Key: DRILL-5861 URL: https://issues.apache.org/jira/browse/DRILL-5861 Pro

[jira] [Created] (DRILL-5869) Empty maps not handled

2017-10-12 Thread Prasad Nagaraj Subramanya (JIRA)
Prasad Nagaraj Subramanya created DRILL-5869: Summary: Empty maps not handled Key: DRILL-5869 URL: https://issues.apache.org/jira/browse/DRILL-5869 Project: Apache Drill Issue Ty

[jira] [Created] (DRILL-5880) java.sql.SQLException: UNSUPPORTED_OPERATION ERROR: This query cannot be planned possibly due to either a cartesian join or an inequality join

2017-10-16 Thread Prasad Nagaraj Subramanya (JIRA)
Prasad Nagaraj Subramanya created DRILL-5880: Summary: java.sql.SQLException: UNSUPPORTED_OPERATION ERROR: This query cannot be planned possibly due to either a cartesian join or an inequality join Key: DRILL-5880

[jira] [Created] (DRILL-5887) Display process user/ groups in Drill UI

2017-10-17 Thread Prasad Nagaraj Subramanya (JIRA)
Prasad Nagaraj Subramanya created DRILL-5887: Summary: Display process user/ groups in Drill UI Key: DRILL-5887 URL: https://issues.apache.org/jira/browse/DRILL-5887 Project: Apache Drill

[jira] [Created] (DRILL-5896) Handle vector creation in HbaseRecordReader to avoid NullableInt vectors later

2017-10-20 Thread Prasad Nagaraj Subramanya (JIRA)
Prasad Nagaraj Subramanya created DRILL-5896: Summary: Handle vector creation in HbaseRecordReader to avoid NullableInt vectors later Key: DRILL-5896 URL: https://issues.apache.org/jira/browse/DRILL-58

[jira] [Commented] (DRILL-5822) Select * on directory containing multiple json files (one or more empty) with same schema doesn't preserve column order

2017-10-21 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5822?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16214172#comment-16214172 ] Prasad Nagaraj Subramanya commented on DRILL-5822: -- I missed one thing in

[jira] [Assigned] (DRILL-5909) need new JMX metrics for (FAILED and CANCELED) queries

2017-11-01 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5909?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Nagaraj Subramanya reassigned DRILL-5909: Assignee: Prasad Nagaraj Subramanya > need new JMX metrics for (FAI

[jira] [Updated] (DRILL-5909) need new JMX metrics for (FAILED and CANCELED) queries

2017-11-01 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5909?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Nagaraj Subramanya updated DRILL-5909: - Fix Version/s: 1.12.0 > need new JMX metrics for (FAILED and CANCELED) que

[jira] [Created] (DRILL-5921) Counters metrics should be listed in table

2017-11-01 Thread Prasad Nagaraj Subramanya (JIRA)
Prasad Nagaraj Subramanya created DRILL-5921: Summary: Counters metrics should be listed in table Key: DRILL-5921 URL: https://issues.apache.org/jira/browse/DRILL-5921 Project: Apache Drill

[jira] [Created] (DRILL-5923) State of a successfully completed query shown as "COMPLETED"

2017-11-02 Thread Prasad Nagaraj Subramanya (JIRA)
Prasad Nagaraj Subramanya created DRILL-5923: Summary: State of a successfully completed query shown as "COMPLETED" Key: DRILL-5923 URL: https://issues.apache.org/jira/browse/DRILL-5923 Pr

[jira] [Created] (DRILL-5952) Implement "CREATE TABLE IF NOT EXISTS"

2017-11-10 Thread Prasad Nagaraj Subramanya (JIRA)
Prasad Nagaraj Subramanya created DRILL-5952: Summary: Implement "CREATE TABLE IF NOT EXISTS" Key: DRILL-5952 URL: https://issues.apache.org/jira/browse/DRILL-5952 Project: Apache Drill

[jira] [Updated] (DRILL-5921) Counters metrics should be listed in table

2017-11-10 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Nagaraj Subramanya updated DRILL-5921: - Issue Type: Improvement (was: Bug) > Counters metrics should be listed in

[jira] [Updated] (DRILL-5952) Implement "CREATE TABLE IF NOT EXISTS"

2017-11-10 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Nagaraj Subramanya updated DRILL-5952: - Issue Type: Improvement (was: Bug) > Implement "CREATE TABLE IF NOT EXIST

[jira] [Updated] (DRILL-5909) need new JMX metrics for (FAILED and CANCELED) queries

2017-11-10 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5909?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Nagaraj Subramanya updated DRILL-5909: - Issue Type: Improvement (was: Bug) > need new JMX metrics for (FAILED and

[jira] [Assigned] (DRILL-4092) Support for INTERSECT

2017-11-11 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4092?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Nagaraj Subramanya reassigned DRILL-4092: Assignee: Prasad Nagaraj Subramanya (was: Chunhui Shi) > Support f

[jira] [Created] (DRILL-5998) Queue information of queries which fail due to queue time out not shown

2017-11-28 Thread Prasad Nagaraj Subramanya (JIRA)
Prasad Nagaraj Subramanya created DRILL-5998: Summary: Queue information of queries which fail due to queue time out not shown Key: DRILL-5998 URL: https://issues.apache.org/jira/browse/DRILL-5998

[jira] [Updated] (DRILL-6025) Execution time of a running query shown as 'NOT AVAILABLE'

2017-12-11 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6025?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Nagaraj Subramanya updated DRILL-6025: - Issue Type: Improvement (was: Bug) > Execution time of a running query sh

[jira] [Created] (DRILL-6025) Execution time of a running query shown as 'NOT AVAILABLE'

2017-12-11 Thread Prasad Nagaraj Subramanya (JIRA)
Prasad Nagaraj Subramanya created DRILL-6025: Summary: Execution time of a running query shown as 'NOT AVAILABLE' Key: DRILL-6025 URL: https://issues.apache.org/jira/browse/DRILL-6025 Proje

[jira] [Commented] (DRILL-6025) Execution time of a running query shown as 'NOT AVAILABLE'

2017-12-11 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6025?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16287225#comment-16287225 ] Prasad Nagaraj Subramanya commented on DRILL-6025: -- No, the total time sh

[jira] [Created] (DRILL-6066) AssertionError: Internal error: Conversion to relational algebra failed to preserve datatypes: validated type

2018-01-02 Thread Prasad Nagaraj Subramanya (JIRA)
Prasad Nagaraj Subramanya created DRILL-6066: Summary: AssertionError: Internal error: Conversion to relational algebra failed to preserve datatypes: validated type Key: DRILL-6066 URL: https://issues.

[jira] [Updated] (DRILL-6066) AssertionError: Internal error: Conversion to relational algebra failed to preserve datatypes: validated type

2018-01-13 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6066?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Nagaraj Subramanya updated DRILL-6066: - Description: Query - framework/resources/Datasources/limit0/aggregates/tpc

[jira] [Updated] (DRILL-6066) AssertionError: Internal error: Conversion to relational algebra failed to preserve datatypes: validated type

2018-01-15 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-6066?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Nagaraj Subramanya updated DRILL-6066: - Affects Version/s: (was: 1.13.0) > AssertionError: Internal error: Con

[jira] [Resolved] (DRILL-5998) Queue information of queries which fail due to queue time out not shown

2018-01-22 Thread Prasad Nagaraj Subramanya (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5998?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Prasad Nagaraj Subramanya resolved DRILL-5998. -- Resolution: Cannot Reproduce > Queue information of queries which fail d