THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
We propose add the following syntax for REPLACE TABLE AS SELECT
statement:
Code Block | ||
---|---|---|
| ||
REPLACE TABLE table_identifier [( [ < physical_column_definition >, ... ] [ < table_constraint >, ... ])] [ COMMENT table_comment ] [ PARTITIONED BY ( col_name1, col_name3, ...) ] [ WITH ( key1=val1, key2=val2, ... ) ] AS <table subquery> <physical_column_definition>: column_name column_type [ <column_constraint> ] [COMMENT column_comment] <column_constraint>: [CONSTRAINT constraint_name] PRIMARY KEY NOT ENFORCED <table_constraint>: [CONSTRAINT constraint_name] PRIMARY KEY (column_name, ...) NOT ENFORCED |
...