beyond1920 opened a new pull request, #8597:
URL: https://github.com/apache/hudi/pull/8597

   ### Change Logs
   
   In #8499 , a user has raised a very reasonable requirement:
   
   Currently, if the insert statement specifies less columns than the target 
table size, the following exception will be thrown:
   
   > Exception in thread "main" java.lang.AssertionError: assertion failed: The 
number of insert assignments[3] must equal to the targetTable field size[4]
   
   For a wide table that has 1000 columns, the user is required to specify all 
the columns with default values null to avoid this exception. Can we support 
partial insert in merge into (default to null if not specified) command so the 
developer can maintain clean SQL statement.
   
   E.g. Delta merge command has already supported this.
   
![image](https://user-images.githubusercontent.com/1525333/235104174-20813955-df97-404c-a641-12306774528b.png)
   
   https://docs.databricks.com/sql/language-manual/delta-merge-into.html
   
   This PR aims to support this feature.
   
   ### Impact
   
   NA
   
   ### Risk level (write none, low medium or high below)
   
   NA
   
   ### Documentation Update
   
   NA
   
   ### Contributor's checklist
   
   - [ ] Read through [contributor's 
guide](https://hudi.apache.org/contribute/how-to-contribute)
   - [ ] Change Logs and Impact were stated clearly
   - [ ] Adequate tests were added if applicable
   - [ ] CI passed
   


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