[jira] [Commented] (DRILL-4877) max(dir0), max(dir1) query against parquet data slower by 2X

2016-09-29 Thread Kunal Khatua (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4877?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15534667#comment-15534667 ] Kunal Khatua commented on DRILL-4877: - [~khfaraaz] Khurram, can you verify and close this JIRA. >

[jira] [Commented] (DRILL-4203) Parquet File : Date is stored wrongly

2016-09-29 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4203?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15534226#comment-15534226 ] ASF GitHub Bot commented on DRILL-4203: --- Github user parthchandra commented on a diff in the pull

[jira] [Commented] (DRILL-4203) Parquet File : Date is stored wrongly

2016-09-29 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4203?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15534230#comment-15534230 ] ASF GitHub Bot commented on DRILL-4203: --- Github user parthchandra commented on a diff in the pull

[jira] [Commented] (DRILL-4203) Parquet File : Date is stored wrongly

2016-09-29 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4203?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15534229#comment-15534229 ] ASF GitHub Bot commented on DRILL-4203: --- Github user parthchandra commented on a diff in the pull

[jira] [Commented] (DRILL-4203) Parquet File : Date is stored wrongly

2016-09-29 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4203?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15534228#comment-15534228 ] ASF GitHub Bot commented on DRILL-4203: --- Github user parthchandra commented on a diff in the pull

[jira] [Commented] (DRILL-4203) Parquet File : Date is stored wrongly

2016-09-29 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4203?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15534227#comment-15534227 ] ASF GitHub Bot commented on DRILL-4203: --- Github user parthchandra commented on a diff in the pull

[jira] [Commented] (DRILL-4918) Adding 2 dates results in AssertionError: Multiple functions with best cost found

2016-09-29 Thread Julian Hyde (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4918?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15534220#comment-15534220 ] Julian Hyde commented on DRILL-4918: Adding two dates should give a validation error (or runtime error

[jira] [Commented] (DRILL-4905) Push down the LIMIT to the parquet reader scan to limit the numbers of records read

2016-09-29 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15534211#comment-15534211 ] ASF GitHub Bot commented on DRILL-4905: --- Github user jinfengni commented on a diff in the pull

[jira] [Commented] (DRILL-4905) Push down the LIMIT to the parquet reader scan to limit the numbers of records read

2016-09-29 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15534206#comment-15534206 ] ASF GitHub Bot commented on DRILL-4905: --- Github user gparai commented on a diff in the pull request:

[jira] [Commented] (DRILL-4905) Push down the LIMIT to the parquet reader scan to limit the numbers of records read

2016-09-29 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15534201#comment-15534201 ] ASF GitHub Bot commented on DRILL-4905: --- Github user ppadma commented on a diff in the pull request:

[jira] [Commented] (DRILL-4905) Push down the LIMIT to the parquet reader scan to limit the numbers of records read

2016-09-29 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15534172#comment-15534172 ] ASF GitHub Bot commented on DRILL-4905: --- Github user gparai commented on a diff in the pull request:

[jira] [Commented] (DRILL-4905) Push down the LIMIT to the parquet reader scan to limit the numbers of records read

2016-09-29 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15534097#comment-15534097 ] ASF GitHub Bot commented on DRILL-4905: --- Github user ppadma commented on a diff in the pull request:

[jira] [Created] (DRILL-4918) Adding 2 dates results in AssertionError: Multiple functions with best cost found

2016-09-29 Thread Rahul Challapalli (JIRA)
Rahul Challapalli created DRILL-4918: Summary: Adding 2 dates results in AssertionError: Multiple functions with best cost found Key: DRILL-4918 URL: https://issues.apache.org/jira/browse/DRILL-4918

[jira] [Updated] (DRILL-4918) Adding 2 dates results in AssertionError: Multiple functions with best cost found

2016-09-29 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4918?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rahul Challapalli updated DRILL-4918: - Description: git.commit.id.abbrev=2295715 The below query fails {code} select

[jira] [Commented] (DRILL-4905) Push down the LIMIT to the parquet reader scan to limit the numbers of records read

2016-09-29 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15534031#comment-15534031 ] ASF GitHub Bot commented on DRILL-4905: --- Github user gparai commented on a diff in the pull request:

[jira] [Commented] (DRILL-4905) Push down the LIMIT to the parquet reader scan to limit the numbers of records read

2016-09-29 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15533995#comment-15533995 ] ASF GitHub Bot commented on DRILL-4905: --- Github user jinfengni commented on the issue:

[jira] [Commented] (DRILL-4905) Push down the LIMIT to the parquet reader scan to limit the numbers of records read

2016-09-29 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15533979#comment-15533979 ] ASF GitHub Bot commented on DRILL-4905: --- Github user ppadma commented on the issue:

[jira] [Updated] (DRILL-4917) Unable to alias columns from subquery

2016-09-29 Thread Dan Wild (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4917?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dan Wild updated DRILL-4917: Description: Column aliasing works in a simple query (without subqueries): {code} select 1 as myVal from

[jira] [Updated] (DRILL-4917) Unable to alias columns from subquery

2016-09-29 Thread Dan Wild (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4917?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dan Wild updated DRILL-4917: Description: Column aliasing works in a simple query (without subqueries): {code} select 1 as myVal from

[jira] [Updated] (DRILL-4917) Unable to alias columns from subquery

2016-09-29 Thread Dan Wild (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4917?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dan Wild updated DRILL-4917: Description: Column aliasing works in a simple query (without subqueries): {code} select 1 as myVal from

[jira] [Updated] (DRILL-4917) Unable to alias columns from subquery

2016-09-29 Thread Dan Wild (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4917?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dan Wild updated DRILL-4917: Description: Column aliasing works in a simple query (without subqueries): {code} select 1 as myVal from

[jira] [Updated] (DRILL-4917) Unable to alias columns from subquery

2016-09-29 Thread Dan Wild (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4917?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Dan Wild updated DRILL-4917: Description: Column aliasing works in a simple query (without subqueries): {code} select 1 as myVal from

[jira] [Created] (DRILL-4917) Unable to alias columns from subquery

2016-09-29 Thread Dan Wild (JIRA)
Dan Wild created DRILL-4917: --- Summary: Unable to alias columns from subquery Key: DRILL-4917 URL: https://issues.apache.org/jira/browse/DRILL-4917 Project: Apache Drill Issue Type: Bug Affects

[jira] [Closed] (DRILL-4673) Implement "DROP TABLE IF EXISTS" for drill to prevent FAILED status on command return

2016-09-29 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4673?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-4673. - added automation. > Implement "DROP TABLE IF EXISTS" for drill to prevent FAILED status on > command return

[jira] [Commented] (DRILL-4905) Push down the LIMIT to the parquet reader scan to limit the numbers of records read

2016-09-29 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15533511#comment-15533511 ] ASF GitHub Bot commented on DRILL-4905: --- Github user jinfengni commented on a diff in the pull

[jira] [Commented] (DRILL-4905) Push down the LIMIT to the parquet reader scan to limit the numbers of records read

2016-09-29 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15533501#comment-15533501 ] ASF GitHub Bot commented on DRILL-4905: --- Github user jinfengni commented on a diff in the pull

[jira] [Commented] (DRILL-4905) Push down the LIMIT to the parquet reader scan to limit the numbers of records read

2016-09-29 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4905?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15533479#comment-15533479 ] ASF GitHub Bot commented on DRILL-4905: --- Github user jinfengni commented on a diff in the pull

[jira] [Updated] (DRILL-4916) Drill UI - SCAN appears on top of PROJECT in Profiles tab

2016-09-29 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4916?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-4916: -- Attachment: scan_project.jpg {noformat} Here is the query 0: jdbc:drill:schema=dfs.tmp> select

[jira] [Created] (DRILL-4916) Drill UI - SCAN appears on top of PROJECT in Profiles tab

2016-09-29 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4916: - Summary: Drill UI - SCAN appears on top of PROJECT in Profiles tab Key: DRILL-4916 URL: https://issues.apache.org/jira/browse/DRILL-4916 Project: Apache Drill

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

2016-09-29 Thread Sorabh Hamirwasia (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3751?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15533389#comment-15533389 ] Sorabh Hamirwasia commented on DRILL-3751: -- Yes I did try with one ZK running on a 4 node

[jira] [Commented] (DRILL-4906) CASE Expression with constant generates class exception

2016-09-29 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15533188#comment-15533188 ] ASF GitHub Bot commented on DRILL-4906: --- Github user amansinha100 commented on a diff in the pull

[jira] [Updated] (DRILL-4915) IndexOutOfBoundsException while schema contains different types

2016-09-29 Thread Alex Khomchenko (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alex Khomchenko updated DRILL-4915: --- Description: Good day. First of all - thank you for a great tool! I apologise for a bad

[jira] [Updated] (DRILL-4915) IndexOutOfBoundsException while schema contains different types

2016-09-29 Thread Alex Khomchenko (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alex Khomchenko updated DRILL-4915: --- Environment: (was: mac os x 10.12) > IndexOutOfBoundsException while schema contains

[jira] [Created] (DRILL-4915) IndexOutOfBoundsException while schema contains different types

2016-09-29 Thread Alex Khomchenko (JIRA)
Alex Khomchenko created DRILL-4915: -- Summary: IndexOutOfBoundsException while schema contains different types Key: DRILL-4915 URL: https://issues.apache.org/jira/browse/DRILL-4915 Project: Apache

[jira] [Issue Comment Deleted] (DRILL-4915) IndexOutOfBoundsException while schema contains different types

2016-09-29 Thread Alex Khomchenko (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alex Khomchenko updated DRILL-4915: --- Comment: was deleted (was: Sample files) > IndexOutOfBoundsException while schema contains

[jira] [Issue Comment Deleted] (DRILL-4915) IndexOutOfBoundsException while schema contains different types

2016-09-29 Thread Alex Khomchenko (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alex Khomchenko updated DRILL-4915: --- Comment: was deleted (was: stacktrace) > IndexOutOfBoundsException while schema contains

[jira] [Updated] (DRILL-4915) IndexOutOfBoundsException while schema contains different types

2016-09-29 Thread Alex Khomchenko (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alex Khomchenko updated DRILL-4915: --- Attachment: stacktrace.txt stacktrace > IndexOutOfBoundsException while schema contains

[jira] [Updated] (DRILL-4915) IndexOutOfBoundsException while schema contains different types

2016-09-29 Thread Alex Khomchenko (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alex Khomchenko updated DRILL-4915: --- Description: Good day. First of all - thank you for a great tool! I apologise for a bad

[jira] [Updated] (DRILL-4915) IndexOutOfBoundsException while schema contains different types

2016-09-29 Thread Alex Khomchenko (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4915?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Alex Khomchenko updated DRILL-4915: --- Attachment: test3.json test2.json test1.json Sample files >

[jira] [Commented] (DRILL-4906) CASE Expression with constant generates class exception

2016-09-29 Thread ASF GitHub Bot (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4906?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15532526#comment-15532526 ] ASF GitHub Bot commented on DRILL-4906: --- Github user Serhii-Harnyk commented on a diff in the pull

[jira] [Created] (DRILL-4914) need better error message to handle invalid inputs to AGE function

2016-09-29 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4914: - Summary: need better error message to handle invalid inputs to AGE function Key: DRILL-4914 URL: https://issues.apache.org/jira/browse/DRILL-4914 Project: Apache

[jira] [Updated] (DRILL-4755) StringIndexOutOfBoundsException seen with CONVERT_FROM function

2016-09-29 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4755?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-4755: -- Attachment: date_data.csv added data file used in test. > StringIndexOutOfBoundsException seen

[jira] [Commented] (DRILL-4755) StringIndexOutOfBoundsException seen with CONVERT_FROM function

2016-09-29 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4755?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15532325#comment-15532325 ] Khurram Faraaz commented on DRILL-4755: --- Another test results in same Exception on Drill 1.9.0

[jira] [Created] (DRILL-4913) need a better error message when explicit cast DATE value to TIME

2016-09-29 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4913: - Summary: need a better error message when explicit cast DATE value to TIME Key: DRILL-4913 URL: https://issues.apache.org/jira/browse/DRILL-4913 Project: Apache

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

2016-09-29 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3751?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15531979#comment-15531979 ] Khurram Faraaz commented on DRILL-3751: --- Did you try to repro on single node or on a cluster ? In my