LiBinfeng-01 opened a new issue, #42660: URL: https://github.com/apache/doris/issues/42660
### 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 show command is supported in legacy planner but not in nereids(new doris fe planner). you need implement the following use command in nereids: unsupportedShowStatement - [ ] SHOW SQL_BLOCK_RULE (FOR ruleName=identifier)? #showSqlBlockRule ShowSqlBlockRuleStmt - [ ] SHOW ROW POLICY (FOR (userIdentify - [ ] (ROLE role=identifier)))? #showRowPolicy ShowPolicyStmt - [ ] SHOW STORAGE POLICY (USING (FOR policy=identifierOrText)?)? #showStoragePolicy ShowStoragePolicyUsingStmt - [ ] SHOW STAGES #showStages ShowStageStmt - [ ] SHOW STORAGE (VAULT - [ ] VAULTS) #showStorageVault ShowStorageVaultStmt - [ ] SHOW CREATE REPOSITORY FOR identifier #showCreateRepository ShowCreateRepositoryStmt - [ ] SHOW WHITELIST #showWhitelist ShowWhiteListStmt - [ ] SHOW OPEN TABLES ((FROM - [ ] IN) database=multipartIdentifier)? wildWhere? #showOpenTables ShowOpenTableStmt - [ ] SHOW TABLE STATUS ((FROM - [ ] IN) database=multipartIdentifier)? wildWhere? #showTableStatus ShowTableStatsStmt - [ ] SHOW TABLE tableId=INTEGER_VALUE #showTableId ShowTableIdStmt - [ ] SHOW FULL? PROCESSLIST #showProcessList ShowProcesslistStmt - [ ] SHOW (GLOBAL - [ ] SESSION - [ ] LOCAL)? STATUS wildWhere? #showStatus ShowStatusStmt - [ ] SHOW FULL? TRIGGERS ((FROM - [ ] IN) database=multipartIdentifier)? wildWhere? #showTriggers ShowTriggersStmt - [ ] SHOW EVENTS ((FROM - [ ] IN) database=multipartIdentifier)? wildWhere? #showEvents ShowEventsStmt - [ ] SHOW PLUGINS #showPlugins ShowPluginsStmt - [ ] SHOW STORAGE? ENGINES #showStorageEngines ShowEnginesStmt - [ ] SHOW AUTHORS #showAuthors ShowAuthorStmt - [ ] SHOW BRIEF? CREATE TABLE name=multipartIdentifier #showCreateTable ShowCreateTableStmt - [ ] SHOW CREATE VIEW name=multipartIdentifier #showCreateView ShowCreateTableStmt - [ ] SHOW CREATE MATERIALIZED VIEW name=multipartIdentifier #showMaterializedView ShowCreateMTMVStmt - [ ] SHOW CREATE (DATABASE - [ ] SCHEMA) name=multipartIdentifier #showCreateDatabase ShowCreateDbStmt - [ ] SHOW CREATE CATALOG name=identifier #showCreateCatalog ShowCreateCatalogStmt - [ ] SHOW (DATABASES - [ ] SCHEMAS) (FROM catalog=identifier)? wildWhere? #showDatabases ShowDbStmt - [ ] SHOW DATABASE databaseId=INTEGER_VALUE #showDatabaseId ShowDbIdStmt - [ ] SHOW DATA TYPES #showDataTypes ShowDataTypesStmt - [ ] SHOW CATALOGS wildWhere? #showCatalogs ShowCatalogStmt - [ ] SHOW CATALOG name=identifier #showCatalog ShowCatalogStmt - [ ] SHOW DYNAMIC PARTITION TABLES ((FROM - [ ] IN) database=multipartIdentifier)? #showDynamicPartition ShowDynamicPartitionStmt - [ ] SHOW FULL? (COLUMNS - [ ] FIELDS) (FROM - [ ] IN) tableName=multipartIdentifier ((FROM - [ ] IN) database=multipartIdentifier)? wildWhere? #showColumns ShowColumnStmt - [ ] SHOW COLLATION wildWhere? #showCollation ShowCollationStmt - [ ] SHOW ((CHAR SET) - [ ] CHARSET) wildWhere? #showCharset ShowCharsetStmt - [ ] SHOW PROC path=STRING_LITERAL #showProc ShowProcStmt - [ ] SHOW COUNT LEFT_PAREN ASTERISK RIGHT_PAREN (WARNINGS - [ ] ERRORS) #showWaringErrorCount RESULT = new SelectStmt(list, null, null, null, null, null, null); - [ ] SHOW (WARNINGS - [ ] ERRORS) limitClause? #showWaringErrors ShowWarningStmt - [ ] SHOW LOAD WARNINGS ((((FROM - [ ] IN) database=multipartIdentifier)? wildWhere? limitClause?) - [ ] (ON url=STRING_LITERAL)) #showLoadWarings ShowLoadWarningsStmt - [ ] SHOW DELETE ((FROM - [ ] IN) database=multipartIdentifier)? #showDelete ShowDeleteStmt - [ ] SHOW DATA SKEW FROM baseTableRef #showDataSkew ShowDataSkewStmt - [ ] SHOW PARTITION partitionId=INTEGER_VALUE #showPartitionId ShowPartitionIdStmt - [ ] SHOW TABLET tabletId=INTEGER_VALUE #showTabletId ShowTableIdStmt - [ ] SHOW TABLETS BELONG tabletIds+=INTEGER_VALUE (COMMA tabletIds+=INTEGER_VALUE)* #showTabletBelong ShowTabletsBelongStmt - [ ] SHOW PROPERTY (FOR user=identifierOrText)? wildWhere? #showUserProperties ShowUserPropertyStmt - [ ] SHOW ALL PROPERTIES wildWhere? #showAllProperties ShowUserPropertyStmt - [ ] SHOW BROKER #showBroker ShowBrokerStmt - [ ] SHOW BACKENDS #showBackends ShowBackendsStmt - [ ] SHOW TRASH (ON backend=STRING_LITERAL)? #showTrash ShowTrashStmt - [ ] SHOW FRONTENDS name=identifier? #showFrontends ShowFrontendsStmt - [ ] SHOW REPOSITORIES #showRepositories ShowRepositoriesStmt - [ ] SHOW ALL? GRANTS #showGrants ShowGrantsStmt - [ ] SHOW GRANTS FOR userIdentify #showGrantsForUser ShowGrantsStmt - [ ] SHOW ROLES #showRoles ShowRolesStmt - [ ] SHOW PRIVILEGES #showPrivileges ShowPrivilegesStmt - [ ] SHOW FILE ((FROM - [ ] IN) database=multipartIdentifier)? #showSmallFiles ShowSmallFilesStmt - [ ] SHOW (KEY - [ ] KEYS - [ ] INDEX - [ ] INDEXES) (FROM - [ ]IN) tableName=multipartIdentifier ((FROM - [ ] IN) database=multipartIdentifier)? #showIndex ShowIndexStmt - [ ] SHOW QUERY PROFILE queryIdPath=STRING_LITERAL #showQueryProfile ShowQueryProfileStmt - [ ] SHOW LOAD PROFILE loadIdPath=STRING_LITERAL #showLoadProfile ShowLoadProfileStmt - [ ] SHOW ENCRYPTKEYS ((FROM - [ ] IN) database=multipartIdentifier)? wildWhere? #showEncryptKeys ShowEncryptKeysStmt - [ ] SHOW SYNC JOB ((FROM - [ ] IN) database=multipartIdentifier)? #showSyncJob ShowSyncJobStmt - [ ] SHOW TABLE CREATION ((FROM - [ ] IN) database=multipartIdentifier)? wildWhere? #showTableCreation ShowTableCreationStmt - [ ] SHOW LAST INSERT #showLastInsert ShowLastInsertStmt - [ ] SHOW CREATE MATERIALIZED VIEW mvName=identifier ON tableName=multipartIdentifier #showCreateMaterializedView ShowCreateMaterializedViewStmt - [ ] SHOW QUERY STATS ((FOR database=identifier) - [ ] (FROM tableName=multipartIdentifier (ALL VERBOSE?)?))? #showQueryStats ShowQueryStatsStmt - [ ] SHOW (CLUSTERS - [ ] (COMPUTE GROUPS)) #showClusters ShowClusterStmt - [ ] SHOW CONVERT_LSC ((FROM - [ ] IN) database=multipartIdentifier)? #showConvertLsc ShowConvertLSCStmt - [ ] SHOW REPLICA DISTRIBUTION FROM baseTableRef #showREplicaDistribution ShowReplicaDistributionStmt - [ ] SHOW TABLET STORAGE FORMAT VERBOSE? #showTabletStorageFormat ShowTabletStorageFormatStmt - [ ] SHOW TABLET DIAGNOSIS tabletId=INTEGER_VALUE #showDiagnoseTablet DiagnoseTabletStmt ### 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: commits-unsubscr...@doris.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
