| CREATE TABLE `partition_table`( |
| `l_orderkey` int, |
| `l_partkey` int, |
| `l_suppkey` int, |
| `l_linenumber` int, |
| `l_quantity` decimal(12,2), |
| `l_extendedprice` decimal(12,2), |
| `l_discount` decimal(12,2), |
| `l_tax` decimal(12,2), |
| `l_returnflag` string, |
| `l_linestatus` string, |
| `l_shipdate` date, |
| `l_commitdate` date, |
| `l_receiptdate` date, |
| `l_shipinstruct` string, |
| `l_shipmode` string, |
| `l_comment` string) |
| partitioned by (nation string, city 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/parquet/partition_table' |
| TBLPROPERTIES ( |
| 'transient_lastDdlTime'='1661955829'); |
| |
| msck repair table partition_table; |
| |
| |
