olivermeyer commented on issue #30341: URL: https://github.com/apache/airflow/issues/30341#issuecomment-1506765727
> 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. That would require hardcoding the table structure though, wouldn't it? > Can I take this one? Please do :) -- 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]
