dongsilun commented on issue #5193:
URL: https://github.com/apache/seatunnel/issues/5193#issuecomment-1659974343
Hive table
`create external table hive2doris
(id int, str1 string, str2 string, str3 string
, str4 string, str5 string, str6 string, str7 string
, str8 string, str9 string, str10 string, num1 int
, num2 int, num3 int, num4 int, num5 int, num6 int
, num7 int, num8 int, num9 int)
stored as orc
location '/hive_test/hive2doris';`
doris table
`CREATE TABLE `hive2doris` (
`id` int(10) NOT NULL,
`str1` varchar(100) NOT NULL,`str2` varchar(100) NOT NULL,`str3`
varchar(100) NOT NULL,
`str4` varchar(100) NOT NULL,`str5` varchar(100) NOT NULL,`str6`
varchar(100) NOT NULL,
`str7` varchar(100) NOT NULL,`str8` varchar(100) NOT NULL,`str9`
varchar(100) NOT NULL,
`str10` varchar(100) NOT NULL,`num1` int(10) NOT NULL,`num2` int(10) NOT
NULL,`num3` int(10) NOT NULL,
`num4` int(10) NOT NULL,`num5` int(10) NOT NULL,`num6` int(10) NOT
NULL,`num7` int(10) NOT NULL,
`num8` int(10) NOT NULL,`num9` int(10) NOT NULL
) ENGINE=OLAP
DUPLICATE KEY(`id`, `str1`)
COMMENT 'OLAP'
DISTRIBUTED BY HASH(`id`) BUCKETS 10
PROPERTIES (
"replication_allocation" = "tag.location.default: 3"
);`
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
