ad1happy2go commented on issue #8757: URL: https://github.com/apache/hudi/issues/8757#issuecomment-1554253250
@eyjian I was able to make it work fine with slight modification in inserts. ``` > insert into t21 values (CURRENT_TIMESTAMP,1001,1,null,null,null,null,20230101); spark-sql> select * from t21; 20230519141943463 20230519141943463_1_0 1001 ds=20230101 00000001-8a36-4ac6-89a6-f0906b1285c7-0_1-105-103_20230519141943463.parquet 2023-05-19 14:19:43.302 1001 1 NULL NULL NULL NULL 20230101 insert into t21 values (CURRENT_TIMESTAMP,1001,null,1,null,null,null,20230101); spark-sql> select * from t21; 20230519142001501 20230519142001501_1_2 1001 ds=20230101 00000001-8a36-4ac6-89a6-f0906b1285c7-0 2023-05-19 14:20:01.413 1001 1 1 NULL NULL NULL 20230101 Time taken: 0.562 seconds, Fetched 1 row(s) ``` I am not sure why the insert queries you sent is not working for me. I am using spark 3.3 with hudi 0.13.0. ``` spark-sql> insert into t21 (ds,ut,pk,f0) values (20230101,CURRENT_TIMESTAMP,1001,1); Error in query: Cannot write to 'test_db.t21', not enough data columns: Table columns: 'ut', 'pk', 'f0', 'f1', 'f2', 'f3', 'f4', 'ds' Data columns: 'col1', 'col2', 'col3', 'col4' ``` -- 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]
