| CREATE EXTERNAL TABLE IF NOT EXISTS `orc_all_types`( |
| `tinyint_col` tinyint, |
| `smallint_col` smallint, |
| `int_col` int, |
| `bigint_col` bigint, |
| `boolean_col` boolean, |
| `float_col` float, |
| `double_col` double, |
| `string_col` string, |
| `binary_col` binary, |
| `timestamp_col` timestamp, |
| `decimal_col` decimal(12,4), |
| `char_col` char(50), |
| `varchar_col` varchar(50), |
| `date_col` date, |
| `list_double_col` array<double>, |
| `list_string_col` array<string>) |
| PARTITIONED BY ( |
| `p1_col` string, |
| `p2_col` 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/orc_all_types'; |
| |
| msck repair table orc_all_types; |
| |
| |
| drop table if exists hive_orc_next_batch_test; |
| CREATE TABLE hive_orc_next_batch_test (id INT, data STRING) STORED AS ORC; |
| INSERT INTO hive_orc_next_batch_test VALUES |
| (1, '{"age":25,"city":"beijing","score":88}'), |
| (2, '{"age":30,"city":"shanghai","score":92}'); |
| |
