You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@spark.apache.org by lresende <gi...@git.apache.org> on 2016/04/09 05:43:51 UTC

[GitHub] spark pull request: [SPARK-13419] Update SubquerySuite to use chec...

GitHub user lresende opened a pull request:

    https://github.com/apache/spark/pull/12269

    [SPARK-13419] Update SubquerySuite to use checkAnswer to validate res…

    ## What changes were proposed in this pull request?
    
    Change SubquerySuite to validate test results utilizing checkAnswer helper method
    
    ## How was this patch tested?
    
    Existing tests

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/lresende/spark SPARK-13419

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/spark/pull/12269.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #12269
    
----
commit d0652c93560700ed86b7bf827a0f97aab3886176
Author: Luciano Resende <lr...@apache.org>
Date:   2016-04-09T03:39:59Z

    [SPARK-13419] Update SubquerySuite to use checkAnswer to validate results

----


---
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 enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] spark pull request: [SPARK-13419][SQL] Update SubquerySuite to use...

Posted by SparkQA <gi...@git.apache.org>.
Github user SparkQA commented on the pull request:

    https://github.com/apache/spark/pull/12269#issuecomment-212224552
  
    **[Test build #56307 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/56307/consoleFull)** for PR 12269 at commit [`79b49b7`](https://github.com/apache/spark/commit/79b49b70b27ccacc4c012f57ab4c5448c69da817).
     * This patch passes all tests.
     * This patch merges cleanly.
     * This patch adds no public classes.


---
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 enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] spark pull request: [SPARK-13419] Update SubquerySuite to use chec...

Posted by AmplabJenkins <gi...@git.apache.org>.
Github user AmplabJenkins commented on the pull request:

    https://github.com/apache/spark/pull/12269#issuecomment-207706575
  
    Merged build finished. Test FAILed.


---
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 enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] spark pull request: [SPARK-13419] Update SubquerySuite to use chec...

Posted by SparkQA <gi...@git.apache.org>.
Github user SparkQA commented on the pull request:

    https://github.com/apache/spark/pull/12269#issuecomment-207706428
  
    **[Test build #55416 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/55416/consoleFull)** for PR 12269 at commit [`d0652c9`](https://github.com/apache/spark/commit/d0652c93560700ed86b7bf827a0f97aab3886176).
     * This patch **fails Spark unit tests**.
     * This patch merges cleanly.
     * This patch adds no public classes.


---
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 enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] spark pull request: [SPARK-13419][SQL] Update SubquerySuite to use...

Posted by SparkQA <gi...@git.apache.org>.
Github user SparkQA commented on the pull request:

    https://github.com/apache/spark/pull/12269#issuecomment-212198386
  
    **[Test build #56307 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/56307/consoleFull)** for PR 12269 at commit [`79b49b7`](https://github.com/apache/spark/commit/79b49b70b27ccacc4c012f57ab4c5448c69da817).


---
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 enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] spark pull request: [SPARK-13419] Update SubquerySuite to use chec...

Posted by AmplabJenkins <gi...@git.apache.org>.
Github user AmplabJenkins commented on the pull request:

    https://github.com/apache/spark/pull/12269#issuecomment-209254535
  
    Test FAILed.
    Refer to this link for build results (access rights to CI server needed): 
    https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/55691/
    Test FAILed.


---
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 enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] spark pull request: [SPARK-13419][SQL] Update SubquerySuite to use...

Posted by lresende <gi...@git.apache.org>.
Github user lresende commented on the pull request:

    https://github.com/apache/spark/pull/12269#issuecomment-212137015
  
    @davies @liancheng 
    So, when converting these tests, I noticed that the following : 
    test("uncorrelated scalar subquery on a DataFrame generated query") {
        val df = Seq((1, "one"), (2, "two"), (3, "three")).toDF("key", "value")
        df.registerTempTable("subqueryData")
    
        checkAnswer(
          sql("select (select key from subqueryData where key > 2 order by key limit 1) + 1"),
          Array(Row(4))
        )
    }
    
    Will fail with different plans, e.g.:
    
    Project [(subquery#9 + 1) AS (scalarsubquery() + 1)#11]
    :  +- SubqueryAlias subquery#9
    :     +- GlobalLimit 1
    :        +- LocalLimit 1
    :           +- Sort [key#5 ASC], true
    :              +- Project [key#5]
    :                 +- Filter (key#5 > 2)
    :                    +- SubqueryAlias subqueryData
    :                       +- Project [_1#2 AS key#5,_2#3 AS value#6]
    :                          +- LocalRelation [_1#2,_2#3], [[0,1,1800000003,656e6f],[0,2,1800000003,6f7774],[0,3,1800000005,6565726874]]
    +- OneRowRelation$
    
    
    
    Project [(subquery#9 + 1) AS (scalarsubquery() + 1)#11]
    :  +- SubqueryAlias subquery#9
    :     +- GlobalLimit 1
    :        +- LocalLimit 1
    :           +- Sort [key#5 ASC], true
    :              +- Project [key#5]
    :                 +- Filter (key#5 > 2)
    :                    +- SubqueryAlias subqueryData
    :                       +- Project [_1#2 AS key#5,_2#3 AS value#6]
    :                          +- LocalRelation [_1#2,_2#3], [null,null,null]
    +- OneRowRelation$
    
    During some debuging I was tracking it down to TreeNode.parseToJson, where the missing data is falling into the case _ and not being properly added to json... but the actual fix might be in a different place.
    
    Any thoughts on this issue ?
    



---
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 enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] spark pull request: [SPARK-13419] Update SubquerySuite to use chec...

Posted by SparkQA <gi...@git.apache.org>.
Github user SparkQA commented on the pull request:

    https://github.com/apache/spark/pull/12269#issuecomment-209254162
  
    **[Test build #55691 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/55691/consoleFull)** for PR 12269 at commit [`e58cf23`](https://github.com/apache/spark/commit/e58cf23605955ab18f23971b7ab615e10ae2886e).
     * This patch **fails Spark unit tests**.
     * This patch merges cleanly.
     * This patch adds no public classes.


---
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 enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] spark pull request: [SPARK-13419][SQL] Update SubquerySuite to use...

Posted by davies <gi...@git.apache.org>.
Github user davies commented on the pull request:

    https://github.com/apache/spark/pull/12269#issuecomment-212132128
  
    cc @liancheng , who knows more in SQL generation 


---
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 enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] spark pull request: [SPARK-13419] Update SubquerySuite to use chec...

Posted by SparkQA <gi...@git.apache.org>.
Github user SparkQA commented on the pull request:

    https://github.com/apache/spark/pull/12269#issuecomment-207695691
  
    **[Test build #55416 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/55416/consoleFull)** for PR 12269 at commit [`d0652c9`](https://github.com/apache/spark/commit/d0652c93560700ed86b7bf827a0f97aab3886176).


---
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 enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] spark pull request: [SPARK-13419][SQL] Update SubquerySuite to use...

Posted by lresende <gi...@git.apache.org>.
Github user lresende commented on the pull request:

    https://github.com/apache/spark/pull/12269#issuecomment-212198729
  
    @davies @liancheng looks like after re basing to latest code, this issue has been resolved. I am going to wait for a build to complete to double check.


---
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 enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] spark pull request: [SPARK-13419][SQL] Update SubquerySuite to use...

Posted by AmplabJenkins <gi...@git.apache.org>.
Github user AmplabJenkins commented on the pull request:

    https://github.com/apache/spark/pull/12269#issuecomment-212224809
  
    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 project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] spark pull request: [SPARK-13419][SQL] Update SubquerySuite to use...

Posted by davies <gi...@git.apache.org>.
Github user davies commented on the pull request:

    https://github.com/apache/spark/pull/12269#issuecomment-212245535
  
    LGTM, 
    Merging this into master, thanks!


---
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 enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] spark pull request: [SPARK-13419] Update SubquerySuite to use chec...

Posted by AmplabJenkins <gi...@git.apache.org>.
Github user AmplabJenkins commented on the pull request:

    https://github.com/apache/spark/pull/12269#issuecomment-209254529
  
    Merged build finished. Test FAILed.


---
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 enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] spark pull request: [SPARK-13419] Update SubquerySuite to use chec...

Posted by SparkQA <gi...@git.apache.org>.
Github user SparkQA commented on the pull request:

    https://github.com/apache/spark/pull/12269#issuecomment-209232767
  
    **[Test build #55691 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/55691/consoleFull)** for PR 12269 at commit [`e58cf23`](https://github.com/apache/spark/commit/e58cf23605955ab18f23971b7ab615e10ae2886e).


---
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 enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] spark pull request: [SPARK-13419] Update SubquerySuite to use chec...

Posted by AmplabJenkins <gi...@git.apache.org>.
Github user AmplabJenkins commented on the pull request:

    https://github.com/apache/spark/pull/12269#issuecomment-207706579
  
    Test FAILed.
    Refer to this link for build results (access rights to CI server needed): 
    https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/55416/
    Test FAILed.


---
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 enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] spark pull request: [SPARK-13419][SQL] Update SubquerySuite to use...

Posted by AmplabJenkins <gi...@git.apache.org>.
Github user AmplabJenkins commented on the pull request:

    https://github.com/apache/spark/pull/12269#issuecomment-212224817
  
    Test PASSed.
    Refer to this link for build results (access rights to CI server needed): 
    https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/56307/
    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 project does not have this feature
enabled and wishes so, or if the feature is enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org


[GitHub] spark pull request: [SPARK-13419][SQL] Update SubquerySuite to use...

Posted by asfgit <gi...@git.apache.org>.
Github user asfgit closed the pull request at:

    https://github.com/apache/spark/pull/12269


---
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 enabled but not working, please
contact infrastructure at infrastructure@apache.org or file a JIRA ticket
with INFRA.
---

---------------------------------------------------------------------
To unsubscribe, e-mail: reviews-unsubscribe@spark.apache.org
For additional commands, e-mail: reviews-help@spark.apache.org