| CREATE EXTERNAL TABLE `delta_encoding_optional_column`( |
| c_customer_sk bigint, |
| c_current_cdemo_sk bigint, |
| c_current_hdemo_sk bigint, |
| c_current_addr_sk bigint, |
| c_first_shipto_date_sk bigint, |
| c_first_sales_date_sk bigint, |
| c_birth_year bigint, |
| c_customer_id string, |
| c_salutation string, |
| c_first_name string, |
| c_last_name string, |
| c_preferred_cust_flag string, |
| c_birth_country string |
| ) |
| ROW FORMAT SERDE |
| 'org.apache.hadoop.hive.ql.io.parquet.serde.ParquetHiveSerDe' |
| STORED AS INPUTFORMAT |
| 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetInputFormat' |
| OUTPUTFORMAT |
| 'org.apache.hadoop.hive.ql.io.parquet.MapredParquetOutputFormat' |
| LOCATION |
| '/user/doris/preinstalled_data/different_types_parquet/delta_encoding_optional_column' |
| TBLPROPERTIES ( |
| 'transient_lastDdlTime'='1661955829'); |
| |
| msck repair table delta_encoding_optional_column; |
| |
| |
