[jira] [Commented] (DRILL-4798) TPCDS query 12 fails to plan

2016-11-23 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4798?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15689667#comment-15689667 ] Khurram Faraaz commented on DRILL-4798: --- TPCDS query 98 fails with same error message {noformat}

[jira] [Updated] (DRILL-5064) wrong results - equijoin involving interval day type columns

2016-11-22 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5064?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-5064: -- Description: The problem exists on Drill 1.9.0 git commit ID: 4312d65 (i.e difference in

[jira] [Updated] (DRILL-5064) wrong results - equijoin involving interval day type columns

2016-11-22 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5064?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-5064: -- Attachment: typeall_r.parquet typeall_l.parquet > wrong results - equijoin

[jira] [Commented] (DRILL-4938) need better error message

2016-11-18 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4938?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15677260#comment-15677260 ] Khurram Faraaz commented on DRILL-4938: --- [~adeneche] Can you please share your thoughts here, since

[jira] [Commented] (DRILL-5051) Returning incorrect number of rows while querying using both nested select and offset

2016-11-18 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5051?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15676527#comment-15676527 ] Khurram Faraaz commented on DRILL-5051: --- The problem is only when the OFFSET is specified in the

[jira] [Commented] (DRILL-4462) Slow JOIN Query On Remote MongoDB

2016-11-17 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4462?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15675862#comment-15675862 ] Khurram Faraaz commented on DRILL-4462: --- You can get source from here, do a git clone from

[jira] [Updated] (DRILL-5049) difference in results - correlated subquery interacting with null equality join

2016-11-17 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5049?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-5049: -- Priority: Critical (was: Major) > difference in results - correlated subquery interacting with

[jira] [Commented] (DRILL-5040) Interrupted CTAS should not succeed & should not create physical file on disk

2016-11-17 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5040?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15674180#comment-15674180 ] Khurram Faraaz commented on DRILL-5040: --- sure will do. > Interrupted CTAS should not succeed &

[jira] [Updated] (DRILL-5049) difference in results - correlated subquery interacting with null equality join

2016-11-17 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5049?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-5049: -- Attachment: nullEqJoin_17.postgres nullEqJoin_17.drill_res

[jira] [Created] (DRILL-5049) difference in results - correlated subquery interacting with null equality join

2016-11-17 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-5049: - Summary: difference in results - correlated subquery interacting with null equality join Key: DRILL-5049 URL: https://issues.apache.org/jira/browse/DRILL-5049

[jira] [Commented] (DRILL-4462) Slow JOIN Query On Remote MongoDB

2016-11-16 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4462?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15672748#comment-15672748 ] Khurram Faraaz commented on DRILL-4462: --- Can you please try to run your join query on latest Drill

[jira] [Commented] (DRILL-5042) Settings in drill-env.sh are not overriding the same settings in distrib-env.sh

2016-11-16 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5042?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15672740#comment-15672740 ] Khurram Faraaz commented on DRILL-5042: --- Do we need two files here ( drill-env.sh and distrib-env.sh

[jira] [Created] (DRILL-5040) Interrupted CTAS should not succeed & should not create physical file on disk

2016-11-14 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-5040: - Summary: Interrupted CTAS should not succeed & should not create physical file on disk Key: DRILL-5040 URL: https://issues.apache.org/jira/browse/DRILL-5040

[jira] [Updated] (DRILL-5039) NPE - CTAS PARTITION BY ()

2016-11-12 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5039?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-5039: -- Description: We are seeing an NPE, when CTAS is used with PARTITION BY () and all columns are

[jira] [Created] (DRILL-5039) NPE - CTAS PARTITION BY ()

2016-11-12 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-5039: - Summary: NPE - CTAS PARTITION BY () Key: DRILL-5039 URL: https://issues.apache.org/jira/browse/DRILL-5039 Project: Apache Drill Issue Type: Bug

[jira] [Reopened] (DRILL-4653) Malformed JSON should not stop the entire query from progressing

2016-11-11 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4653?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz reopened DRILL-4653: --- > Malformed JSON should not stop the entire query from progressing >

[jira] [Updated] (DRILL-5033) Query on JSON that has null as value for each key

2016-11-10 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5033?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-5033: -- Description: Drill 1.9.0 git commit ID : 83513daf Drill returns same result with or without

[jira] [Created] (DRILL-5033) Query on JSON that has null as value for each key

2016-11-10 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-5033: - Summary: Query on JSON that has null as value for each key Key: DRILL-5033 URL: https://issues.apache.org/jira/browse/DRILL-5033 Project: Apache Drill

[jira] [Created] (DRILL-5029) need better error - cast interval day to int or bigint

2016-11-10 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-5029: - Summary: need better error - cast interval day to int or bigint Key: DRILL-5029 URL: https://issues.apache.org/jira/browse/DRILL-5029 Project: Apache Drill

[jira] [Created] (DRILL-5024) CTAS with LIMIT 0 query in SELECT stmt does not create parquet file

2016-11-09 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-5024: - Summary: CTAS with LIMIT 0 query in SELECT stmt does not create parquet file Key: DRILL-5024 URL: https://issues.apache.org/jira/browse/DRILL-5024 Project: Apache

[jira] [Created] (DRILL-5010) Equality join condition is treated as a MergeJoin and not as a HashJoin.

2016-11-08 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-5010: - Summary: Equality join condition is treated as a MergeJoin and not as a HashJoin. Key: DRILL-5010 URL: https://issues.apache.org/jira/browse/DRILL-5010 Project:

[jira] [Created] (DRILL-5003) need a better error message

2016-11-04 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-5003: - Summary: need a better error message Key: DRILL-5003 URL: https://issues.apache.org/jira/browse/DRILL-5003 Project: Apache Drill Issue Type: Bug

[jira] [Commented] (DRILL-5001) Join only supports implicit casts error even when I have explicit cast

2016-11-04 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-5001?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15635768#comment-15635768 ] Khurram Faraaz commented on DRILL-5001: --- Not exactly similar issue, but DRILL-4985 and this one

[jira] [Commented] (DRILL-4653) Malformed JSON should not stop the entire query from progressing

2016-11-03 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4653?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15633817#comment-15633817 ] Khurram Faraaz commented on DRILL-4653: --- How about the other cases that FAIL even with

[jira] [Commented] (DRILL-4653) Malformed JSON should not stop the entire query from progressing

2016-11-02 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4653?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15630075#comment-15630075 ] Khurram Faraaz commented on DRILL-4653: --- I don't this this is fixed, there are still some cases that

[jira] [Commented] (DRILL-4653) Malformed JSON should not stop the entire query from progressing

2016-11-02 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4653?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15628664#comment-15628664 ] Khurram Faraaz commented on DRILL-4653: --- [~kkhatua] I tried these tests with malformed JSON, on

[jira] [Commented] (DRILL-4985) CAST in join predicate in null equality join - "query cannot be planned error"

2016-11-02 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4985?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15628282#comment-15628282 ] Khurram Faraaz commented on DRILL-4985: --- Use of any data type conversion function ( say to_date() )

[jira] [Commented] (DRILL-4944) incorrect results - case expression

2016-11-02 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4944?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15627904#comment-15627904 ] Khurram Faraaz commented on DRILL-4944: --- I understand that part. What is the plan to handle such

[jira] [Updated] (DRILL-4985) CAST in join predicate in null equality join - "query cannot be planned error"

2016-11-01 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4985?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-4985: -- Priority: Critical (was: Major) > CAST in join predicate in null equality join - "query cannot

[jira] [Updated] (DRILL-4985) CAST in join predicate in null equality join - "query cannot be planned error"

2016-11-01 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4985?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-4985: -- Description: Use of CAST in join predicate results in, "query cannot be planned error", in a

[jira] [Commented] (DRILL-4985) CAST in join predicate in null equality join - "query cannot be planned error"

2016-11-01 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4985?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15624610#comment-15624610 ] Khurram Faraaz commented on DRILL-4985: --- Parquet schema details for tables t1 and t2. {noformat}

[jira] [Created] (DRILL-4985) CAST in join predicate in null equality join - "query cannot be planned error"

2016-11-01 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4985: - Summary: CAST in join predicate in null equality join - "query cannot be planned error" Key: DRILL-4985 URL: https://issues.apache.org/jira/browse/DRILL-4985

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

2016-11-01 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3214?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15624513#comment-15624513 ] Khurram Faraaz commented on DRILL-3214: --- On Drill 1.9.0

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

2016-10-29 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: --- > Config option to cast empty string to null does not cast empty string to null >

[jira] [Created] (DRILL-4975) Null equality join over non existing columns returns nulls forever

2016-10-27 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4975: - Summary: Null equality join over non existing columns returns nulls forever Key: DRILL-4975 URL: https://issues.apache.org/jira/browse/DRILL-4975 Project: Apache

[jira] [Created] (DRILL-4966) null equality join results in UNSUPPORTED_OPERATION ERROR

2016-10-26 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4966: - Summary: null equality join results in UNSUPPORTED_OPERATION ERROR Key: DRILL-4966 URL: https://issues.apache.org/jira/browse/DRILL-4966 Project: Apache Drill

[jira] [Updated] (DRILL-4959) Drill 1.8 not able to connect to S3

2016-10-24 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4959?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-4959: -- Summary: Drill 1.8 not able to connect to S3 (was: Drill 8.1 not able to connect to S3) >

[jira] [Updated] (DRILL-4958) Union All query fails stating that parquet files are schema less

2016-10-24 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4958?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-4958: -- Summary: Union All query fails stating that parquet files are schema less (was: Union All

[jira] [Created] (DRILL-4958) Union All qiery fails stating that parquet files are schema less

2016-10-24 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4958: - Summary: Union All qiery fails stating that parquet files are schema less Key: DRILL-4958 URL: https://issues.apache.org/jira/browse/DRILL-4958 Project: Apache

[jira] [Updated] (DRILL-4952) AVG() returns SchemaChangeException

2016-10-19 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4952?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-4952: -- Attachment: durations.csv > AVG() returns SchemaChangeException >

[jira] [Created] (DRILL-4952) AVG() returns SchemaChangeException

2016-10-19 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4952: - Summary: AVG() returns SchemaChangeException Key: DRILL-4952 URL: https://issues.apache.org/jira/browse/DRILL-4952 Project: Apache Drill Issue Type: Bug

[jira] [Commented] (DRILL-3365) Query with window function on large dataset fails with "IOException: Mkdirs failed to create spill directory"

2016-10-17 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-3365?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15582914#comment-15582914 ] Khurram Faraaz commented on DRILL-3365: --- I too have hit this on Drill 1.8.0, removing /tmp/drill and

[jira] [Commented] (DRILL-4927) Add support for Null Equality Joins

2016-10-13 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4927?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15571641#comment-15571641 ] Khurram Faraaz commented on DRILL-4927: --- Thanks, saw that. I am working on the test plan. > Add

[jira] [Commented] (DRILL-4923) Use of CASE WHEN inside a sub-query results in AssertionError

2016-10-13 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4923?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15571436#comment-15571436 ] Khurram Faraaz commented on DRILL-4923: --- Another test also results in same AssertionError with same

[jira] [Created] (DRILL-4944) incorrect results - case expression

2016-10-13 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4944: - Summary: incorrect results - case expression Key: DRILL-4944 URL: https://issues.apache.org/jira/browse/DRILL-4944 Project: Apache Drill Issue Type: Bug

[jira] [Commented] (DRILL-4927) Add support for Null Equality Joins

2016-10-12 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4927?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15569693#comment-15569693 ] Khurram Faraaz commented on DRILL-4927: --- Is this committed to master ? > Add support for Null

[jira] [Created] (DRILL-4943) need better error message - DrillRuntimeException: Failure while materializing expression in constant expression evaluator

2016-10-12 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4943: - Summary: need better error message - DrillRuntimeException: Failure while materializing expression in constant expression evaluator Key: DRILL-4943 URL:

[jira] [Created] (DRILL-4942) incorrect result - case when (not null is null) then true else false end

2016-10-12 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4942: - Summary: incorrect result - case when (not null is null) then true else false end Key: DRILL-4942 URL: https://issues.apache.org/jira/browse/DRILL-4942 Project:

[jira] [Commented] (DRILL-4941) UnsupportedOperationException : CASE WHEN true or null then 1 else 0 end

2016-10-12 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4941?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15568458#comment-15568458 ] Khurram Faraaz commented on DRILL-4941: --- Calcite release 1.8.0 returns error for the second query

[jira] [Created] (DRILL-4941) UnsupportedOperationException : CASE WHEN true or null then 1 else 0 end

2016-10-12 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4941: - Summary: UnsupportedOperationException : CASE WHEN true or null then 1 else 0 end Key: DRILL-4941 URL: https://issues.apache.org/jira/browse/DRILL-4941 Project:

[jira] [Commented] (DRILL-4674) Allow casting to boolean the same strings as in Postgres

2016-10-12 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15568302#comment-15568302 ] Khurram Faraaz commented on DRILL-4674: --- I agree with Arina's suggestion. > Allow casting to

[jira] [Commented] (DRILL-4923) Use of CASE WHEN inside a sub-query results in AssertionError

2016-10-10 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4923?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15562644#comment-15562644 ] Khurram Faraaz commented on DRILL-4923: --- This is also seen on Drill 1.9.0 git commit id: 4edabe7a.

[jira] [Commented] (DRILL-4939) to_date function returns incorrect result

2016-10-10 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4939?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15562464#comment-15562464 ] Khurram Faraaz commented on DRILL-4939: --- Month part of '-MM-DD' is wrong in the results returned

[jira] [Created] (DRILL-4939) to_date function returns incorrect result

2016-10-10 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4939: - Summary: to_date function returns incorrect result Key: DRILL-4939 URL: https://issues.apache.org/jira/browse/DRILL-4939 Project: Apache Drill Issue Type:

[jira] [Created] (DRILL-4938) need better error message

2016-10-10 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4938: - Summary: need better error message Key: DRILL-4938 URL: https://issues.apache.org/jira/browse/DRILL-4938 Project: Apache Drill Issue Type: Bug

[jira] [Updated] (DRILL-4923) Use of CASE WHEN inside a sub-query results in AssertionError

2016-10-10 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4923?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-4923: -- Assignee: Serhii Harnyk > Use of CASE WHEN inside a sub-query results in AssertionError >

[jira] [Created] (DRILL-4937) AND of AND should fail

2016-10-10 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4937: - Summary: AND of AND should fail Key: DRILL-4937 URL: https://issues.apache.org/jira/browse/DRILL-4937 Project: Apache Drill Issue Type: Bug

[jira] [Created] (DRILL-4936) case expression when true then null, fails

2016-10-10 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4936: - Summary: case expression when true then null, fails Key: DRILL-4936 URL: https://issues.apache.org/jira/browse/DRILL-4936 Project: Apache Drill Issue

[jira] [Commented] (DRILL-4674) Can not cast 0 , 1 to boolean inside value constructor

2016-10-10 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4674?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15561593#comment-15561593 ] Khurram Faraaz commented on DRILL-4674: --- Consider the case expression {noformat} ::= ... ::=

[jira] [Commented] (DRILL-4933) Column aliasing isn’t working when we use partition by clause with row_number() [Ranking Window Functions]

2016-10-06 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4933?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15551389#comment-15551389 ] Khurram Faraaz commented on DRILL-4933: --- Apache Drill 1.9.0 is still not released. You can build

[jira] [Commented] (DRILL-4933) Column aliasing isn’t working when we use partition by clause with row_number() [Ranking Window Functions]

2016-10-06 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4933?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15551000#comment-15551000 ] Khurram Faraaz commented on DRILL-4933: --- Works just fine for me, I am on 1.9.0 rownum without back

[jira] [Updated] (DRILL-4932) Need to fix typos in Interval section of docs

2016-10-05 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4932?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-4932: -- Assignee: Bridget Bevens > Need to fix typos in Interval section of docs >

[jira] [Created] (DRILL-4932) Need to fix typos in Interval section of docs

2016-10-05 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4932: - Summary: Need to fix typos in Interval section of docs Key: DRILL-4932 URL: https://issues.apache.org/jira/browse/DRILL-4932 Project: Apache Drill Issue

[jira] [Commented] (DRILL-4927) Add support for Null Equality Joins

2016-10-04 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4927?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15545005#comment-15545005 ] Khurram Faraaz commented on DRILL-4927: --- Same as DRILL-4539 > Add support for Null Equality Joins >

[jira] [Commented] (DRILL-4924) Can not use case expression within an IN predicate.

2016-10-03 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15544262#comment-15544262 ] Khurram Faraaz commented on DRILL-4924: --- Should we reopen this JIRA ?, now that we know Calcite

[jira] [Commented] (DRILL-4924) Can not use case expression within an IN predicate.

2016-10-03 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15542907#comment-15542907 ] Khurram Faraaz commented on DRILL-4924: --- Another observation, when we do a select * from inside the

[jira] [Commented] (DRILL-4924) Can not use case expression within an IN predicate.

2016-10-03 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15542707#comment-15542707 ] Khurram Faraaz commented on DRILL-4924: --- Added a FROM clause inside the IN clause and we see this

[jira] [Commented] (DRILL-4924) Can not use case expression within an IN predicate.

2016-10-03 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4924?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15542685#comment-15542685 ] Khurram Faraaz commented on DRILL-4924: --- Ok we definitely need a better error message, the current

[jira] [Created] (DRILL-4924) Can not use case expression within an IN predicate.

2016-10-03 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4924: - Summary: Can not use case expression within an IN predicate. Key: DRILL-4924 URL: https://issues.apache.org/jira/browse/DRILL-4924 Project: Apache Drill

[jira] [Commented] (DRILL-1937) Throw exception and give error message when Non-scalar sub-query used in an expression

2016-10-03 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-1937?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15542088#comment-15542088 ] Khurram Faraaz commented on DRILL-1937: --- Verified on Drill 1.9.0 ( do we need the reference to JIRA

[jira] [Comment Edited] (DRILL-4923) Use of CASE WHEN inside a sub-query results in AssertionError

2016-10-03 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4923?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15542044#comment-15542044 ] Khurram Faraaz edited comment on DRILL-4923 at 10/3/16 10:19 AM: - data

[jira] [Comment Edited] (DRILL-4923) Use of CASE WHEN inside a sub-query results in AssertionError

2016-10-03 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4923?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15542044#comment-15542044 ] Khurram Faraaz edited comment on DRILL-4923 at 10/3/16 10:18 AM: - data

[jira] [Updated] (DRILL-4923) Use of CASE WHEN inside a sub-query results in AssertionError

2016-10-03 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4923?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-4923: -- Attachment: 0_0_0.parquet data file attached. > Use of CASE WHEN inside a sub-query results in

[jira] [Created] (DRILL-4923) Use of CASE WHEN inside a sub-query results in AssertionError

2016-10-03 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4923: - Summary: Use of CASE WHEN inside a sub-query results in AssertionError Key: DRILL-4923 URL: https://issues.apache.org/jira/browse/DRILL-4923 Project: Apache Drill

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

2016-10-03 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4918?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15541977#comment-15541977 ] Khurram Faraaz edited comment on DRILL-4918 at 10/3/16 9:30 AM: Postgres

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

2016-10-03 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4918?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15541977#comment-15541977 ] Khurram Faraaz commented on DRILL-4918: --- Postgres returns an error {nodormat} postgres=# select

[jira] [Created] (DRILL-4922) Difference in results returned by AGE function

2016-10-03 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4922: - Summary: Difference in results returned by AGE function Key: DRILL-4922 URL: https://issues.apache.org/jira/browse/DRILL-4922 Project: Apache Drill Issue

[jira] [Commented] (DRILL-4373) Drill and Hive have incompatible timestamp representations in parquet

2016-10-01 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4373?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15538934#comment-15538934 ] Khurram Faraaz commented on DRILL-4373: --- The description says Drill & Hive have incompatible

[jira] [Commented] (DRILL-2930) Need detail of Drillbit version in output of sys.drillbits

2016-10-01 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-2930?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15538844#comment-15538844 ] Khurram Faraaz commented on DRILL-2930: --- is related to DRILL-4596 > Need detail of Drillbit version

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

2016-09-30 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4877?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15535287#comment-15535287 ] Khurram Faraaz commented on DRILL-4877: --- Test was run on Drill 1.9.0 git commit ID: f3c26e34 on 4

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

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

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

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

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

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

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

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

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

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

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

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

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

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

[jira] [Commented] (DRILL-4910) Apache Drill 1.8 UI doesn't display Hive join query results

2016-09-28 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4910?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15530260#comment-15530260 ] Khurram Faraaz commented on DRILL-4910: --- How much data (number of rows) do you have in your join

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

2016-09-28 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4203?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15529625#comment-15529625 ] Khurram Faraaz commented on DRILL-4203: --- Will this change (parquet header is updated with a new

[jira] [Closed] (DRILL-4387) Improve execution side when it handles skipAll query

2016-09-28 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4387?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz closed DRILL-4387. - Verified and test is added performance tests. > Improve execution side when it handles skipAll query

[jira] [Commented] (DRILL-4387) Improve execution side when it handles skipAll query

2016-09-28 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4387?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15529561#comment-15529561 ] Khurram Faraaz commented on DRILL-4387: --- I will track the wrong results issue separately. As for

[jira] [Created] (DRILL-4902) nested aggregate query does not complain about missing GROUP BY clause

2016-09-23 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4902: - Summary: nested aggregate query does not complain about missing GROUP BY clause Key: DRILL-4902 URL: https://issues.apache.org/jira/browse/DRILL-4902 Project:

[jira] [Created] (DRILL-4901) Make '\r\n' the default end of line

2016-09-22 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4901: - Summary: Make '\r\n' the default end of line Key: DRILL-4901 URL: https://issues.apache.org/jira/browse/DRILL-4901 Project: Apache Drill Issue Type: Bug

[jira] [Closed] (DRILL-4898) wrong results : Query on directory containing CSV data

2016-09-22 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz closed DRILL-4898. - Resolution: Not A Problem > wrong results : Query on directory containing CSV data >

[jira] [Commented] (DRILL-4898) wrong results : Query on directory containing CSV data

2016-09-22 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4898?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15514112#comment-15514112 ] Khurram Faraaz commented on DRILL-4898: --- Adding "lineDelimiter": "\r\n" to storage plugin resolves

[jira] [Commented] (DRILL-4900) Query across Sybase and Oracle plugins is dropping WHERE clause

2016-09-22 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4900?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15513005#comment-15513005 ] Khurram Faraaz commented on DRILL-4900: --- Tried a similar query on views created over Parquet data on

[jira] [Updated] (DRILL-4898) wrong results : Query on directory containing CSV data

2016-09-21 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4898?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Khurram Faraaz updated DRILL-4898: -- Description: incorrect results : Query on directory containing CSV data directory has 4534327

[jira] [Created] (DRILL-4898) wrong results : Query on directory containing CSV data

2016-09-21 Thread Khurram Faraaz (JIRA)
Khurram Faraaz created DRILL-4898: - Summary: wrong results : Query on directory containing CSV data Key: DRILL-4898 URL: https://issues.apache.org/jira/browse/DRILL-4898 Project: Apache Drill

[jira] [Commented] (DRILL-4678) Query HANG - SELECT DISTINCT over date data

2016-09-19 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15502994#comment-15502994 ] Khurram Faraaz commented on DRILL-4678: --- Also verified that query hangs on Apache Drill 1.9.0 commit

[jira] [Commented] (DRILL-4678) Query HANG - SELECT DISTINCT over date data

2016-09-19 Thread Khurram Faraaz (JIRA)
[ https://issues.apache.org/jira/browse/DRILL-4678?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15502481#comment-15502481 ] Khurram Faraaz commented on DRILL-4678: --- Executed the query SELECT DISTINCT... on Apache Calcite

<    1   2   3   4   5   6   7   8   9   10   >