CREATE TABLE kinesis_table ( id BIGINT, name STRING, partitionId STRING METADATA FROM 'partition' -- use different column name for metadata 'partition' ) WITH ( 'connector' = 'kinesis', 'value.format' = 'avro' )
SELECT * FROM kinesis_table;
-- Partition is a computedpersisted column, therefore it cannotcan be written to. Statements like below will fail: INSERT INTO kinesis_table VALUES (1, "ABC", "shard-0000") |