Hello experts. We are trying to execute an insert command with less columns than the target table:

Insert into table_name( col1, col2, col10)

Select col1, col2, col10

from table_name2

However the above fails with:

Error in SQL statement: DeltaAnalysisException: Column col3 is not specified in INSERT

Do you know if INSERT using a subquery requires all the columns of the target table specified?