| CREATE TABLE `test_string_dict_filter_orc`( |
| `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.orc.OrcSerde' |
| STORED AS INPUTFORMAT |
| 'org.apache.hadoop.hive.ql.io.orc.OrcInputFormat' |
| OUTPUTFORMAT |
| 'org.apache.hadoop.hive.ql.io.orc.OrcOutputFormat' |
| LOCATION |
| '/user/doris/preinstalled_data/orc_table/test_string_dict_filter_orc'; |
| |
| msck repair table test_string_dict_filter_orc; |
| |
| |