YannByron commented on PR #7182:
URL: https://github.com/apache/hudi/pull/7182#issuecomment-1339010794

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


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

Reply via email to