[jira] [Created] (DRILL-1867) Case sensitivity of query identifiers is inconstistent

2014-12-15 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-1867: --- Summary: Case sensitivity of query identifiers is inconstistent Key: DRILL-1867 URL: https://issues.apache.org/jira/browse/DRILL-1867 Project: Apache Drill

[jira] [Created] (DRILL-1868) Filtering on an alias should return an error, user gets wrong result instead

2014-12-15 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-1868: --- Summary: Filtering on an alias should return an error, user gets wrong result instead Key: DRILL-1868 URL: https://issues.apache.org/jira/browse/DRILL-1868

[jira] [Created] (DRILL-1876) Remove || (concatenation operator) from documentation

2014-12-16 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-1876: --- Summary: Remove || (concatenation operator) from documentation Key: DRILL-1876 URL: https://issues.apache.org/jira/browse/DRILL-1876 Project: Apache Drill

[jira] [Created] (DRILL-1888) Memory leak during execution

2014-12-18 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-1888: --- Summary: Memory leak during execution Key: DRILL-1888 URL: https://issues.apache.org/jira/browse/DRILL-1888 Project: Apache Drill Issue Type: Bug

[jira] [Updated] (DRILL-1888) Memory leak during execution

2014-12-18 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1888?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-1888: Description: Use TPC-DS scema and run query below: {code} SELECT

[jira] [Updated] (DRILL-1891) Error message does not get propagated correctly when reading from JSON file

2014-12-18 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1891?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-1891: Description: I made a mistake in t.json file (extra colon in the last row): {code} { a1: 0

[jira] [Created] (DRILL-1910) ROW_NUMBER() window function throws exception during execution

2014-12-30 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-1910: --- Summary: ROW_NUMBER() window function throws exception during execution Key: DRILL-1910 URL: https://issues.apache.org/jira/browse/DRILL-1910 Project: Apache

[jira] [Created] (DRILL-1921) Throw unsupported error message some set operators that are not currently supported

2015-01-02 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-1921: --- Summary: Throw unsupported error message some set operators that are not currently supported Key: DRILL-1921 URL: https://issues.apache.org/jira/browse/DRILL-1921

[jira] [Updated] (DRILL-1923) Unexpected exception when one column of a leg of a UNION ALL is a numeric constant

2015-01-02 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1923?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-1923: Description: t.json: {code} {a1: 0, b1: 0, c1: true } {a1: 0, b1: 0, c1: false } {a1: 0,

[jira] [Updated] (DRILL-2069) Star is not expanded correctly in the query with IN clause containing subquery

2015-01-26 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2069?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2069: Description: t1.json {code} { a1: aa, b1: 1 } { a1: bb, b1: 2 } { a1: cc, b1: 3 } {code}

[jira] [Created] (DRILL-2069) Star is not expanded correctly in the query with IN clause containing subquery

2015-01-26 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2069: --- Summary: Star is not expanded correctly in the query with IN clause containing subquery Key: DRILL-2069 URL: https://issues.apache.org/jira/browse/DRILL-2069

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

2015-02-04 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14306722#comment-14306722 ] Victoria Markman commented on DRILL-2015: - Example with the simple function:

[jira] [Commented] (DRILL-2168) Wrong result on grouping by expression involving CONCAT function

2015-02-04 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2168?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14306338#comment-14306338 ] Victoria Markman commented on DRILL-2168: - {code} 0: jdbc:drill:schema=dfs select

[jira] [Updated] (DRILL-2168) Wrong result on grouping by expression involving CONCAT function

2015-02-04 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2168?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2168: Attachment: 0_0_0.parquet test table that is used in the query. Wrong result on grouping

[jira] [Commented] (DRILL-2101) Incorrect data type is written to parquet file when NULL is cast to decimal

2015-02-02 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2101?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14302567#comment-14302567 ] Victoria Markman commented on DRILL-2101: - Changed priority to Blocker - need to

[jira] [Updated] (DRILL-2101) Incorrect data type is written to parquet file when NULL is cast to decimal

2015-02-02 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2101: Priority: Blocker (was: Critical) Incorrect data type is written to parquet file when

[jira] [Updated] (DRILL-2148) Wrong result with grouping on a column of date type with streaming aggregation

2015-02-02 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2148?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2148: Attachment: 0_0_0.parquet Wrong result with grouping on a column of date type with

[jira] [Updated] (DRILL-2148) Wrong result with grouping on a column of date type with streaming aggregation

2015-02-02 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2148?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2148: Attachment: t1.out Wrong result with grouping on a column of date type with streaming

[jira] [Updated] (DRILL-2148) Wrong result with grouping on a column of date type with streaming aggregation

2015-02-02 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2148?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2148: Attachment: t1.res Wrong result with grouping on a column of date type with streaming

[jira] [Created] (DRILL-2148) Wrong result with grouping on a column of date type with streaming aggregation

2015-02-02 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2148: --- Summary: Wrong result with grouping on a column of date type with streaming aggregation Key: DRILL-2148 URL: https://issues.apache.org/jira/browse/DRILL-2148

[jira] [Updated] (DRILL-1921) Throw unsupported error message some set operators that are not currently supported

2015-02-06 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1921?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-1921: Description: Throw unsupported error message for these operators: (instead of Could not be

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

2015-02-02 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2139: --- Summary: Star is not expanded correctly in select distinct query Key: DRILL-2139 URL: https://issues.apache.org/jira/browse/DRILL-2139 Project: Apache Drill

[jira] [Commented] (DRILL-1888) Memory leak for aggregation with HAVING clause

2015-02-02 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1888?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14301681#comment-14301681 ] Victoria Markman commented on DRILL-1888: - Test was enabled in the automation

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

2015-01-15 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2015: --- Summary: Casting numeric value that does not fit in integer data type produces incorrect result Key: DRILL-2015 URL: https://issues.apache.org/jira/browse/DRILL-2015

[jira] [Created] (DRILL-2016) Remove multiset data type from supported grammar

2015-01-15 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2016: --- Summary: Remove multiset data type from supported grammar Key: DRILL-2016 URL: https://issues.apache.org/jira/browse/DRILL-2016 Project: Apache Drill

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

2015-01-15 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2015?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14279201#comment-14279201 ] Victoria Markman commented on DRILL-2015: - The default should be to throw an

[jira] [Commented] (DRILL-1973) Tableau query causes parsing error

2015-01-16 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14280574#comment-14280574 ] Victoria Markman commented on DRILL-1973: - Problem can be reproduced with the TPCH

[jira] [Created] (DRILL-2041) Throw unsupported error message on GROUP BY/ORDER BY array/map types

2015-01-19 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2041: --- Summary: Throw unsupported error message on GROUP BY/ORDER BY array/map types Key: DRILL-2041 URL: https://issues.apache.org/jira/browse/DRILL-2041 Project:

[jira] [Updated] (DRILL-2045) NPE when querying INFORMATION_SCHEMA table

2015-01-21 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2045?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2045: Summary: NPE when querying INFORMATION_SCHEMA table (was: NPE when querying

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

2015-01-21 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2051?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2051: Attachment: drill-2051.log NPE when querying view with where clause and derived table

[jira] [Created] (DRILL-2053) Column names are case sensitive if column is coming from WITH clause

2015-01-21 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2053: --- Summary: Column names are case sensitive if column is coming from WITH clause Key: DRILL-2053 URL: https://issues.apache.org/jira/browse/DRILL-2053 Project:

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

2015-01-19 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1867?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-1867: Description: git.commit.id.abbrev=c65928f In this query it looks like identifies are case

[jira] [Updated] (DRILL-2036) select * query returns wrong result when column name in json file changes case

2015-01-19 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2036?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2036: Description: {code} #Sun Jan 18 21:24:57 EST 2015 git.commit.id.abbrev=a418af1 {code}

[jira] [Created] (DRILL-2036) select * query returns wrong result when column name in json file changes case

2015-01-19 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2036: --- Summary: select * query returns wrong result when column name in json file changes case Key: DRILL-2036 URL: https://issues.apache.org/jira/browse/DRILL-2036

[jira] [Created] (DRILL-2045) NPE when querying INFORMATION_SCHEMA table after drill upgrade

2015-01-20 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2045: --- Summary: NPE when querying INFORMATION_SCHEMA table after drill upgrade Key: DRILL-2045 URL: https://issues.apache.org/jira/browse/DRILL-2045 Project: Apache

[jira] [Updated] (DRILL-2045) NPE when querying INFORMATION_SCHEMA table after drill upgrade

2015-01-20 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2045?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2045: Attachment: drill-2045.log NPE when querying INFORMATION_SCHEMA table after drill upgrade

[jira] [Created] (DRILL-2215) COALESCE function needs to be documented

2015-02-11 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2215: --- Summary: COALESCE function needs to be documented Key: DRILL-2215 URL: https://issues.apache.org/jira/browse/DRILL-2215 Project: Apache Drill Issue

[jira] [Updated] (DRILL-2212) NULLIF function should be documented

2015-02-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2212: Affects Version/s: 0.8.0 NULLIF function should be documented

[jira] [Created] (DRILL-2214) Aggregate function documentation needs to be corrected

2015-02-11 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2214: --- Summary: Aggregate function documentation needs to be corrected Key: DRILL-2214 URL: https://issues.apache.org/jira/browse/DRILL-2214 Project: Apache Drill

[jira] [Commented] (DRILL-2165) Assert when grouping on expression with extract and concat functions

2015-02-11 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2165?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14317057#comment-14317057 ] Victoria Markman commented on DRILL-2165: - Sean, Query still fails for me:

[jira] [Updated] (DRILL-2233) IOB exception when scalar subquery is used in the IN clause

2015-02-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2233?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2233: Attachment: t1.parquet IOB exception when scalar subquery is used in the IN clause

[jira] [Created] (DRILL-2235) Assert when NOT IN clause contains multiple columns

2015-02-12 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2235: --- Summary: Assert when NOT IN clause contains multiple columns Key: DRILL-2235 URL: https://issues.apache.org/jira/browse/DRILL-2235 Project: Apache Drill

[jira] [Updated] (DRILL-2233) IOB exception when scalar subquery is used in the IN clause

2015-02-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2233?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2233: Attachment: t2.parquet IOB exception when scalar subquery is used in the IN clause

[jira] [Created] (DRILL-2233) IOB exception when scalar subquery is used in the IN clause

2015-02-12 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2233: --- Summary: IOB exception when scalar subquery is used in the IN clause Key: DRILL-2233 URL: https://issues.apache.org/jira/browse/DRILL-2233 Project: Apache

[jira] [Updated] (DRILL-2233) IOB exception when scalar subquery is used in the IN clause

2015-02-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2233?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2233: Description: Failing query: {code} SELECT a1, COUNT(*) FROM t1 WHERE ( a1 ) IN

[jira] [Updated] (DRILL-2233) IOB exception when scalar subquery is used in the IN clause

2015-02-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2233?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2233: Attachment: drillbit.log IOB exception when scalar subquery is used in the IN clause

[jira] [Reopened] (DRILL-1499) Different column order could appear in the result set for a schema-less select * query, even there are no changing schemas.

2015-02-17 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1499?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman reopened DRILL-1499: - Assignee: Steven Phillips (was: Jinfeng Ni) Steven, assigning to you on Jinfeng's

[jira] [Updated] (DRILL-2084) Order by on date, time, timestamp and boolean columns produces wrong results if column contains null values

2015-01-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2084?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2084: Attachment: t1.csv Order by on date, time, timestamp and boolean columns produces wrong

[jira] [Created] (DRILL-2084) Order by on date, time, timestamp and boolean columns produces wrong results if column contains null values

2015-01-27 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2084: --- Summary: Order by on date, time, timestamp and boolean columns produces wrong results if column contains null values Key: DRILL-2084 URL:

[jira] [Updated] (DRILL-2084) Order by on date, time, timestamp and boolean columns produces wrong results if column contains null values

2015-01-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2084?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2084: Attachment: (was: count_distinct_with_goup_by_c_boolean.sql) Order by on date, time,

[jira] [Updated] (DRILL-2084) Order by on date, time, timestamp and boolean columns produces wrong results if column contains null values

2015-01-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2084?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2084: Attachment: 0_0_0.parquet Order by on date, time, timestamp and boolean columns produces

[jira] [Updated] (DRILL-2084) Order by on date, time, timestamp and boolean columns produces wrong results if column contains null values

2015-01-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2084?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2084: Attachment: (was: count_distinct_with_goup_by_c_date.sql) Order by on date, time,

[jira] [Updated] (DRILL-2084) Order by on date, time, timestamp and boolean columns produces wrong results if column contains null values

2015-01-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2084?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2084: Attachment: count_distinct_with_goup_by_c_date.sql Order by on date, time, timestamp and

[jira] [Updated] (DRILL-2084) Order by on date, time, timestamp and boolean columns produces wrong results if column contains null values

2015-01-27 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2084?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2084: Attachment: timestamp.out time.out date.out

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

2015-01-28 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1975?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14296067#comment-14296067 ] Victoria Markman commented on DRILL-1975: - Kristine, We don't support TINYINT.

[jira] [Commented] (DRILL-2110) all_text_mode for json works only with alter system not with alter session

2015-01-29 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2110?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14297142#comment-14297142 ] Victoria Markman commented on DRILL-2110: - This is duplicate of DRILL-1953

[jira] [Assigned] (DRILL-2101) Incorrect data type is written to parquet file when NULL is cast to decimal

2015-01-29 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2101?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman reassigned DRILL-2101: --- Assignee: Mehant Baid Incorrect data type is written to parquet file when NULL is

[jira] [Created] (DRILL-2131) Selecting boolean column through Web UI throws an error

2015-01-30 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2131: --- Summary: Selecting boolean column through Web UI throws an error Key: DRILL-2131 URL: https://issues.apache.org/jira/browse/DRILL-2131 Project: Apache Drill

[jira] [Updated] (DRILL-2131) Selecting boolean column through Web UI throws an error

2015-01-30 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2131?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2131: Attachment: 0_0_0.parquet Selecting boolean column through Web UI throws an error

[jira] [Created] (DRILL-2092) Incorrect result with count distinct and sum aggregates

2015-01-28 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2092: --- Summary: Incorrect result with count distinct and sum aggregates Key: DRILL-2092 URL: https://issues.apache.org/jira/browse/DRILL-2092 Project: Apache Drill

[jira] [Created] (DRILL-2093) Columns of time and timestamp data type are not stored correctly in json format on CTAS

2015-01-28 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2093: --- Summary: Columns of time and timestamp data type are not stored correctly in json format on CTAS Key: DRILL-2093 URL: https://issues.apache.org/jira/browse/DRILL-2093

[jira] [Created] (DRILL-1934) Failure to plan queries containing subqueries without correlation

2015-01-05 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-1934: --- Summary: Failure to plan queries containing subqueries without correlation Key: DRILL-1934 URL: https://issues.apache.org/jira/browse/DRILL-1934 Project:

[jira] [Updated] (DRILL-1986) Natural join query returns wrong result

2015-01-12 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1986?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-1986: Description: Natural join returns wrong result: {code} 0: jdbc:drill:schema=dfs select *

[jira] [Created] (DRILL-1974) Have an option to provide a custom query plan for a particular SQL query

2015-01-09 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-1974: --- Summary: Have an option to provide a custom query plan for a particular SQL query Key: DRILL-1974 URL: https://issues.apache.org/jira/browse/DRILL-1974

[jira] [Commented] (DRILL-1973) Tableau query causes parsing error

2015-01-09 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1973?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14271948#comment-14271948 ] Victoria Markman commented on DRILL-1973: - Chris, Could you please: 1) send us

[jira] [Created] (DRILL-1937) Disable internal function SINGLE_VALUE()

2015-01-06 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-1937: --- Summary: Disable internal function SINGLE_VALUE() Key: DRILL-1937 URL: https://issues.apache.org/jira/browse/DRILL-1937 Project: Apache Drill Issue

[jira] [Updated] (DRILL-1936) Throw an error if subquery in the where clause does not return scalar result

2015-01-06 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1936?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-1936: Component/s: Query Planning Optimization Description: {code} #Fri Jan 02 21:20:47 EST

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

2015-01-13 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-1998: --- Summary: Confusing error message when you pass character data type to SUM aggregate function Key: DRILL-1998 URL: https://issues.apache.org/jira/browse/DRILL-1998

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

2015-01-13 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1998?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-1998: Description: t.json {code} { a2: 1, b2: 1,c2: 1, d2: aaa, e1: 2015-01-01} {

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

2015-01-13 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2008?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14276284#comment-14276284 ] Victoria Markman commented on DRILL-2008: - Just for the reference: DRILL-779 - is

[jira] [Created] (DRILL-2190) Failure to order by function if DISTINCT clause is present

2015-02-09 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2190: --- Summary: Failure to order by function if DISTINCT clause is present Key: DRILL-2190 URL: https://issues.apache.org/jira/browse/DRILL-2190 Project: Apache Drill

[jira] [Created] (DRILL-2196) Assert when table.star notation is used in union all query

2015-02-09 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2196: --- Summary: Assert when table.star notation is used in union all query Key: DRILL-2196 URL: https://issues.apache.org/jira/browse/DRILL-2196 Project: Apache Drill

[jira] [Updated] (DRILL-2196) Assert when table.star notation is used in union all query

2015-02-09 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2196?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2196: Attachment: t1.csv Assert when table.star notation is used in union all query

[jira] [Updated] (DRILL-2196) Assert when table.star notation is used in union all query

2015-02-09 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2196?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2196: Attachment: t2.csv Assert when table.star notation is used in union all query

[jira] [Updated] (DRILL-2196) Assert when table.star notation is used in union all query

2015-02-09 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2196?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2196: Attachment: t3.csv Assert when table.star notation is used in union all query

[jira] [Updated] (DRILL-2202) Star is no expanded correctly during group by over named subquery

2015-02-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2202?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2202: Attachment: drillbit.log Star is no expanded correctly during group by over named subquery

[jira] [Created] (DRILL-2202) Star is no expanded correctly during group by over named subquery

2015-02-10 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2202: --- Summary: Star is no expanded correctly during group by over named subquery Key: DRILL-2202 URL: https://issues.apache.org/jira/browse/DRILL-2202 Project:

[jira] [Updated] (DRILL-2203) DISTINCT over UNION ALL subquery with fully qualified column names returns wrong result

2015-02-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2203?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2203: Attachment: t1.parquet DISTINCT over UNION ALL subquery with fully qualified column names

[jira] [Updated] (DRILL-2203) DISTINCT over UNION ALL subquery with fully qualified column names returns wrong result

2015-02-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2203?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2203: Attachment: t2.parquet DISTINCT over UNION ALL subquery with fully qualified column names

[jira] [Updated] (DRILL-2203) DISTINCT over UNION ALL subquery with fully qualified column names returns wrong result

2015-02-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2203?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2203: Attachment: t4.parquet DISTINCT over UNION ALL subquery with fully qualified column names

[jira] [Updated] (DRILL-2203) DISTINCT over UNION ALL subquery with fully qualified column names returns wrong result

2015-02-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2203?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2203: Attachment: t3.parquet DISTINCT over UNION ALL subquery with fully qualified column names

[jira] [Updated] (DRILL-2247) SUM with CASE statement on the column of the null producing side of left outer join returns wrong result

2015-02-13 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2247?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2247: Priority: Major (was: Critical) SUM with CASE statement on the column of the null

[jira] [Created] (DRILL-2243) Table created as cast of literal to any decimal type either can not be read back or produces incrorrect result

2015-02-13 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2243: --- Summary: Table created as cast of literal to any decimal type either can not be read back or produces incrorrect result Key: DRILL-2243 URL:

[jira] [Commented] (DRILL-1978) Using order by with a cast function and array index fails to plan.

2015-02-13 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1978?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14320748#comment-14320748 ] Victoria Markman commented on DRILL-1978: - One more case: {code} 0:

[jira] [Created] (DRILL-2244) Implicit cast between decimal data types is not implemented

2015-02-13 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2244: --- Summary: Implicit cast between decimal data types is not implemented Key: DRILL-2244 URL: https://issues.apache.org/jira/browse/DRILL-2244 Project: Apache

[jira] [Created] (DRILL-2248) Create script that collects information on drill configuration and logs

2015-02-13 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2248: --- Summary: Create script that collects information on drill configuration and logs Key: DRILL-2248 URL: https://issues.apache.org/jira/browse/DRILL-2248 Project:

[jira] [Created] (DRILL-2204) DISTINCT statement over UNION ALL subquery asserts during execution with streaming aggregation

2015-02-10 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2204: --- Summary: DISTINCT statement over UNION ALL subquery asserts during execution with streaming aggregation Key: DRILL-2204 URL:

[jira] [Updated] (DRILL-2204) DISTINCT statement over UNION ALL subquery asserts during execution with streaming aggregation

2015-02-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2204: Component/s: (was: Execution - Data Types) Execution - Flow DISTINCT

[jira] [Updated] (DRILL-2204) DISTINCT statement over UNION ALL subquery asserts during execution with streaming aggregation

2015-02-10 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2204?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2204: Description: {code} 0: jdbc:drill:schema=dfs select distinct sq.x1, sq.x2, sq.x3 from (

[jira] [Commented] (DRILL-1951) Can't cast numeric value with decimal point read from CSV file into integer data type

2015-01-07 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1951?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14268027#comment-14268027 ] Victoria Markman commented on DRILL-1951: - It does work indeed: {code} 0:

[jira] [Updated] (DRILL-1934) Failure to plan queries containing scalar subqueries without correlation

2015-01-06 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-1934: Description: {code} #Fri Jan 02 21:20:47 EST 2015 git.commit.id.abbrev=b491cdb {code} --

[jira] [Updated] (DRILL-2342) Nullability property of the view created from parquet file is not correct

2015-03-17 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2342?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2342: Attachment: t1.parquet Table 't1' parquet file that was used in the query Nullability

[jira] [Commented] (DRILL-2483) Make buffer that rows are read into during execution configurable for testing purposes

2015-03-17 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2483?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14366224#comment-14366224 ] Victoria Markman commented on DRILL-2483: - Hakim (thank you) pointed me to a

[jira] [Updated] (DRILL-2488) Wrong result on join between two subqueries with aggregation

2015-03-17 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2488?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2488: Attachment: t1.parquet Wrong result on join between two subqueries with aggregation

[jira] [Commented] (DRILL-2488) Wrong result on join between two subqueries with aggregation

2015-03-17 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2488?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanelfocusedCommentId=14366331#comment-14366331 ] Victoria Markman commented on DRILL-2488: - {code} #Fri Mar 13 17:54:51 EDT 2015

[jira] [Created] (DRILL-2488) Wrong result on join between two subqueries with aggregation

2015-03-17 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2488: --- Summary: Wrong result on join between two subqueries with aggregation Key: DRILL-2488 URL: https://issues.apache.org/jira/browse/DRILL-2488 Project: Apache

[jira] [Updated] (DRILL-2488) Wrong result on join between two subqueries with aggregation

2015-03-17 Thread Victoria Markman (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2488?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Victoria Markman updated DRILL-2488: Description: {code} 0: jdbc:drill:schema=dfs select * from t1;

[jira] [Created] (DRILL-2483) Make buffer that rows are read into during execution configurable for testing purposes

2015-03-17 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2483: --- Summary: Make buffer that rows are read into during execution configurable for testing purposes Key: DRILL-2483 URL: https://issues.apache.org/jira/browse/DRILL-2483

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

2015-03-17 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2484: --- Summary: Document CASE expression Key: DRILL-2484 URL: https://issues.apache.org/jira/browse/DRILL-2484 Project: Apache Drill Issue Type: Bug

[jira] [Created] (DRILL-2516) CTAS fails with NPE when select statement contains join and columns are not specified explicitly

2015-03-20 Thread Victoria Markman (JIRA)
Victoria Markman created DRILL-2516: --- Summary: CTAS fails with NPE when select statement contains join and columns are not specified explicitly Key: DRILL-2516 URL:

  1   2   3   4   5   6   7   8   9   10   >