ad1happy2go commented on issue #9042:
URL: https://github.com/apache/hudi/issues/9042#issuecomment-1606711938

   @dht7 Able to reproduce this issue. 
   
   
   Root cause was the source table had column nullable false but the hudi table 
had it true.
   
   Source table 
   <img width="400" alt="image" 
src="https://github.com/apache/hudi/assets/63430370/94c2a5bc-f601-49b7-8791-b739d0994429";>
   
   Target Table
   <img width="481" alt="image" 
src="https://github.com/apache/hudi/assets/63430370/6f658d8a-3c64-481b-bb82-e9c18ec94925";>
   
   
   Spark SQL Code - 
   ```
   create database test_database1;
   create table test_database1.source_table
   as select 1 as id, array(1,2,3) as array_column1;
   create table test_database1.test_table using hudi options (type="cow", 
primaryKey='id', hoodie.table.name="test_table")
   select id, array_column1 from test_database1.source_table;
   insert overwrite table test_database1.test_table select id, array_column1 
FROM test_database1.source_table;
   ```


-- 
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]

Reply via email to