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

2015-04-24 Thread Daniel Barclay (Drill) (JIRA)
Daniel Barclay (Drill) created DRILL-2877: - Summary: "mvn validate" builds .tar file Key: DRILL-2877 URL: https://issues.apache.org/jira/browse/DRILL-2877 Project: Apache Drill Issue

[jira] [Updated] (DRILL-2856) StreamingAggBatch goes into infinite loop due to state management issues

2015-04-24 Thread Venki Korukanti (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2856?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Venki Korukanti updated DRILL-2856: --- Attachment: DRILL-2856-1.patch Posting patch on behalf of [~jnadeau] > StreamingAggBatch goes

[jira] [Updated] (DRILL-2855) Fix invalid result issues with StreamingAggBatch

2015-04-24 Thread Venki Korukanti (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2855?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Venki Korukanti updated DRILL-2855: --- Attachment: DRILL-2855-1.patch Review Board Link: https://reviews.apache.org/r/33541/ > Fix i

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

2015-04-24 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2872?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14512011#comment-14512011 ] Parth Chandra commented on DRILL-2872: -- This is an issue with converting from a repea

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

2015-04-24 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2872?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2872: - Component/s: (was: Client - C++) Execution - Data Types > Result from json fi

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

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

[jira] [Updated] (DRILL-2857) Update the StreamingAggBatch current workspace record counter variable type to "long" from current type "int"

2015-04-24 Thread Venki Korukanti (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2857?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Venki Korukanti updated DRILL-2857: --- Attachment: DRILL-2857-1.patch Minor change. Will work with QA to add a test case as part of t

[jira] [Updated] (DRILL-2858) Refactor hash expression construction in InsertLocalExchangeVisitor and PrelUtil into one place

2015-04-24 Thread Venki Korukanti (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2858?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Venki Korukanti updated DRILL-2858: --- Attachment: DRILL-2858-1.patch Review Board Link: https://reviews.apache.org/r/33540/ > Refac

[jira] [Closed] (DRILL-2375) project more than one column from nested array causes indexoutofbounds exception

2015-04-24 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-2375. - Assignee: Chun Chang (was: Hanifi Gunes) this is fixed. {code} 0: jdbc:drill:schema=dfs.drillTestDirAdv

[jira] [Closed] (DRILL-2484) Document CASE expression

2015-04-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2484?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2484. --- > Document CASE expression > > > Key: DRILL-2484 >

[jira] [Resolved] (DRILL-2712) Issue with PruneScanRule and filter expressions that evaluate to false

2015-04-24 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu resolved DRILL-2712. -- Resolution: Fixed > Issue with PruneScanRule and filter expressions that evaluate to fal

[jira] [Closed] (DRILL-1558) Count() does not work on JSON (and JSON-converted-Parquet)

2015-04-24 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1558?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish closed DRILL-1558. -- Marked as invalid. Closing. > Count() does not work on JSON (and JSON-converted-Parquet) > ---

[jira] [Closed] (DRILL-1269) Select * on parquet files containing nulls fail

2015-04-24 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1269?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish closed DRILL-1269. -- Marked as invalid. Closing. > Select * on parquet files containing nulls fail > --

[jira] [Updated] (DRILL-2712) Issue with PruneScanRule and filter expressions that evaluate to false

2015-04-24 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2712?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Aman Sinha updated DRILL-2712: -- Assignee: Sean Hsuan-Yi Chu (was: Aman Sinha) > Issue with PruneScanRule and filter expressions that ev

[jira] [Commented] (DRILL-2712) Issue with PruneScanRule and filter expressions that evaluate to false

2015-04-24 Thread Aman Sinha (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2712?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14511998#comment-14511998 ] Aman Sinha commented on DRILL-2712: --- +1 on the tests. Committed in eb199d614. Note thi

[jira] [Closed] (DRILL-1011) Query appears to hang after displaying result

2015-04-24 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1011?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish closed DRILL-1011. -- Issue marked as duplicate. Closing. > Query appears to hang after displaying result >

[jira] [Closed] (DRILL-1012) [Tracking] TPC-DS queries blocked due to DRILL-986

2015-04-24 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1012?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish closed DRILL-1012. -- Marked as duplicate. Closing. > [Tracking] TPC-DS queries blocked due to DRILL-986 > -

[jira] [Closed] (DRILL-986) Explicit cast of empty string to double/integer throws NumberFormatException

2015-04-24 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-986?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish closed DRILL-986. - Marked as duplicate. Closing. > Explicit cast of empty string to double/integer throws NumberFormatEx

[jira] [Closed] (DRILL-1920) BYTEA data type is not supported, but is documented

2015-04-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1920?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-1920. --- Verified, was removed from the docs. > BYTEA data type is not supported, but is documented >

[jira] [Closed] (DRILL-2389) The hour number extracted from current_timestamp is wrong

2015-04-24 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2389?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-2389. - Assignee: Chun Chang (was: Mehant Baid) This is covered in the Functional/Passing/datetime. It is broken

[jira] [Updated] (DRILL-2876) Data from RHS of Union All is lost, when column on LHS is non-existent

2015-04-24 Thread Sean Hsuan-Yi Chu (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Sean Hsuan-Yi Chu updated DRILL-2876: - Assignee: Sean Hsuan-Yi Chu (was: Jinfeng Ni) > Data from RHS of Union All is lost, when

[jira] [Created] (DRILL-2876) Data from RHS of Union All is lost, when column on LHS is non-existent

2015-04-24 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-2876: - Summary: Data from RHS of Union All is lost, when column on LHS is non-existent Key: DRILL-2876 URL: https://issues.apache.org/jira/browse/DRILL-2876 Project: Apach

[jira] [Closed] (DRILL-2739) Drill stops reading columns > 4095

2015-04-24 Thread Krystal (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2739?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Krystal closed DRILL-2739. -- verified that bug is fixed. drill git.commit.id=e99f270322ec17580e728bf28a20b978a7fbdf8b Test added to /private-sql

[jira] [Closed] (DRILL-2390) regression: MergeJoinBatch size exceeds 64k limit

2015-04-24 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2390?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-2390. - Assignee: Chun Chang (was: Venki Korukanti) Added a test case for this bug. The test case still fails bec

[jira] [Closed] (DRILL-1637) Drill query execution fails with FragmentSetupException

2015-04-24 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1637?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish closed DRILL-1637. -- Issue was not specific to any particular query types. Closing. > Drill query execution fails with

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

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

[jira] [Updated] (DRILL-1791) CTAS fails due to issue with stale file handles

2015-04-24 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1791?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish updated DRILL-1791: --- Labels: hard_to_verify (was: ) > CTAS fails due to issue with stale file handles > --

[jira] [Updated] (DRILL-1793) Drill statements fail with CuratorConnectionLossException / FragmentSetupException

2015-04-24 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1793?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish updated DRILL-1793: --- Labels: hard_to_verify (was: ) > Drill statements fail with CuratorConnectionLossException /

[jira] [Closed] (DRILL-1797) Drillbit.sh fails to stop Drillbit processes

2015-04-24 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1797?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish closed DRILL-1797. -- Marked as invalid. Closing. > Drillbit.sh fails to stop Drillbit processes > -

[jira] [Commented] (DRILL-1975) Documentation on supported Data Types must be corrected

2015-04-24 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1975?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14511930#comment-14511930 ] Abhishek Girish commented on DRILL-1975: Documents have been reviewed. Closing.

[jira] [Closed] (DRILL-1975) Documentation on supported Data Types must be corrected

2015-04-24 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1975?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish closed DRILL-1975. -- > Documentation on supported Data Types must be corrected >

[jira] [Closed] (DRILL-1982) Querying a hive table with a 'limit' clause throws exceptions (intermittent)

2015-04-24 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1982?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish closed DRILL-1982. -- Was identified to be related to DRILL-1859. Closing. > Querying a hive table with a 'limit' clause

[jira] [Closed] (DRILL-2018) Error message must be updated when Drill fails to handle JSON files with mutating schemas within fields.

2015-04-24 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2018?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish closed DRILL-2018. -- Was resolved as duplicate. Closing. > Error message must be updated when Drill fails to handle JSO

[jira] [Commented] (DRILL-2103) Queries on views containing average on columns containing null values fail

2015-04-24 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2103?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14511926#comment-14511926 ] Abhishek Girish commented on DRILL-2103: Testcase: Functional/Passing/tpcds/bugs/D

[jira] [Closed] (DRILL-2138) Failure while querying MapR-DB Views/Tables

2015-04-24 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2138?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish closed DRILL-2138. -- > Failure while querying MapR-DB Views/Tables > --- > >

[jira] [Closed] (DRILL-2177) Select * with Order by 1 fails on Yelp JSON dataset

2015-04-24 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2177?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish closed DRILL-2177. -- Testcase: Functional/Passing/yelp_tutorial/DRILL-2177.sql > Select * with Order by 1 fails on Yelp

[jira] [Commented] (DRILL-2177) Select * with Order by 1 fails on Yelp JSON dataset

2015-04-24 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2177?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14511921#comment-14511921 ] Abhishek Girish commented on DRILL-2177: Verified on Git.Commit.ID a0a1930 (April

[jira] [Commented] (DRILL-2191) Aggregation on columns with case statements returns wrong results

2015-04-24 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2191?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14511919#comment-14511919 ] Abhishek Girish commented on DRILL-2191: Testcase: Functional/Passing/tpcds/bugs/D

[jira] [Closed] (DRILL-2191) Aggregation on columns with case statements returns wrong results

2015-04-24 Thread Abhishek Girish (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2191?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Abhishek Girish closed DRILL-2191. -- > Aggregation on columns with case statements returns wrong results > --

[jira] [Closed] (DRILL-1743) IndexOutOfBoundsException when reading the publicly available yelp jsongit.commit.id.abbrev=108d29f dataset

2015-04-24 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1743?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rahul Challapalli closed DRILL-1743. Verified that this issue is not happening. Also raised another issue related to this DRILL-2875

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

2015-04-24 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2875?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rahul Challapalli updated DRILL-2875: - Attachment: error.log The dataset is larger than 10MB. So I am not attaching it here. Reac

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

2015-04-24 Thread Rahul Challapalli (JIRA)
Rahul Challapalli created DRILL-2875: Summary: IllegalStateException when querying the public yelp json dataset Key: DRILL-2875 URL: https://issues.apache.org/jira/browse/DRILL-2875 Project: Apach

[jira] [Closed] (DRILL-1867) Case sensitivity of query identifiers is inconsistent

2015-04-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1867?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-1867. --- > Case sensitivity of query identifiers is inconsistent >

[jira] [Commented] (DRILL-1867) Case sensitivity of query identifiers is inconsistent

2015-04-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1867?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14511896#comment-14511896 ] Victoria Markman commented on DRILL-1867: - Verified fixed in 0.9.0: #Wed Apr 22 1

[jira] [Commented] (DRILL-2870) Fix return type of aggregate functions to be nullable

2015-04-24 Thread Mehant Baid (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2870?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14511891#comment-14511891 ] Mehant Baid commented on DRILL-2870: [~jnadeau] I can come up with a few alternatives

[jira] [Closed] (DRILL-1748) Using convert_from (JSON) on top of text files and selecting multiple columns results in a plan error

2015-04-24 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1748?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rahul Challapalli closed DRILL-1748. Verified and re-organized the below testcases Functional/Passing/json_kvgenflatten/convert/conv

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

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

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

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

[jira] [Updated] (DRILL-2787) NPE when first argument to maxdir UDF is invalid

2015-04-24 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2787?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2787: - Priority: Critical (was: Major) > NPE when first argument to maxdir UDF is invalid >

[jira] [Updated] (DRILL-2787) NPE when first argument to maxdir UDF is invalid

2015-04-24 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2787?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2787: - Fix Version/s: 1.0.0 > NPE when first argument to maxdir UDF is invalid >

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

2015-04-24 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra closed DRILL-2670. Resolution: Cannot Reproduce I don't see this issue occurring. Please reopen if you see this happeni

[jira] [Closed] (DRILL-2392) now() and localtimestamp not equal

2015-04-24 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2392?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-2392. - Assignee: Chun Chang (was: Mehant Baid) [root@qa-node120 resources]# cat Functional/Passing/datetime/date

[jira] [Closed] (DRILL-1759) Flatten : When the item to be flattened contains a repeated map, we are loosing some data

2015-04-24 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rahul Challapalli closed DRILL-1759. Verified and added the below testcase Functional/Passing/json_kvgenflatten/flatten/flattenbug_D

[jira] [Updated] (DRILL-2739) Drill stops reading columns > 4095

2015-04-24 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2739?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-2739: -- Attachment: manyColumns.csv Attached CSV file that has many columns, this file was used in my te

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

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

[jira] [Updated] (DRILL-2408) CTAS should not create empty folders when underlying query returns no results

2015-04-24 Thread Deneche A. Hakim (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2408?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Deneche A. Hakim updated DRILL-2408: Attachment: DRILL-2408.5.patch.txt running tests, will update once they are successful > CT

[jira] [Updated] (DRILL-2866) Incorrect error message reporting schema change when streaming aggregation and hash join are disabled

2015-04-24 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2866?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2866: - Component/s: (was: Execution - Data Types) Execution - Relational Operators >

[jira] [Updated] (DRILL-2530) getColumns() doesn't return right COLUMN_SIZE for INTERVAL types

2015-04-24 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2530?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2530: - Assignee: Daniel Barclay (Drill) > getColumns() doesn't return right COLUMN_SIZE for INTERVAL type

[jira] [Comment Edited] (DRILL-2354) Documentation for Concat Function & Concat Operator

2015-04-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14511830#comment-14511830 ] Victoria Markman edited comment on DRILL-2354 at 4/24/15 9:42 PM: --

[jira] [Commented] (DRILL-2354) Documentation for Concat Function & Concat Operator

2015-04-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14511830#comment-14511830 ] Victoria Markman commented on DRILL-2354: - I take it back, on closer examination o

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

2015-04-24 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2860?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2860: - Fix Version/s: 1.0.0 > Unable to cast integer column from parquet file to interval day > -

[jira] [Closed] (DRILL-2393) The extracted day from now() and current_date are not equal

2015-04-24 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2393?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-2393. - Assignee: Chun Chang (was: Mehant Baid) [root@qa-node120 resources]# cat Functional/Passing/datetime/date

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

2015-04-24 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2860?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2860: - Assignee: Mehant Baid (was: Daniel Barclay (Drill)) > Unable to cast integer column from parquet

[jira] [Assigned] (DRILL-2862) Convert_to/Convert_From throw assertion when an incorrect encoding type is specified

2015-04-24 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2862?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra reassigned DRILL-2862: Assignee: Parth Chandra (was: Daniel Barclay (Drill)) > Convert_to/Convert_From throw asse

[jira] [Updated] (DRILL-2862) Convert_to/Convert_From throw assertion when an incorrect encoding type is specified

2015-04-24 Thread Parth Chandra (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2862?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Parth Chandra updated DRILL-2862: - Fix Version/s: 1.1.0 > Convert_to/Convert_From throw assertion when an incorrect encoding type is

[jira] [Closed] (DRILL-2394) extracted hour from now() and current_time are not equal

2015-04-24 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2394?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-2394. - Assignee: Chun Chang (was: Mehant Baid) [root@qa-node120 resources]# cat Functional/Passing/datetime/date

[jira] [Closed] (DRILL-2399) extract hour from current_date gives non-zero value

2015-04-24 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2399?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-2399. - Assignee: Chun Chang (was: Mehant Baid) [root@qa-node120 resources]# cat Functional/Passing/datetime/date

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

2015-04-24 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2874: --- Summary: Concat operator is not supported with complex types, we should throw an error early Key: DRILL-2874 URL: https://issues.apache.org/jira/browse/DRILL-2874

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

2015-04-24 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2873?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14511791#comment-14511791 ] Khurram Faraaz commented on DRILL-2873: --- This issue is dependent/related to DRILL-27

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

2015-04-24 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-2873: - Summary: CTAS reports error when timestamp values in CSV file are quoted Key: DRILL-2873 URL: https://issues.apache.org/jira/browse/DRILL-2873 Project: Apache Drill

[jira] [Resolved] (DRILL-2354) Documentation for Concat Function & Concat Operator

2015-04-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2354?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-2354. - Resolution: Fixed > Documentation for Concat Function & Concat Operator > ---

[jira] [Reopened] (DRILL-2354) Documentation for Concat Function & Concat Operator

2015-04-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2354?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman reopened DRILL-2354: - > Documentation for Concat Function & Concat Operator > -

[jira] [Closed] (DRILL-2794) Partition pruning is not happening correctly (results in a full table scan) when maxdir/mindir is used in the filter condition

2015-04-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2794?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2794. --- > Partition pruning is not happening correctly (results in a full table scan) > when maxdir/mindi

[jira] [Resolved] (DRILL-1877) Throw unsupported error message for || operator early in the parsing stage

2015-04-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1877?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-1877. - Resolution: Fixed This feature was implemented. > Throw unsupported error message for ||

[jira] [Closed] (DRILL-1877) Throw unsupported error message for || operator early in the parsing stage

2015-04-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1877?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-1877. --- > Throw unsupported error message for || operator early in the parsing stage > ---

[jira] [Reopened] (DRILL-1877) Throw unsupported error message for || operator early in the parsing stage

2015-04-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1877?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman reopened DRILL-1877: - > Throw unsupported error message for || operator early in the parsing stage > ---

[jira] [Commented] (DRILL-2354) Documentation for Concat Function & Concat Operator

2015-04-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2354?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14511754#comment-14511754 ] Victoria Markman commented on DRILL-2354: - Verified in the new version of the docs

[jira] [Resolved] (DRILL-1877) Throw unsupported error message for || operator early in the parsing stage

2015-04-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1877?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-1877. - Resolution: Fixed Concat operator was implemented and drill-2354 is a reference to documen

[jira] [Closed] (DRILL-2354) Documentation for Concat Function & Concat Operator

2015-04-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2354?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2354. --- > Documentation for Concat Function & Concat Operator > -

[jira] [Reopened] (DRILL-1877) Throw unsupported error message for || operator early in the parsing stage

2015-04-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1877?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman reopened DRILL-1877: - > Throw unsupported error message for || operator early in the parsing stage > ---

[jira] [Commented] (DRILL-2581) count(*) on a single wide record file took too long

2015-04-24 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2581?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14511734#comment-14511734 ] Chun Chang commented on DRILL-2581: --- [root@qa-node120 resources]# cat Advanced/Passing/c

[jira] [Closed] (DRILL-2581) count(*) on a single wide record file took too long

2015-04-24 Thread Chun Chang (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2581?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Chun Chang closed DRILL-2581. - Assignee: Chun Chang (was: Hanifi Gunes) > count(*) on a single wide record file took too long >

[jira] [Updated] (DRILL-2870) Fix return type of aggregate functions to be nullable

2015-04-24 Thread Mehant Baid (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mehant Baid updated DRILL-2870: --- Assignee: Aman Sinha (was: Mehant Baid) > Fix return type of aggregate functions to be nullable > ---

[jira] [Reopened] (DRILL-1876) Implement concatenation operator ( || )

2015-04-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman reopened DRILL-1876: - > Implement concatenation operator ( || ) > --- > >

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

2015-04-24 Thread Mehant Baid (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2277?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mehant Baid updated DRILL-2277: --- Assignee: Steven Phillips (was: Mehant Baid) > COUNT(*) should return 0 instead of an empty result se

[jira] [Reopened] (DRILL-1876) Implement concatenation operator ( || )

2015-04-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman reopened DRILL-1876: - Assignee: (was: Bridget Bevens) > Implement concatenation operator ( || ) >

[jira] [Closed] (DRILL-1876) Implement concatenation operator ( || )

2015-04-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-1876. --- > Implement concatenation operator ( || ) > --- > >

[jira] [Resolved] (DRILL-1876) Implement concatenation operator ( || )

2015-04-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-1876. - Resolution: Fixed > Implement concatenation operator ( || ) >

[jira] [Updated] (DRILL-2870) Fix return type of aggregate functions to be nullable

2015-04-24 Thread Mehant Baid (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2870?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mehant Baid updated DRILL-2870: --- Attachment: DRILL-2870.patch [~amansinha100] can you please review > Fix return type of aggregate fun

[jira] [Resolved] (DRILL-1876) Implement concatenation operator ( || )

2015-04-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-1876. - Resolution: Fixed > Implement concatenation operator ( || ) >

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

2015-04-24 Thread Mehant Baid (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2277?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Mehant Baid updated DRILL-2277: --- Attachment: DRILL-2277.patch [~sphillips] can you please review > COUNT(*) should return 0 instead of

[jira] [Closed] (DRILL-779) Add support for pipes Concat "||" operator

2015-04-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-779. -- > Add support for pipes Concat "||" operator > -- > >

[jira] [Resolved] (DRILL-779) Add support for pipes Concat "||" operator

2015-04-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman resolved DRILL-779. Resolution: Fixed > Add support for pipes Concat "||" operator >

[jira] [Closed] (DRILL-2008) select a || b from ... fails while select cast(a as varchar) || cast(b as varchar) from ...

2015-04-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2008?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman closed DRILL-2008. --- Closing as a duplicate of drill-2054 > select a || b from ... fails while select cast(a as varcha

[jira] [Reopened] (DRILL-779) Add support for pipes Concat "||" operator

2015-04-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-779?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman reopened DRILL-779: > Add support for pipes Concat "||" operator > -- > >

[jira] [Updated] (DRILL-1876) Implement concatenation operator ( || )

2015-04-24 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1876?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-1876: Summary: Implement concatenation operator ( || ) (was: Remove || (concatenation operator) f

[jira] [Commented] (DRILL-1345) Drill can write to Amazon S3 storage buckets but not read from them

2015-04-24 Thread Krystal (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1345?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14511704#comment-14511704 ] Krystal commented on DRILL-1345: David - is this issue resolved? Can I close it? > Drill

[jira] [Commented] (DRILL-1771) Doing a flatten along with selecting a column from a subquery which does a flatten over kvgen results in a planning error

2015-04-24 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14511693#comment-14511693 ] Rahul Challapalli commented on DRILL-1771: -- Verified and added the below testcase

[jira] [Closed] (DRILL-1771) Doing a flatten along with selecting a column from a subquery which does a flatten over kvgen results in a planning error

2015-04-24 Thread Rahul Challapalli (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1771?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rahul Challapalli closed DRILL-1771. Assignee: Daniel Barclay (Drill) (was: Mehant Baid) > Doing a flatten along with selecting

[jira] [Closed] (DRILL-2871) Plan for TPC-H 20 changed with DRILL-1384 (or DRILL-2761) causing performance degradation

2015-04-24 Thread Kunal Khatua (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2871?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Kunal Khatua closed DRILL-2871. --- Resolution: Not A Problem > Plan for TPC-H 20 changed with DRILL-1384 (or DRILL-2761) causing performa

  1   2   >