[ https://issues.apache.org/jira/browse/FLINK-30039?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17635677#comment-17635677 ]
Jingsong Lee commented on FLINK-30039: -------------------------------------- Hi [~StarBoy1005], if you are using static partition inserting, you can not select dt field in your sql. Example can be found in https://nightlies.apache.org/flink/flink-docs-release-1.16/docs/dev/table/sql/insert/#examples > Insert overwrite show excetion that query and insert schema do not match > ------------------------------------------------------------------------ > > Key: FLINK-30039 > URL: https://issues.apache.org/jira/browse/FLINK-30039 > Project: Flink > Issue Type: Bug > Components: Table Store > Affects Versions: 1.16.0 > Environment: Flink 1.16.0 > Reporter: Hang HOU > Priority: Critical > Attachments: screenshot-2.png, screenshot-3.png > > > After change a table's bucket num in table store,I used a insert overwrite > sql to reorganize records to new files (I guess form old orc file to the new). > Everytime if select column contains the partition column,then get the next > exception: > !screenshot-2.png! > When exclude the partition field,it do perform the overwrite. > I wonder the “EXPR$3: STRING NOT NULL” means what , -- This message was sent by Atlassian Jira (v8.20.10#820010)