rohan472000 commented on issue #30341:
URL: https://github.com/apache/airflow/issues/30341#issuecomment-1490677112
One possible solution is to modify the CREATE TABLE statement that the
operator uses to create the temporary table, see below-
>>> CREATE TABLE #temp(
column1 datatype1 DEFAULT default_value1,
column2 datatype2 DEFAULT default_value2,
column3 datatype3 DEFAULT default_value3,
...
) LIKE mytable.temp;
With this modification, the temporary table will include the default values
for each column, and you should be able to copy data into it without
encountering the "NOT NULL column without DEFAULT must be included in column
list" error.
--
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]
