[ 
https://issues.apache.org/jira/browse/FLINK-28939?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

godfrey he updated FLINK-28939:
-------------------------------
    Description: 
This issue aims to verify FLIP-247: 
https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=217386481

We can verify it in SQL client after we build the flink-dist package. 

1. create a partition table and a non-partition table (with/without compute 
column/metadata column, with different columns)
2. verify the different statements, please refer to the FLIP doc examples
3. verify the result in catalog. Currently, {{describe extended}} statement 
does not support show the statistics in catalog, we should write some code to 
get the statistics from catalog, or we can use hive cli if the catalog is hive 
catalog
4. verify the unsupported cases,
4.1  analyze non-existed table
4.2 analyze view
4.3 analyze a partition table with non-existed partition
4.4. analyze a non-partition table with a partition
4.5. analyze a non-existed column
4.6. analyze a computed column
4.6. analyze a metadata column


> Release Testing: Verify FLIP-241 ANALYZE TABLE
> ----------------------------------------------
>
>                 Key: FLINK-28939
>                 URL: https://issues.apache.org/jira/browse/FLINK-28939
>             Project: Flink
>          Issue Type: Sub-task
>          Components: Table SQL / API, Table SQL / Planner
>    Affects Versions: 1.16.0
>            Reporter: godfrey he
>            Priority: Blocker
>              Labels: release-testing
>             Fix For: 1.16.0
>
>
> This issue aims to verify FLIP-247: 
> https://cwiki.apache.org/confluence/pages/viewpage.action?pageId=217386481
> We can verify it in SQL client after we build the flink-dist package. 
> 1. create a partition table and a non-partition table (with/without compute 
> column/metadata column, with different columns)
> 2. verify the different statements, please refer to the FLIP doc examples
> 3. verify the result in catalog. Currently, {{describe extended}} statement 
> does not support show the statistics in catalog, we should write some code to 
> get the statistics from catalog, or we can use hive cli if the catalog is 
> hive catalog
> 4. verify the unsupported cases,
> 4.1  analyze non-existed table
> 4.2 analyze view
> 4.3 analyze a partition table with non-existed partition
> 4.4. analyze a non-partition table with a partition
> 4.5. analyze a non-existed column
> 4.6. analyze a computed column
> 4.6. analyze a metadata column



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to