huleilei commented on PR #33754: URL: https://github.com/apache/spark/pull/33754#issuecomment-1255956374
Hello all, I want to know what indexes are in the table. But SHOW INDEX syntax is not supported. So I think the SHOW INDEX syntax should be added in the Spark code. Please let me know if you have any thoughts. In addition, whether the index reconstruction function needs to be supported. Different data sources have different requirements. MySQL does not need to rebuild the index data. But it is supported in pg. DataSources such as delta and iceberg also need to rebuild index. So I suggest providing interfaces to support the update of index data. Thanks. eg postgresql： https://www.postgresql.org/docs/13/sql-reindex.html Thanks. `REINDEX [ ( option [, ...] ) ] { INDEX | TABLE | SCHEMA | DATABASE | SYSTEM } [ CONCURRENTLY ] name` -- 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]
