[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-26 Thread hvanhovell
Github user hvanhovell commented on the pull request: https://github.com/apache/spark/pull/11361#issuecomment-189155044 @viirya I really don't see any reason to keep ANTLR3 around after we migrate the parser. --- If your project is set up for it, you can reply to this email and have

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-25 Thread viirya
Github user viirya commented on the pull request: https://github.com/apache/spark/pull/11361#issuecomment-189136538 @hvanhovell Great to see your initial work. It looks promising. I think this can wait until the new parser. Besides, are we going to deprecate ANTLR3 used now? --- If

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-25 Thread hvanhovell
Github user hvanhovell commented on the pull request: https://github.com/apache/spark/pull/11361#issuecomment-189131737 @viirya I am currently ANTLR4 based version of the parsers (see my repo for a few initial commits). It is basically a port of the presto parsers. I need another week

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-25 Thread viirya
Github user viirya commented on the pull request: https://github.com/apache/spark/pull/11361#issuecomment-188696475 ok. I will continue to see if we can improve the performance of parsing nested union. --- If your project is set up for it, you can reply to this email and have your re

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-25 Thread rxin
Github user rxin commented on the pull request: https://github.com/apache/spark/pull/11361#issuecomment-188675431 Any other thing we can do for this perf problem? It's only 25 levels of nesting. It seems strange to me that the parser would take mins to parse this ... cc @hvan

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-25 Thread viirya
Github user viirya commented on the pull request: https://github.com/apache/spark/pull/11361#issuecomment-188665321 @rxin I don't think we should convert union sql query back to nested one. I would like to remove the `()` from SQLBuilder for union. What do you think? --- If your proj

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-25 Thread viirya
Github user viirya commented on the pull request: https://github.com/apache/spark/pull/11361#issuecomment-188664991 @rxin ok. I got why it takes so long to finish the test. The original query: SELECT count(1) FROM ( SELECT key, value FROM src UNION ALL

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-24 Thread rxin
Github user rxin commented on the pull request: https://github.com/apache/spark/pull/11361#issuecomment-188629681 Can you take a look why would 2 queries take 13 mins? ``` EXPLAIN SELECT count(1) FROM ( SELECT key, value FROM src UNION ALL SELECT key, value

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-24 Thread viirya
Github user viirya commented on the pull request: https://github.com/apache/spark/pull/11361#issuecomment-188627434 @rxin Looks like HiveCompatibilitySuite.union16 doesn't hang from this. But it actually takes long time to finish that test (`[info] - union16 (13 minutes, 21 seconds)`)

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-24 Thread AmplabJenkins
Github user AmplabJenkins commented on the pull request: https://github.com/apache/spark/pull/11361#issuecomment-188626798 Test PASSed. Refer to this link for build results (access rights to CI server needed): https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-24 Thread AmplabJenkins
Github user AmplabJenkins commented on the pull request: https://github.com/apache/spark/pull/11361#issuecomment-188626796 Merged build finished. Test PASSed. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your projec

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-24 Thread SparkQA
Github user SparkQA commented on the pull request: https://github.com/apache/spark/pull/11361#issuecomment-188626175 **[Test build #51928 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/51928/consoleFull)** for PR 11361 at commit [`5ff5ac2`](https://g

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-24 Thread viirya
Github user viirya commented on the pull request: https://github.com/apache/spark/pull/11361#issuecomment-188592169 cc @rxin I am not sure if HiveCompatibilitySuite.union16 was hanging from this. Because I copy the same queries from union16 to HiveQuerySuite and they are wor

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-24 Thread SparkQA
Github user SparkQA commented on the pull request: https://github.com/apache/spark/pull/11361#issuecomment-188592087 **[Test build #51928 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/51928/consoleFull)** for PR 11361 at commit [`5ff5ac2`](https://gi

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-24 Thread viirya
GitHub user viirya opened a pull request: https://github.com/apache/spark/pull/11361 [SPARK-13321][SQL] Support nested UNION in parser JIRA: https://issues.apache.org/jira/browse/SPARK-13321 ## What changes were proposed in this pull request? The following SQL can n

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-24 Thread viirya
Github user viirya commented on the pull request: https://github.com/apache/spark/pull/11204#issuecomment-188535960 @rxin ok, I will look into this today. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project do

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-24 Thread gatorsmile
Github user gatorsmile commented on the pull request: https://github.com/apache/spark/pull/11204#issuecomment-188460661 Just submit a PR: https://github.com/apache/spark/pull/11352. Thanks! @rxin --- If your project is set up for it, you can reply to this email and have your reply ap

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-24 Thread rxin
Github user rxin commented on the pull request: https://github.com/apache/spark/pull/11204#issuecomment-188459220 @viirya when you fixed this issue, please make sure you add a unit test aside from Hive compat test. --- If your project is set up for it, you can reply to this email an

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-24 Thread rxin
Github user rxin commented on the pull request: https://github.com/apache/spark/pull/11204#issuecomment-188459106 Please do. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enab

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-24 Thread gatorsmile
Github user gatorsmile commented on the pull request: https://github.com/apache/spark/pull/11204#issuecomment-188458568 @rxin Do you need me to submit a PR to disable the following test case? This test case requires the nested Union support. Thanks! https://github.com/apache/

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-24 Thread rxin
Github user rxin commented on the pull request: https://github.com/apache/spark/pull/11204#issuecomment-188440444 Note: I reverted this patch because HiveCompatibilitySuite.union16 was hanging from this. Somehow we weren't running test cases in HiveCompatibilitySuite anymore f

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-21 Thread asfgit
Github user asfgit closed the pull request at: https://github.com/apache/spark/pull/11204 --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabled and wishes so, or if the feature is ena

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-21 Thread rxin
Github user rxin commented on the pull request: https://github.com/apache/spark/pull/11204#issuecomment-186980183 Thanks - merging in master. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-21 Thread viirya
Github user viirya commented on the pull request: https://github.com/apache/spark/pull/11204#issuecomment-186974334 cc @rxin --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enab

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-21 Thread hvanhovell
Github user hvanhovell commented on the pull request: https://github.com/apache/spark/pull/11204#issuecomment-186835931 LGTM --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your project does not have this feature enabl

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-21 Thread AmplabJenkins
Github user AmplabJenkins commented on the pull request: https://github.com/apache/spark/pull/11204#issuecomment-186834983 Test PASSed. Refer to this link for build results (access rights to CI server needed): https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-21 Thread AmplabJenkins
Github user AmplabJenkins commented on the pull request: https://github.com/apache/spark/pull/11204#issuecomment-186834982 Merged build finished. Test PASSed. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your projec

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-21 Thread SparkQA
Github user SparkQA commented on the pull request: https://github.com/apache/spark/pull/11204#issuecomment-186834887 **[Test build #51630 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/51630/consoleFull)** for PR 11204 at commit [`d024fff`](https://g

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-21 Thread SparkQA
Github user SparkQA commented on the pull request: https://github.com/apache/spark/pull/11204#issuecomment-186822914 **[Test build #51630 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/51630/consoleFull)** for PR 11204 at commit [`d024fff`](https://gi

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-21 Thread viirya
Github user viirya commented on the pull request: https://github.com/apache/spark/pull/11204#issuecomment-186820360 @hvanhovell Do you have other comments on this PR? --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If you

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-15 Thread viirya
Github user viirya commented on a diff in the pull request: https://github.com/apache/spark/pull/11204#discussion_r52968390 --- Diff: sql/catalyst/src/test/scala/org/apache/spark/sql/catalyst/CatalystQlSuite.scala --- @@ -201,4 +201,68 @@ class CatalystQlSuite extends PlanTest {

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-15 Thread viirya
Github user viirya commented on a diff in the pull request: https://github.com/apache/spark/pull/11204#discussion_r52968367 --- Diff: sql/catalyst/src/main/antlr3/org/apache/spark/sql/catalyst/parser/SparkSqlParser.g --- @@ -2320,6 +2320,19 @@ regularBody[boolean topLevel]

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-15 Thread viirya
Github user viirya commented on a diff in the pull request: https://github.com/apache/spark/pull/11204#discussion_r52968331 --- Diff: sql/catalyst/src/main/antlr3/org/apache/spark/sql/catalyst/parser/SparkSqlParser.g --- @@ -2320,6 +2320,19 @@ regularBody[boolean topLevel]

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-15 Thread AmplabJenkins
Github user AmplabJenkins commented on the pull request: https://github.com/apache/spark/pull/11204#issuecomment-184297761 Test PASSed. Refer to this link for build results (access rights to CI server needed): https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-15 Thread AmplabJenkins
Github user AmplabJenkins commented on the pull request: https://github.com/apache/spark/pull/11204#issuecomment-184297752 Merged build finished. Test PASSed. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your projec

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-15 Thread SparkQA
Github user SparkQA commented on the pull request: https://github.com/apache/spark/pull/11204#issuecomment-184296823 **[Test build #51314 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/51314/consoleFull)** for PR 11204 at commit [`190b326`](https://g

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-15 Thread SparkQA
Github user SparkQA commented on the pull request: https://github.com/apache/spark/pull/11204#issuecomment-184255054 **[Test build #51314 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/51314/consoleFull)** for PR 11204 at commit [`190b326`](https://gi

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-15 Thread AmplabJenkins
Github user AmplabJenkins commented on the pull request: https://github.com/apache/spark/pull/11204#issuecomment-184250287 Merged build finished. Test PASSed. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your projec

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-15 Thread AmplabJenkins
Github user AmplabJenkins commented on the pull request: https://github.com/apache/spark/pull/11204#issuecomment-184250290 Test PASSed. Refer to this link for build results (access rights to CI server needed): https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-15 Thread SparkQA
Github user SparkQA commented on the pull request: https://github.com/apache/spark/pull/11204#issuecomment-184250011 **[Test build #51310 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/51310/consoleFull)** for PR 11204 at commit [`f462997`](https://g

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-15 Thread SparkQA
Github user SparkQA commented on the pull request: https://github.com/apache/spark/pull/11204#issuecomment-184217585 **[Test build #51310 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/51310/consoleFull)** for PR 11204 at commit [`f462997`](https://gi

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-15 Thread viirya
Github user viirya commented on a diff in the pull request: https://github.com/apache/spark/pull/11204#discussion_r52899001 --- Diff: sql/catalyst/src/main/antlr3/org/apache/spark/sql/catalyst/parser/SparkSqlParser.g --- @@ -2320,6 +2320,19 @@ regularBody[boolean topLevel]

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-15 Thread viirya
Github user viirya commented on a diff in the pull request: https://github.com/apache/spark/pull/11204#discussion_r52896850 --- Diff: sql/catalyst/src/test/scala/org/apache/spark/sql/catalyst/CatalystQlSuite.scala --- @@ -201,4 +201,13 @@ class CatalystQlSuite extends PlanTest {

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-15 Thread hvanhovell
Github user hvanhovell commented on a diff in the pull request: https://github.com/apache/spark/pull/11204#discussion_r52896589 --- Diff: sql/catalyst/src/main/antlr3/org/apache/spark/sql/catalyst/parser/SparkSqlParser.g --- @@ -2320,6 +2320,19 @@ regularBody[boolean topLevel]

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-15 Thread hvanhovell
Github user hvanhovell commented on a diff in the pull request: https://github.com/apache/spark/pull/11204#discussion_r52896251 --- Diff: sql/catalyst/src/test/scala/org/apache/spark/sql/catalyst/CatalystQlSuite.scala --- @@ -201,4 +201,13 @@ class CatalystQlSuite extends PlanTest

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-14 Thread AmplabJenkins
Github user AmplabJenkins commented on the pull request: https://github.com/apache/spark/pull/11204#issuecomment-184102321 Test PASSed. Refer to this link for build results (access rights to CI server needed): https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-14 Thread AmplabJenkins
Github user AmplabJenkins commented on the pull request: https://github.com/apache/spark/pull/11204#issuecomment-184102320 Merged build finished. Test PASSed. --- If your project is set up for it, you can reply to this email and have your reply appear on GitHub as well. If your projec

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-14 Thread SparkQA
Github user SparkQA commented on the pull request: https://github.com/apache/spark/pull/11204#issuecomment-184102156 **[Test build #51295 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/51295/consoleFull)** for PR 11204 at commit [`93bd51e`](https://g

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-14 Thread SparkQA
Github user SparkQA commented on the pull request: https://github.com/apache/spark/pull/11204#issuecomment-184080252 **[Test build #51295 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/51295/consoleFull)** for PR 11204 at commit [`93bd51e`](https://gi

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-14 Thread viirya
Github user viirya commented on a diff in the pull request: https://github.com/apache/spark/pull/11204#discussion_r52862728 --- Diff: sql/catalyst/src/main/antlr3/org/apache/spark/sql/catalyst/parser/SparkSqlParser.g --- @@ -2320,6 +2320,19 @@ regularBody[boolean topLevel]

[GitHub] spark pull request: [SPARK-13321][SQL] Support nested UNION in par...

2016-02-14 Thread viirya
GitHub user viirya opened a pull request: https://github.com/apache/spark/pull/11204 [SPARK-13321][SQL] Support nested UNION in parser JIRA: https://issues.apache.org/jira/browse/SPARK-13321 The following SQL can not be parsed with current parser: SELECT `u_1`.