LiBinfeng-01 opened a new issue, #42631:
URL: https://github.com/apache/doris/issues/42631

   ### Search before asking
   
   - [X] I had searched in the 
[issues](https://github.com/apache/doris/issues?q=is%3Aissue) and found no 
similar issues.
   
   
   ### Description
   
   stats command is supported in legacy planner but not in nereids(new doris fe 
planner). you need implement the following use command in nereids:
   
   unsupportedStatsStatement
   - [ ] ANALYZE TABLE name=multipartIdentifier partitionSpec?
       columns=identifierList? (WITH analyzeProperties)* propertyClause?       
#analyzeTable AnalyzeTblStmt
   - [ ] ANALYZE DATABASE name=multipartIdentifier
       (WITH analyzeProperties)* propertyClause?                               
#analyzeDatabase AnalyzeDBStmt
   - [ ] ALTER TABLE name=multipartIdentifier SET STATS
       LEFT_PAREN propertyItemList RIGHT_PAREN partitionSpec?                  
#alterTableStats AlterTableStatsStmt
   - [ ] ALTER TABLE name=multipartIdentifier (INDEX indexName=identifier)?
       MODIFY COLUMN columnName=identifier
       SET STATS LEFT_PAREN propertyItemList RIGHT_PAREN partitionSpec?        
#alterColumnStats AlterColumnStatsStmt
   - [ ] DROP STATS tableName=multipartIdentifier
       columns=identifierList? partitionSpec?                                  
#dropStats DropStatsStmt
   - [ ] DROP CACHED STATS tableName=multipartIdentifier                        
   #dropCachedStats DropCachedStatsStmt
   - [ ] DROP EXPIRED STATS                                                     
   #dropExpiredStats DropStatsStmt
   - [ ] DROP ANALYZE JOB INTEGER_VALUE                                         
   #dropAanalyzeJob DropAnalyzeJobStmt
   - [ ] KILL ANALYZE jobId=INTEGER_VALUE                                       
   #killAnalyzeJob KillAnalysisJobStmt
   - [ ] SHOW TABLE STATS tableName=multipartIdentifier
       partitionSpec? columnList=identifierList?                               
#showTableStats ShowTableStatsStmt
   - [ ] SHOW TABLE STATS tableId=INTEGER_VALUE                                 
   #showTableStats ShowTableStatsStmt
   - [ ] SHOW INDEX STATS tableName=multipartIdentifier indexId=identifier      
   #showIndexStats ShowTableStatsStmt
   - [ ] SHOW COLUMN CACHED? STATS tableName=multipartIdentifier
       columnList=identifierList? partitionSpec?                               
#showColumnStats ShowColumnStatsStmt
   - [ ] SHOW COLUMN HISTOGRAM tableName=multipartIdentifier
       columnList=identifierList                                               
#showColumnHistogramStats ShowColumnHistStmt
   - [ ] SHOW ANALYZE TASK STATUS jobId=INTEGER_VALUE                           
   #showAnalyzeTask ShowAnalyzeTaskStatus
   
   ### Solution
   
   _No response_
   
   ### Are you willing to submit PR?
   
   - [ ] Yes I am willing to submit a PR!
   
   ### Code of Conduct
   
   - [X] I agree to follow this project's [Code of 
Conduct](https://www.apache.org/foundation/policies/conduct)
   


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

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to