rangareddy commented on issue #13221:
URL: https://github.com/apache/hudi/issues/13221#issuecomment-2834535663
Hi @Maplejw
I am able to replicate this issue using the sample code provided below.
```sql
CREATE TABLE hudi_orc_test_table1 (
`id` BIGINT,
`name` STRING,
`age` INT,
`salary` DOUBLE
) USING hudi
PARTITIONED BY (age)
LOCATION 's3a://warehouse/hudi_orc_test_table1'
TBLPROPERTIES (
'hoodie.base.file.format' = 'ORC',
'hoodie.table.base.file.format' = 'ORC',
'type' = 'cow');
```
```sql
INSERT INTO hudi_orc_test_table1 (id, name, age, salary) VALUES (1, 'ranga',
34, 10000),(2, 'nishanth', 7, 300000);
SELECT * FROM hudi_orc_test_table1;
```
The workaround for this issue is to specify only the
**hoodie.base.file.format** parameter, and we are also raising a Hudi upstream
JIRA ticket to fix this issue permanently.
```sql
CREATE TABLE hudi_orc_test_table2 (
`id` BIGINT,
`name` STRING,
`age` INT,
`salary` DOUBLE
) USING hudi
PARTITIONED BY (age)
LOCATION 's3a://warehouse/hudi_orc_test_table2'
TBLPROPERTIES (
'hoodie.base.file.format' = 'ORC',
'type' = 'cow');
INSERT INTO hudi_orc_test_table2 (id, name, age, salary) VALUES (1, 'ranga',
34, 10000),(2, 'nishanth', 7, 300000);
SELECT * FROM hudi_orc_test_table2;
_hoodie_commit_time _hoodie_commit_seqno _hoodie_record_key
_hoodie_partition_path _hoodie_file_name id name salary age
20250428090044008 20250428090044008_0_0 20250428090044008_1_0 age=7
c50e52d7-c340-4c22-8134-829a4d8340a6-0_0-33-46_20250428090044008.parquet 2
nishanth 300000.0 7
20250428090044008 20250428090044008_1_0 20250428090044008_0_0 age=34
5abc55b6-d767-40e4-a26b-ddbe933d0013-0_1-33-47_20250428090044008.parquet 1
ranga 10000.0 34
Time taken: 0.763 seconds, Fetched 2 row(s)
```
--
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]
