[
https://issues.apache.org/jira/browse/HUDI-8912?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Y Ethan Guo updated HUDI-8912:
------------------------------
Description:
This INSERT statement fails on Hudi table while succeeds on parquet table in
Spark 3.5.
{code:java}
CREATE TABLE hudi_table (
id int,
dt string,
name string,
price double,
ts long
) using hudi
tblproperties (
type = 'mor',
primaryKey = 'id'
)
location '/tmp/path'
INSERT INTO hudi_table (id, dt, ts)
select id, dt, ts from (SELECT 1 as id, '2025-01-04' as dt, 4000 as ts){code}
> Support INSERT SQL with a subset of columns and select from in Spark 3.5
> ------------------------------------------------------------------------
>
> Key: HUDI-8912
> URL: https://issues.apache.org/jira/browse/HUDI-8912
> Project: Apache Hudi
> Issue Type: Bug
> Reporter: Y Ethan Guo
> Priority: Major
>
> This INSERT statement fails on Hudi table while succeeds on parquet table in
> Spark 3.5.
> {code:java}
> CREATE TABLE hudi_table (
> id int,
> dt string,
> name string,
> price double,
> ts long
> ) using hudi
> tblproperties (
> type = 'mor',
> primaryKey = 'id'
> )
> location '/tmp/path'
> INSERT INTO hudi_table (id, dt, ts)
> select id, dt, ts from (SELECT 1 as id, '2025-01-04' as dt, 4000 as ts){code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)