i am trying to insert into a table with an identity column using a select query.
However, if i include the identity column or ignore the identity column in my insert it throws errors. Is thee a way to insert into select * from a table if the insert table has an identity column?
%sql
CREATE OR REPLACE TABLE demo (
id BIGINT GENERATED ALWAYS AS IDENTITY,
product_type STRING,
sales BIGINT
);
%sql
insert into demo_test
SELECT id,product_type, sales from demo
AnalysisException: Providing values for GENERATED ALWAYS AS IDENTITY column id is not supported.
%sql
insert into demo_test
SELECT product_type, sales from demo
nalysisException: Cannot write to 'spark_catalog.default.demo_test', not enough data columns; target table has 3 column(s) but the inserted data has 2 column(s)
