Stream Load JSON 数据导入
1. 库表建立
create database test;
CREATE TABLE `doris_test_sink` (
`id` int(11) NULL COMMENT "",
`number` int(11) NULL COMMENT "",
`price` decimal(12, 2) NULL COMMENT "",
`skuname` varchar(40) NULL COMMENT "",
`skudesc` varchar(200) NULL COMMENT ""
) ENGINE=OLAP
DUPLICATE KEY(`id`)
COMMENT "OLAP"
DISTRIBUTED BY HASH(`id`) BUCKETS 1
PROPERTIES (
"replication_allocation" = "tag.location.default: 1",
"in_memory" = "false",
"storage_format" = "V2",
"light_schema_change" = "true"
)
2. 数据准备
执行vim stream_load_data.json,并加入如下数据
[{
"id":1,"number":1,"price":1.1,"skuname":"n1","skudesc"

最低0.47元/天 解锁文章
468

被折叠的 条评论
为什么被折叠?



