[jira] [Commented] (DRILL-3810) Filesystem plugin's support for file format's schema

2015-12-10 Thread Jacques Nadeau (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3810?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15052045#comment-15052045 ] Jacques Nadeau commented on DRILL-3810: --- This patch only provides schema for Avro fi

[jira] [Closed] (DRILL-4103) Add additional metadata to Parquet files generated by Drill

2015-12-10 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4103?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-4103. - verified. [root@qa-node120 parquet-tools-1.4.2-SNAPSHOT]# ./parquet-meta /tmp/foo.parquet creator: parq

[jira] [Reopened] (DRILL-3810) Filesystem plugin's support for file format's schema

2015-12-10 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3810?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang reopened DRILL-3810: --- Can someone explain to me what is the expected behavior for this fix? Against schema based file, we will

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

2015-12-10 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2481?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz closed DRILL-2481. - > Querying individual column from view results in AssertionError > ---

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

2015-12-10 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2481?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15051863#comment-15051863 ] Khurram Faraaz commented on DRILL-2481: --- Verified, we see the same error message. {

[jira] [Updated] (DRILL-4109) NPE in RecordIterator

2015-12-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4109?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-4109: Component/s: Execution - Relational Operators > NPE in RecordIterator >

[jira] [Updated] (DRILL-3802) Throw unsupported error for ROLLUP/GROUPING

2015-12-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3802?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3802: Component/s: Query Planning & Optimization > Throw unsupported error for ROLLUP/GROUPING > -

[jira] [Updated] (DRILL-2419) UDF that returns string representation of expression type

2015-12-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2419?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2419: Reviewer: Victoria Markman > UDF that returns string representation of expression type > ---

[jira] [Updated] (DRILL-2601) Print SQL query text along with query id in drillbit.log

2015-12-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2601?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2601: Reviewer: Victoria Markman > Print SQL query text along with query id in drillbit.log >

[jira] [Updated] (DRILL-3871) Off by one error while reading binary fields with one terminal null in parquet

2015-12-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3871?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3871: Reviewer: Victoria Markman > Off by one error while reading binary fields with one terminal

[jira] [Updated] (DRILL-3802) Throw unsupported error for ROLLUP/GROUPING

2015-12-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3802?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-3802: Reviewer: Victoria Markman > Throw unsupported error for ROLLUP/GROUPING > -

[jira] [Updated] (DRILL-4109) NPE in RecordIterator

2015-12-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4109?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-4109: Reviewer: Victoria Markman > NPE in RecordIterator > - > >

[jira] [Closed] (DRILL-3538) We do not prune partitions when we count over partitioning key and filter over partitioning key

2015-12-10 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3538?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz closed DRILL-3538. - > We do not prune partitions when we count over partitioning key and filter > over partitioning key >

[jira] [Updated] (DRILL-2161) Flatten on a list within a list on a large data set results in an IOB Exception

2015-12-10 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2161?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang updated DRILL-2161: -- Reviewer: Rahul Challapalli > Flatten on a list within a list on a large data set results in an IOB > E

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

2015-12-10 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3854?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15051841#comment-15051841 ] Khurram Faraaz commented on DRILL-3854: --- Verified Fix. Test needs to be added. {cod

[jira] [Updated] (DRILL-3770) Query with window function having just ORDER BY clause runs out of memory on large datasets

2015-12-10 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3770?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang updated DRILL-3770: -- Reviewer: Abhishek Girish > Query with window function having just ORDER BY clause runs out of memory on

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

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

[jira] [Updated] (DRILL-3538) We do not prune partitions when we count over partitioning key and filter over partitioning key

2015-12-10 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3538?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang updated DRILL-3538: -- Reviewer: Khurram Faraaz > We do not prune partitions when we count over partitioning key and filter >

[jira] [Updated] (DRILL-3921) Hive LIMIT 1 queries take too long

2015-12-10 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang updated DRILL-3921: -- Reviewer: Krystal > Hive LIMIT 1 queries take too long > -- > >

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

2015-12-10 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3793?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang updated DRILL-3793: -- Reviewer: Chun Chang > Rewrite MergeJoinBatch using record batch iterator. > ---

[jira] [Updated] (DRILL-3543) Add stats for external sort to a query profile

2015-12-10 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3543?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang updated DRILL-3543: -- Reviewer: Victoria Markman > Add stats for external sort to a query profile > --

[jira] [Updated] (DRILL-4047) Select with options

2015-12-10 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4047?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang updated DRILL-4047: -- Reviewer: Chun Chang > Select with options > --- > > Key: DRILL-4047 >

[jira] [Updated] (DRILL-3952) Improve Window Functions performance when not all batches are required to process the current batch

2015-12-10 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang updated DRILL-3952: -- Reviewer: Chun Chang > Improve Window Functions performance when not all batches are required to > proc

[jira] [Updated] (DRILL-4103) Add additional metadata to Parquet files generated by Drill

2015-12-10 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4103?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang updated DRILL-4103: -- Reviewer: Chun Chang > Add additional metadata to Parquet files generated by Drill > ---

[jira] [Updated] (DRILL-4165) IllegalStateException in MergeJoin for a query against TPC-DS data

2015-12-10 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4165?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang updated DRILL-4165: -- Reviewer: Chun Chang > IllegalStateException in MergeJoin for a query against TPC-DS data >

[jira] [Updated] (DRILL-3810) Filesystem plugin's support for file format's schema

2015-12-10 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3810?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang updated DRILL-3810: -- Reviewer: Chun Chang > Filesystem plugin's support for file format's schema > --

[jira] [Updated] (DRILL-4125) Illegal argument exception during merge join

2015-12-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4125?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-4125: Reviewer: Victoria Markman > Illegal argument exception during merge join > ---

[jira] [Updated] (DRILL-2967) Incompatible types error reported in a "not in" query with compatible data types

2015-12-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2967?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2967: Reviewer: Victoria Markman > Incompatible types error reported in a "not in" query with comp

[jira] [Closed] (DRILL-3980) Build failure in -Pmapr profile (due to DRILL-3749)

2015-12-10 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3980?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rahul Challapalli closed DRILL-3980. > Build failure in -Pmapr profile (due to DRILL-3749) >

[jira] [Closed] (DRILL-4040) Build failure on master

2015-12-10 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4040?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rahul Challapalli closed DRILL-4040. Clean builds on our regression clusters indicate that this can be closed > Build failure on mas

[jira] [Commented] (DRILL-4124) Make all uses of AutoCloseables use addSuppressed exceptions to avoid noise in logs

2015-12-10 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4124?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15051719#comment-15051719 ] Rahul Challapalli commented on DRILL-4124: -- I am trying to functionally verify th

[jira] [Commented] (DRILL-4185) UNION ALL involving empty directory on any side of union all results in Failed query

2015-12-10 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4185?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15051667#comment-15051667 ] Khurram Faraaz commented on DRILL-4185: --- On the other hand if we use an empty file (

[jira] [Commented] (DRILL-2985) REGRESSION : NPE seen for project distinct values from CSV

2015-12-10 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2985?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15051653#comment-15051653 ] Khurram Faraaz commented on DRILL-2985: --- Verified fix, no NPE is returned. Negative

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

2015-12-10 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2849?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz closed DRILL-2849. - The issue is seen due to malformed data. Marking this one as closed. > Difference in query results ov

[jira] [Closed] (DRILL-3001) Some functional tests fail when new text reader is disabled

2015-12-10 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3001?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz closed DRILL-3001. - > Some functional tests fail when new text reader is disabled > --

[jira] [Closed] (DRILL-4036) logs/sqlline_queries.json can not be accessed by user mapr

2015-12-10 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4036?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz closed DRILL-4036. - > logs/sqlline_queries.json can not be accessed by user mapr > --

[jira] [Created] (DRILL-4185) UNION ALL involving empty directory on any side of union all results in Failed query

2015-12-10 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4185: - Summary: UNION ALL involving empty directory on any side of union all results in Failed query Key: DRILL-4185 URL: https://issues.apache.org/jira/browse/DRILL-4185

[jira] [Updated] (DRILL-4049) Workmanager.StatusThread is not terminated when Drillbit is shutdown

2015-12-10 Thread Suresh Ollala (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4049?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Ollala updated DRILL-4049: - Component/s: Execution - RPC > Workmanager.StatusThread is not terminated when Drillbit is shutdow

[jira] [Updated] (DRILL-4049) Workmanager.StatusThread is not terminated when Drillbit is shutdown

2015-12-10 Thread Suresh Ollala (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4049?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Ollala updated DRILL-4049: - Fix Version/s: 1.4.0 > Workmanager.StatusThread is not terminated when Drillbit is shutdown >

[jira] [Updated] (DRILL-4006) As json reader reads a field with empty lists, IOOB could happen

2015-12-10 Thread Suresh Ollala (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4006?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Ollala updated DRILL-4006: - Fix Version/s: 1.3.0 > As json reader reads a field with empty lists, IOOB could happen >

[jira] [Updated] (DRILL-3965) Index out of bounds exception in partition pruning

2015-12-10 Thread Suresh Ollala (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3965?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Ollala updated DRILL-3965: - Fix Version/s: 1.3.0 > Index out of bounds exception in partition pruning > --

[jira] [Updated] (DRILL-3965) Index out of bounds exception in partition pruning

2015-12-10 Thread Suresh Ollala (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3965?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Ollala updated DRILL-3965: - Component/s: Query Planning & Optimization > Index out of bounds exception in partition pruning >

[jira] [Updated] (DRILL-3887) Parquet metadata cache not being used

2015-12-10 Thread Suresh Ollala (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3887?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Suresh Ollala updated DRILL-3887: - Fix Version/s: 1.3.0 > Parquet metadata cache not being used > ---

[jira] [Closed] (DRILL-4065) ImpersonationUtil always creates new UserGroupInformation (thus new FileSystem objects), causing excessive number of threads

2015-12-10 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4065?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-4065. - Verified with impersonation automation. > ImpersonationUtil always creates new UserGroupInformation (thus new

[jira] [Closed] (DRILL-4028) Merge Drill parquet modifications back into the mainline project

2015-12-10 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4028?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-4028. - Verified that both PRs to parquet-mr and drill are closed. > Merge Drill parquet modifications back into the

[jira] [Commented] (DRILL-2639) Planner bug - RelOptPlanner.CannotPlanException

2015-12-10 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2639?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15051448#comment-15051448 ] Khurram Faraaz commented on DRILL-2639: --- Verified Fix. Test needs to be added. {cod

[jira] [Commented] (DRILL-3183) Query that uses window functions returns NPE

2015-12-10 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3183?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15051437#comment-15051437 ] Khurram Faraaz commented on DRILL-3183: --- Verified Fix on Drill 1.4, we do not see NP

[jira] [Reopened] (DRILL-3214) Config option to cast empty string to null does not cast empty string to null

2015-12-10 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3214?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz reopened DRILL-3214: --- Re-opening this one. Empty strings are not cast to null, even when the system wide config option

[jira] [Commented] (DRILL-3214) Config option to cast empty string to null does not cast empty string to null

2015-12-10 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3214?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15051422#comment-15051422 ] Khurram Faraaz commented on DRILL-3214: --- {code} 0: jdbc:drill:schema=dfs.tmp> SELEC

[jira] [Commented] (DRILL-3245) Error message needs to be fixed.

2015-12-10 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3245?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15051406#comment-15051406 ] Khurram Faraaz commented on DRILL-3245: --- Verified Fix on Drill 1.4. Negative tests n

[jira] [Commented] (DRILL-2796) Select keys from JSON file where not in null results in RelOptPlanner.CannotPlanException

2015-12-10 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2796?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15051399#comment-15051399 ] Khurram Faraaz commented on DRILL-2796: --- This is seen on Drill 1.4 {code} 0: jdbc:d

[jira] [Updated] (DRILL-2796) Select keys from JSON file where not in null results in RelOptPlanner.CannotPlanException

2015-12-10 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-2796: -- Priority: Critical (was: Major) > Select keys from JSON file where not in null results in > R

[jira] [Commented] (DRILL-3374) CTAS with PARTITION BY, partition column name from view can not be resolved

2015-12-10 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3374?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15051374#comment-15051374 ] Khurram Faraaz commented on DRILL-3374: --- Verified Fix. Test will be added. {code} 0

[jira] [Closed] (DRILL-3378) Average over window on a view returns wrong results

2015-12-10 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3378?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz closed DRILL-3378. - Verified. Test was added here - Functional/window_functions/views/winOvrVws_37.q > Average over windo

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

2015-12-10 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3600?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15051339#comment-15051339 ] Khurram Faraaz commented on DRILL-3600: --- Verified, negative test needs to be added.

[jira] [Created] (DRILL-4184) query selecting on parquet decimal field fails with ClassCastException

2015-12-10 Thread Dave Oshinsky (JIRA)
Dave Oshinsky created DRILL-4184: Summary: query selecting on parquet decimal field fails with ClassCastException Key: DRILL-4184 URL: https://issues.apache.org/jira/browse/DRILL-4184 Project: Apache

[jira] [Commented] (DRILL-4182) Support Schema changes for TopN Operator

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