[jira] [Closed] (SPARK-13820) TPC-DS Query 10 fails to compile

2016-05-25 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-13820?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Roy Cecil closed SPARK-13820. - Resolution: Fixed Fix Version/s: 2.0.0 The issue is fixed in 2.0 > TPC-DS Query 10 fails to

[jira] [Closed] (SPARK-14203) TPC-DS Query 86 - When there is a rollup , the parser keels over on grouping_id() on a single column

2016-05-25 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-14203?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Roy Cecil closed SPARK-14203. - Works good in spark 2.0 > TPC-DS Query 86 - When there is a rollup , the parser keels over on >

[jira] [Closed] (SPARK-14292) TPC-DS Query 23 Fails with compile error

2016-05-25 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-14292?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Roy Cecil closed SPARK-14292. - Resolution: Fixed Fix Version/s: 2.0.0 Issue is fixed in 2.0 > TPC-DS Query 23 Fails with

[jira] [Closed] (SPARK-13831) TPC-DS Query 35 fails with the following compile error

2016-05-25 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-13831?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Roy Cecil closed SPARK-13831. - confirmed that the query works in 2.0 > TPC-DS Query 35 fails with the following compile error >

[jira] [Commented] (SPARK-14785) Support correlated scalar subquery

2016-04-27 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-14785?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15259941#comment-15259941 ] Roy Cecil commented on SPARK-14785: --- Q32 falls in this category. TPC query rewrite rules do not allow

[jira] [Comment Edited] (SPARK-14785) Support correlated scalar subquery

2016-04-27 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-14785?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15259941#comment-15259941 ] Roy Cecil edited comment on SPARK-14785 at 4/27/16 10:29 AM: - Q32 falls in

[jira] [Commented] (SPARK-14781) Support subquery in nested predicates

2016-04-27 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-14781?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15259909#comment-15259909 ] Roy Cecil commented on SPARK-14781: --- This affects Q10, Q35 and Q45. If this is fixed we can then run 96

[jira] [Commented] (SPARK-13831) TPC-DS Query 35 fails with the following compile error

2016-04-23 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-13831?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15255426#comment-15255426 ] Roy Cecil commented on SPARK-13831: --- @Herman, thanks. I am validating the fix. > TPC-DS Query 35 fails

[jira] [Created] (SPARK-14292) TPC-DS Query 23 Fails with compile error

2016-03-31 Thread Roy Cecil (JIRA)
Roy Cecil created SPARK-14292: - Summary: TPC-DS Query 23 Fails with compile error Key: SPARK-14292 URL: https://issues.apache.org/jira/browse/SPARK-14292 Project: Spark Issue Type: Bug

[jira] [Commented] (SPARK-14203) TPC-DS Query 86 - When there is a rollup , the parser keels over on grouping_id() on a single column

2016-03-30 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-14203?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15217979#comment-15217979 ] Roy Cecil commented on SPARK-14203: --- Closing this as grouping((i_category) + grouping(i_class) ...

[jira] [Resolved] (SPARK-14203) TPC-DS Query 86 - When there is a rollup , the parser keels over on grouping_id() on a single column

2016-03-30 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-14203?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Roy Cecil resolved SPARK-14203. --- Resolution: Workaround > TPC-DS Query 86 - When there is a rollup , the parser keels over on >

[jira] [Created] (SPARK-14203) TPC-DS Query 86 - When there is a rollup , the parser keels over on grouping_id() on a single column

2016-03-28 Thread Roy Cecil (JIRA)
Roy Cecil created SPARK-14203: - Summary: TPC-DS Query 86 - When there is a rollup , the parser keels over on grouping_id() on a single column Key: SPARK-14203 URL: https://issues.apache.org/jira/browse/SPARK-14203

[jira] [Closed] (SPARK-13832) TPC-DS Query 36 fails with Parser error

2016-03-24 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-13832?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Roy Cecil closed SPARK-13832. - Resolution: Duplicate > TPC-DS Query 36 fails with Parser error >

[jira] [Commented] (SPARK-13832) TPC-DS Query 36 fails with Parser error

2016-03-24 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-13832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15211107#comment-15211107 ] Roy Cecil commented on SPARK-13832: --- I verified a few queries and I think we can close this and mark

[jira] [Comment Edited] (SPARK-13832) TPC-DS Query 36 fails with Parser error

2016-03-24 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-13832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15210585#comment-15210585 ] Roy Cecil edited comment on SPARK-13832 at 3/24/16 5:16 PM: Xin, there are

[jira] [Commented] (SPARK-13832) TPC-DS Query 36 fails with Parser error

2016-03-24 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-13832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15210585#comment-15210585 ] Roy Cecil commented on SPARK-13832: --- Xin, there are other queries with grouping__id that runs through

[jira] [Commented] (SPARK-13831) TPC-DS Query 35 fails with the following compile error

2016-03-20 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-13831?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15201547#comment-15201547 ] Roy Cecil commented on SPARK-13831: --- Davies, what is the roadmap for supporting Exists ? > TPC-DS

[jira] [Closed] (SPARK-13821) TPC-DS Query 20 fails to compile

2016-03-19 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-13821?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Roy Cecil closed SPARK-13821. - Resolution: Not A Problem > TPC-DS Query 20 fails to compile > > >

[jira] [Comment Edited] (SPARK-13821) TPC-DS Query 20 fails to compile

2016-03-19 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-13821?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15201506#comment-15201506 ] Roy Cecil edited comment on SPARK-13821 at 3/18/16 2:09 PM: Dilip, Removed

[jira] [Commented] (SPARK-13832) TPC-DS Query 36 fails with Parser error

2016-03-19 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-13832?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15201962#comment-15201962 ] Roy Cecil commented on SPARK-13832: --- Xin, are you saying you the query passed compile in Spark 2.0 but

[jira] [Commented] (SPARK-13821) TPC-DS Query 20 fails to compile

2016-03-19 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-13821?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15201707#comment-15201707 ] Roy Cecil commented on SPARK-13821: --- Dilip, we can close this. Likely a defect in the kit . > TPC-DS

[jira] [Commented] (SPARK-13820) TPC-DS Query 10 fails to compile

2016-03-19 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-13820?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15201550#comment-15201550 ] Roy Cecil commented on SPARK-13820: --- Davies, what is the roadmap for supporting correlated subqueries ?

[jira] [Commented] (SPARK-13821) TPC-DS Query 20 fails to compile

2016-03-18 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-13821?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15201506#comment-15201506 ] Roy Cecil commented on SPARK-13821: --- Dilip, Removed the query and it compiles. Since I am really

[jira] [Created] (SPARK-13832) TPC-DS Query 36 fails with Parser error

2016-03-11 Thread Roy Cecil (JIRA)
Roy Cecil created SPARK-13832: - Summary: TPC-DS Query 36 fails with Parser error Key: SPARK-13832 URL: https://issues.apache.org/jira/browse/SPARK-13832 Project: Spark Issue Type: Bug

[jira] [Updated] (SPARK-13832) TPC-DS Query 36 fails with Parser error

2016-03-11 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-13832?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Roy Cecil updated SPARK-13832: -- Description: TPC-DS query 36 fails with the following error Analyzer error: 16/02/28 21:22:51 INFO

[jira] [Created] (SPARK-13831) TPC-DS Query 35 fails with the following compile error

2016-03-11 Thread Roy Cecil (JIRA)
Roy Cecil created SPARK-13831: - Summary: TPC-DS Query 35 fails with the following compile error Key: SPARK-13831 URL: https://issues.apache.org/jira/browse/SPARK-13831 Project: Spark Issue Type:

[jira] [Issue Comment Deleted] (SPARK-13821) TPC-DS Query 20 fails to compile

2016-03-11 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-13821?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Roy Cecil updated SPARK-13821: -- Comment: was deleted (was: Query Text is select i_item_id ,i_item_desc ,i_category

[jira] [Issue Comment Deleted] (SPARK-13821) TPC-DS Query 20 fails to compile

2016-03-11 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-13821?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Roy Cecil updated SPARK-13821: -- Comment: was deleted (was: select i_item_id ,i_item_desc ,i_category ,i_class

[jira] [Issue Comment Deleted] (SPARK-13821) TPC-DS Query 20 fails to compile

2016-03-11 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-13821?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Roy Cecil updated SPARK-13821: -- Comment: was deleted (was: Query Text is select i_item_id ,i_item_desc ,i_category

[jira] [Commented] (SPARK-13821) TPC-DS Query 20 fails to compile

2016-03-11 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-13821?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15190839#comment-15190839 ] Roy Cecil commented on SPARK-13821: --- select i_item_id ,i_item_desc ,i_category

[jira] [Commented] (SPARK-13821) TPC-DS Query 20 fails to compile

2016-03-11 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-13821?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15190837#comment-15190837 ] Roy Cecil commented on SPARK-13821: --- Query Text is select i_item_id ,i_item_desc

[jira] [Commented] (SPARK-13821) TPC-DS Query 20 fails to compile

2016-03-11 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-13821?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15190835#comment-15190835 ] Roy Cecil commented on SPARK-13821: --- Query Text is select i_item_id ,i_item_desc

[jira] [Commented] (SPARK-13821) TPC-DS Query 20 fails to compile

2016-03-11 Thread Roy Cecil (JIRA)
[ https://issues.apache.org/jira/browse/SPARK-13821?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=15190836#comment-15190836 ] Roy Cecil commented on SPARK-13821: --- Query Text is select i_item_id ,i_item_desc

[jira] [Created] (SPARK-13821) TPC-DS Query 20 fails to compile

2016-03-11 Thread Roy Cecil (JIRA)
Roy Cecil created SPARK-13821: - Summary: TPC-DS Query 20 fails to compile Key: SPARK-13821 URL: https://issues.apache.org/jira/browse/SPARK-13821 Project: Spark Issue Type: Bug Affects

[jira] [Created] (SPARK-13820) TPC-DS Query 10 fails to compile

2016-03-11 Thread Roy Cecil (JIRA)
Roy Cecil created SPARK-13820: - Summary: TPC-DS Query 10 fails to compile Key: SPARK-13820 URL: https://issues.apache.org/jira/browse/SPARK-13820 Project: Spark Issue Type: Bug Affects