Armelabdelkbir commented on issue #11803:
URL: https://github.com/apache/hudi/issues/11803#issuecomment-2301986292
1.For the first case i have a solution, is to reorder my columns, and
moving the __hoodie_is_deleted from the end of my dataset, and it works well
`cdc_hudi=> ALTER TABLE schema_testADD COLUMN department VARCHAR(100);ALTER
TABLE
cdc_hudi=> INSERT INTO schema_test (role, salary, department) VALUES
('Developer', 85000.00, 'Engineering');
INSERT 0 1`
in hudi tables we can see the new column
`|CREATE TABLE `cdc_hudi`.`schema_test_ro` (
`_hoodie_commit_time` STRING,
`_hoodie_commit_seqno` STRING,
`_hoodie_record_key` STRING,
`_hoodie_partition_path` STRING,
`_hoodie_file_name` STRING,
`_hoodie_is_deleted` BOOLEAN,
`ts_ms` BIGINT,
`op` STRING,
`id` INT,
`role` STRING,
`salary` DOUBLE,
`department` STRING)
USING hudi
OPTIONS (
`hoodie.query.as.ro.table` 'true')`
--
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]
