[GitHub] [hudi] melin edited a comment on issue #4797: [SUPPORT] Change Data Capture(CDC) for hudi

[GitBox <gi...@apache.org>]

melin edited a comment on issue #4797:
URL: https://github.com/apache/hudi/issues/4797#issuecomment-1037035377


   Spark PR： https://issues.apache.org/jira/browse/HUDI-2941
   See databricks delta support for Spark SQL：https://docs.databricks.com/delta/delta-change-data-feed.html
   ```sql
   -- version as ints or longs e.g. changes from version 0 to 10
   SELECT * FROM table_changes('tableName', 0, 10)
   
   -- timestamp as string formatted timestamps
   SELECT * FROM table_changes('tableName', '2021-04-21 05:45:46', '2021-05-21 12:00:00')
   
   -- providing only the startingVersion/timestamp
   SELECT * FROM table_changes('tableName', 0)
   
   -- database/schema names inside the string for table name, with backticks for escaping dots and special characters
   SELECT * FROM table_changes('dbName.`dotted.tableName`', '2021-04-21 06:45:46' , '2021-05-21 12:00:00')
   
   -- path based tables
   SELECT * FROM table_changes_by_path('\path', '2021-04-21 05:45:46')
   ```


-- 
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-unsubscribe@hudi.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org