You are viewing a plain text version of this content. The canonical link for it is here.
Posted to reviews@spark.apache.org by suchithjn225 <gi...@git.apache.org> on 2018/01/07 15:20:39 UTC

[GitHub] spark pull request #20177: [SPARK-22954][SQL] Fix the exception thrown by An...

GitHub user suchithjn225 opened a pull request:

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

    [SPARK-22954][SQL] Fix the exception thrown by Analyze command on temporary views to throw AnalysisException

    ## What changes were proposed in this pull request?
    Previously running ANALYZE on temporary views produced NoSuchTableException even though the view was present. It is misleading. So it has to be changed to throw AnalysisException since it comes in the analysis part. 
    
    ## How was this patch tested?
    Some unit tests were fixed to intercept AnalysisException instead of NoSuchTableException.
    


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

    $ git pull https://github.com/suchithjn225/spark SPARK-22954-SQL

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

    https://github.com/apache/spark/pull/20177.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 #20177
    
----
commit 8e92e6c26f61ac1999d76993756b8c696e487165
Author: Suchith J N <su...@...>
Date:   2018-01-05T21:46:20Z

    [SPARK-22954][SQL] Fixed the problem where temporary views were not looked up by session state's catalog.

commit 4de6ac840a6b8cbd7c5795b023783b626b21a9f4
Author: Suchith J N <su...@...>
Date:   2018-01-06T19:01:37Z

    [SPARK-22954][SQL] Fixed database name lookup so that None is returned instead of Some('default')

commit 98b8711cdd26c25fd774f77f46fc9e395ee2cffe
Author: Suchith J N <su...@...>
Date:   2018-01-07T10:09:33Z

    [SPARK-22954][SQL] Fixed the test to test for AnalysisException instead of NoSuchTableException

----


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

Posted by cloud-fan <gi...@git.apache.org>.
Github user cloud-fan commented on the issue:

    https://github.com/apache/spark/pull/20177
  
    ok to test


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    **[Test build #86506 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/86506/testReport)** for PR 20177 at commit [`4d4e3fe`](https://github.com/apache/spark/commit/4d4e3fe9cced139efc8f162a7dddda15527b641c).


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    Can one of the admins verify this patch?


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    **[Test build #86426 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/86426/testReport)** for PR 20177 at commit [`4d4e3fe`](https://github.com/apache/spark/commit/4d4e3fe9cced139efc8f162a7dddda15527b641c).
     * This patch **fails due to an unknown error code, -9**.
     * This patch merges cleanly.
     * This patch adds no public classes.


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

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


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    **[Test build #86424 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/86424/testReport)** for PR 20177 at commit [`0e873e5`](https://github.com/apache/spark/commit/0e873e5fcfe0858d869d9cb9cf63597c6746b734).
     * This patch **fails Scala style tests**.
     * This patch merges cleanly.
     * This patch adds no public classes.


---

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


[GitHub] spark pull request #20177: [SPARK-22954][SQL] Fix the exception thrown by An...

Posted by jiangxb1987 <gi...@git.apache.org>.
Github user jiangxb1987 commented on a diff in the pull request:

    https://github.com/apache/spark/pull/20177#discussion_r162749089
  
    --- Diff: sql/core/src/test/scala/org/apache/spark/sql/execution/SQLViewSuite.scala ---
    @@ -154,11 +155,17 @@ abstract class SQLViewSuite extends QueryTest with SQLTestUtils {
           assertNoSuchTable(s"TRUNCATE TABLE $viewName")
           assertNoSuchTable(s"SHOW CREATE TABLE $viewName")
           assertNoSuchTable(s"SHOW PARTITIONS $viewName")
    -      assertNoSuchTable(s"ANALYZE TABLE $viewName COMPUTE STATISTICS")
    -      assertNoSuchTable(s"ANALYZE TABLE $viewName COMPUTE STATISTICS FOR COLUMNS id")
    +      assertAnalysisException(s"ANALYZE TABLE $viewName COMPUTE STATISTICS")
    --- End diff --
    
    We should also check the error message to ensure the `AnalysisException` is not thrown from elsewhere.


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    **[Test build #85781 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/85781/testReport)** for PR 20177 at commit [`98b8711`](https://github.com/apache/spark/commit/98b8711cdd26c25fd774f77f46fc9e395ee2cffe).


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    **[Test build #85781 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/85781/testReport)** for PR 20177 at commit [`98b8711`](https://github.com/apache/spark/commit/98b8711cdd26c25fd774f77f46fc9e395ee2cffe).
     * This patch **fails Scala style tests**.
     * This patch merges cleanly.
     * This patch adds no public classes.


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

Posted by cloud-fan <gi...@git.apache.org>.
Github user cloud-fan commented on the issue:

    https://github.com/apache/spark/pull/20177
  
    what's the error message after this patch?


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    **[Test build #90807 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/90807/testReport)** for PR 20177 at commit [`4c86456`](https://github.com/apache/spark/commit/4c8645623f3b89c9f7b1bc7809c6b9f5a95d2389).


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    Merged build finished. Test FAILed.


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    **[Test build #90807 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/90807/testReport)** for PR 20177 at commit [`4c86456`](https://github.com/apache/spark/commit/4c8645623f3b89c9f7b1bc7809c6b9f5a95d2389).
     * This patch passes all tests.
     * This patch merges cleanly.
     * This patch adds no public classes.


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    Merged build finished. Test PASSed.


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    Merged build finished. Test FAILed.


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    **[Test build #86425 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/86425/testReport)** for PR 20177 at commit [`77e4d6d`](https://github.com/apache/spark/commit/77e4d6db1d647db7a7b2c13c922bab0bdd3e53fc).
     * This patch **fails Scala style tests**.
     * This patch merges cleanly.
     * This patch adds no public classes.


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    **[Test build #86426 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/86426/testReport)** for PR 20177 at commit [`4d4e3fe`](https://github.com/apache/spark/commit/4d4e3fe9cced139efc8f162a7dddda15527b641c).


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

Posted by suchithjn225 <gi...@git.apache.org>.
Github user suchithjn225 commented on the issue:

    https://github.com/apache/spark/pull/20177
  
    I updated AnalyzePartitionCommand and AnalyzeColumnCommand. I noticed another one - According to SQLViewSuite, calling truncate on view must throw NoSuchTable, where as in TruncateTableCommand class I noticed this
    ```
        if (table.tableType == CatalogTableType.VIEW) {
          throw new AnalysisException(
            s"Operation not allowed: TRUNCATE TABLE on views: $tableIdentWithDB")
        }
    ```
    A bug?


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

Posted by cloud-fan <gi...@git.apache.org>.
Github user cloud-fan commented on the issue:

    https://github.com/apache/spark/pull/20177
  
    retest this please


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    **[Test build #86506 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/86506/testReport)** for PR 20177 at commit [`4d4e3fe`](https://github.com/apache/spark/commit/4d4e3fe9cced139efc8f162a7dddda15527b641c).
     * This patch passes all tests.
     * This patch merges cleanly.
     * This patch adds no public classes.


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    **[Test build #86425 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/86425/testReport)** for PR 20177 at commit [`77e4d6d`](https://github.com/apache/spark/commit/77e4d6db1d647db7a7b2c13c922bab0bdd3e53fc).


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    Can one of the admins verify this patch?


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

Posted by gatorsmile <gi...@git.apache.org>.
Github user gatorsmile commented on the issue:

    https://github.com/apache/spark/pull/20177
  
    cc @wzhfy 


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    Test PASSed.
    Refer to this link for build results (access rights to CI server needed): 
    https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/86506/
    Test PASSed.


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

Posted by cloud-fan <gi...@git.apache.org>.
Github user cloud-fan commented on the issue:

    https://github.com/apache/spark/pull/20177
  
    actually it's not really useful to have `NoSuchTableException`, `NoSuchFunctionException`, etc. always using AnalysisException seems fine. CC @gatorsmile 


---

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


[GitHub] spark pull request #20177: [SPARK-22954][SQL] Fix the exception thrown by An...

Posted by suchithjn225 <gi...@git.apache.org>.
GitHub user suchithjn225 reopened a pull request:

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

    [SPARK-22954][SQL] Fix the exception thrown by Analyze command on temporary views to throw AnalysisException

    ## What changes were proposed in this pull request?
    Previously running ANALYZE on temporary views produced NoSuchTableException even though the view was present. It is misleading. So it has to be changed to throw AnalysisException since it comes in the analysis part. 
    
    ## How was this patch tested?
    Some unit tests were fixed to intercept AnalysisException instead of NoSuchTableException.
    


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

    $ git pull https://github.com/suchithjn225/spark SPARK-22954-SQL

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

    https://github.com/apache/spark/pull/20177.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 #20177
    
----
commit 8e92e6c26f61ac1999d76993756b8c696e487165
Author: Suchith J N <su...@...>
Date:   2018-01-05T21:46:20Z

    [SPARK-22954][SQL] Fixed the problem where temporary views were not looked up by session state's catalog.

commit 4de6ac840a6b8cbd7c5795b023783b626b21a9f4
Author: Suchith J N <su...@...>
Date:   2018-01-06T19:01:37Z

    [SPARK-22954][SQL] Fixed database name lookup so that None is returned instead of Some('default')

commit 98b8711cdd26c25fd774f77f46fc9e395ee2cffe
Author: Suchith J N <su...@...>
Date:   2018-01-07T10:09:33Z

    [SPARK-22954][SQL] Fixed the test to test for AnalysisException instead of NoSuchTableException

commit 0e873e5fcfe0858d869d9cb9cf63597c6746b734
Author: Suchith J N <su...@...>
Date:   2018-01-21T05:14:53Z

    [SPARK-22954][SQL] Fix the problem for other versions of analyze commands - AnalyzeColum and AnalyzePartition. Fix tests to check if the error messages are proper.

commit 77e4d6db1d647db7a7b2c13c922bab0bdd3e53fc
Author: Suchith J N <su...@...>
Date:   2018-01-21T06:21:20Z

    [SPARK-22954][SQL] Reorganize imports to satisfy Scalastyle.

commit 4d4e3fe9cced139efc8f162a7dddda15527b641c
Author: Suchith J N <su...@...>
Date:   2018-01-21T06:36:33Z

    [SPARK-22954][SQL] Removed some extraneous whitespace.

commit 4c8645623f3b89c9f7b1bc7809c6b9f5a95d2389
Author: Suchith J N <su...@...>
Date:   2018-01-30T03:56:43Z

    [SPARK-22954][SQL] Add test case to make sure that calling analyze partition on view throws AnalyzeException telling that it isn't supported on views.

----


---

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


[GitHub] spark pull request #20177: [SPARK-22954][SQL] Fix the exception thrown by An...

Posted by jiangxb1987 <gi...@git.apache.org>.
Github user jiangxb1987 commented on a diff in the pull request:

    https://github.com/apache/spark/pull/20177#discussion_r162746808
  
    --- Diff: sql/core/src/main/scala/org/apache/spark/sql/execution/command/AnalyzeTableCommand.scala ---
    @@ -31,9 +31,9 @@ case class AnalyzeTableCommand(
     
       override def run(sparkSession: SparkSession): Seq[Row] = {
         val sessionState = sparkSession.sessionState
    -    val db = tableIdent.database.getOrElse(sessionState.catalog.getCurrentDatabase)
    -    val tableIdentWithDB = TableIdentifier(tableIdent.table, Some(db))
    -    val tableMeta = sessionState.catalog.getTableMetadata(tableIdentWithDB)
    +    val db = tableIdent.database
    +    val tableIdentWithDB = TableIdentifier(tableIdent.table, db)
    +    val tableMeta = sessionState.catalog.getTempViewOrPermanentTableMetadata(tableIdentWithDB)
    --- End diff --
    
    Wouldn't this fail if we have a table that neglect the current database in tableIdent?


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    Can one of the admins verify this patch?


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

Posted by suchithjn225 <gi...@git.apache.org>.
Github user suchithjn225 commented on the issue:

    https://github.com/apache/spark/pull/20177
  
    I did't understand why the build is getting killed. 


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    **[Test build #86791 has finished](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/86791/testReport)** for PR 20177 at commit [`4c86456`](https://github.com/apache/spark/commit/4c8645623f3b89c9f7b1bc7809c6b9f5a95d2389).
     * This patch passes all tests.
     * This patch merges cleanly.
     * This patch adds no public classes.


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

Posted by cloud-fan <gi...@git.apache.org>.
Github user cloud-fan commented on the issue:

    https://github.com/apache/spark/pull/20177
  
    can you fix the test?


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    Test PASSed.
    Refer to this link for build results (access rights to CI server needed): 
    https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/90807/
    Test PASSed.


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    **[Test build #86424 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/86424/testReport)** for PR 20177 at commit [`0e873e5`](https://github.com/apache/spark/commit/0e873e5fcfe0858d869d9cb9cf63597c6746b734).


---

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


[GitHub] spark pull request #20177: [SPARK-22954][SQL] Fix the exception thrown by An...

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

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


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

Posted by gatorsmile <gi...@git.apache.org>.
Github user gatorsmile commented on the issue:

    https://github.com/apache/spark/pull/20177
  
    ok to test


---

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


[GitHub] spark pull request #20177: [SPARK-22954][SQL] Fix the exception thrown by An...

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

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


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    Merged build finished. Test PASSed.


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    Merged build finished. Test PASSed.


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    Can one of the admins verify this patch?


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

Posted by jiangxb1987 <gi...@git.apache.org>.
Github user jiangxb1987 commented on the issue:

    https://github.com/apache/spark/pull/20177
  
    We shall also update for `AnalyzePartitionCommand` and `AnalyzeColumnCommand`.


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

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


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

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


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

Posted by suchithjn225 <gi...@git.apache.org>.
Github user suchithjn225 commented on the issue:

    https://github.com/apache/spark/pull/20177
  
    The error message
    ```
    scala> sql("ANALYZE TABLE names COMPUTE STATISTICS")
    
    org.apache.spark.sql.AnalysisException: ANALYZE TABLE is not supported on views.;
      at org.apache.spark.sql.execution.command.AnalyzeTableCommand.run(AnalyzeTableCommand.scala:38)
      at org.apache.spark.sql.execution.command.ExecutedCommandExec.sideEffectResult$lzycompute(commands.scala:70)
      at org.apache.spark.sql.execution.command.ExecutedCommandExec.sideEffectResult(commands.scala:68)
      at org.apache.spark.sql.execution.command.ExecutedCommandExec.executeCollect(commands.scala:79)
      at org.apache.spark.sql.Dataset$$anonfun$6.apply(Dataset.scala:186)
      at org.apache.spark.sql.Dataset$$anonfun$6.apply(Dataset.scala:186)
      at org.apache.spark.sql.Dataset$$anonfun$51.apply(Dataset.scala:3243)
      at org.apache.spark.sql.execution.SQLExecution$.withNewExecutionId(SQLExecution.scala:77)
      at org.apache.spark.sql.Dataset.withAction(Dataset.scala:3242)
      at org.apache.spark.sql.Dataset.<init>(Dataset.scala:186)
      at org.apache.spark.sql.Dataset$.ofRows(Dataset.scala:71)
      at org.apache.spark.sql.SparkSession.sql(SparkSession.scala:638)
    
    ```


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    Test PASSed.
    Refer to this link for build results (access rights to CI server needed): 
    https://amplab.cs.berkeley.edu/jenkins//job/SparkPullRequestBuilder/86791/
    Test PASSed.


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

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


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

Posted by jiangxb1987 <gi...@git.apache.org>.
Github user jiangxb1987 commented on the issue:

    https://github.com/apache/spark/pull/20177
  
    Could you also add test cases that cover ANALYZE PARTITION and ANALYZE COLUMN queries?


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

Posted by suchithjn225 <gi...@git.apache.org>.
Github user suchithjn225 commented on the issue:

    https://github.com/apache/spark/pull/20177
  
    Done.


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    Can one of the admins verify this patch?


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    Merged build finished. Test FAILed.


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    Merged build finished. Test FAILed.


---

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


[GitHub] spark issue #20177: [SPARK-22954][SQL] Fix the exception thrown by Analyze c...

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

    https://github.com/apache/spark/pull/20177
  
    **[Test build #86791 has started](https://amplab.cs.berkeley.edu/jenkins/job/SparkPullRequestBuilder/86791/testReport)** for PR 20177 at commit [`4c86456`](https://github.com/apache/spark/commit/4c8645623f3b89c9f7b1bc7809c6b9f5a95d2389).


---

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