[GitHub] [spark] maropu opened a new pull request #24200: [SPARK-27266][SQL] Support ANALYZE TABLE to collect tables stats for cached catalog views

[GitBox <gi...@apache.org>]

maropu opened a new pull request #24200: [SPARK-27266][SQL] Support ANALYZE TABLE to collect tables stats for cached catalog views
URL: https://github.com/apache/spark/pull/24200
 
 
   ## What changes were proposed in this pull request?
   The current master doesn't support ANALYZE TABLE to collect tables stats for catalog views even if they are cached as follows;
   
   ```
   scala> sql(s"CREATE VIEW v AS SELECT 1 c")
   scala> sql(s"CACHE LAZY TABLE v")
   scala> sql(s"ANALYZE TABLE v COMPUTE STATISTICS")
   org.apache.spark.sql.AnalysisException: ANALYZE TABLE is not supported on views.;
   ...
   ```
   
   Since SPARK-25196 has supported to an ANALYZE command to collect column statistics for cached catalog view, we could support table stats, too.
   
   ## How was this patch tested?
   Added tests in `StatisticsCollectionSuite` and `InMemoryColumnarQuerySuite`.

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

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