[GitHub] [spark] wangyum commented on pull request #30648: [SPARK-33687][SQL] Support analyze all tables in a specific database

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

wangyum commented on pull request #30648:
URL: https://github.com/apache/spark/pull/30648#issuecomment-741580560


   > Looks a nice feature. Btw, (just a question) Any system you referred to for defining this syntax?
   
   PostgreSQL syntax is:
   ```
   ANALYZE [ ( option [, ...] ) ] [ table_and_columns [, ...] ]
   ANALYZE [ VERBOSE ] [ table_and_columns [, ...] ]
   
   where option can be one of:
   
       VERBOSE [ boolean ]
       SKIP_LOCKED [ boolean ]
   
   and table_and_columns is:
   
       table_name [ ( column_name [, ...] ) ]
   ```
   
   This syntax (` ANALYZE TABLES ((FROM | IN) multipartIdentifier)? COMPUTE STATISTICS (identifier)?`) is from
   https://github.com/apache/spark/blob/1a163972331ad4d173e193b48096edf85f5f7759/sql/catalyst/src/main/antlr4/org/apache/spark/sql/catalyst/parser/SqlBase.g4#L135-L136
   and 
   https://github.com/apache/spark/blob/1a163972331ad4d173e193b48096edf85f5f7759/sql/catalyst/src/main/antlr4/org/apache/spark/sql/catalyst/parser/SqlBase.g4#L200-L201


----------------------------------------------------------------
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



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