There's a discussion in dev@ mailing list to point out ambiguous syntaxes for CREATE TABLE DDL. This issue tracks the efforts to resolve the root issue via unifying the create table syntax.
We should ensure the new "single" create table syntax is very deterministic to both devs and end users.
This work also includes how to pass the extra CREATE TABLE information(from the Hive tyle CREATE TABLE) to the v2 catalog:
1. turn the Hive serde info to table properties with `option.` prefix.
2. add a new v2 table option `external` to indicate CREATE EXTERNAL TABLE.