scxwhite commented on PR #7182: URL: https://github.com/apache/hudi/pull/7182#issuecomment-1339074967
> @scxwhite Spark support Table-valued Function: https://spark.apache.org/docs/latest/sql-ref-syntax-qry-select-tvf.html. > > Maybe Hudi can extend this syntax to implement query of hudi table in different query mode. SQL looks like this: > > ``` > // query snapshot table > select id, name, price, ts from hudi_tvf("tableName1', "snapshot", "instant1"); > > // query incremental table > select id, name, price, ts from hudi_tvf("tableName1', "incremental", "instant1", "instant2"); > > // query read_optimized table > select id, name, price, ts from hudi_tvf("tableName1', "read_optimized"); > ``` > > In it, `hudi_tvf` is a table-valued function we need to define. @YannByron Thanks for your feedback, I will revise it as soon as possible. -- 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]
