| CREATE TABLE `test_string_dict_filter_parquet`( |
| `o_orderkey` int, |
| `o_custkey` int, |
| `o_orderstatus` string, |
| `o_totalprice` decimal(15,2), |
| `o_orderdate` date, |
| `o_orderpriority` string, |
| `o_clerk` string, |
| `o_shippriority` int, |
| `o_comment` 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_table/test_string_dict_filter_parquet'; |
| |
| msck repair table test_string_dict_filter_parquet; |
| |
