在doris/starrocks中创建外部表
USE simon;
CREATE EXTERNAL TABLE `soe_t1` (
`k1` bigint(20) NULL COMMENT "",
`k2` datetime NULL COMMENT "",
`k3` varchar(20) NULL COMMENT "",
`k4` varchar(100) NULL COMMENT "",
`k5` float NULL COMMENT ""
) ENGINE=ELASTICSEARCH
COMMENT "ELASTICSEARCH"
PROPERTIES (
"hosts" = "cs02:9200",
"index" = "test",
"user" = "user",
"password" = "password"
--下面几个可以不要
"transport" = "http",
"enable_docvalue_scan" = "true",
"max_docvalue_fields" = "20",
"enable_keyword_sniff" = "true"
);
--然后点等几秒就可以查询了
标签:COMMENT,starrocks,20,docvalue,ES,NULL,doris From: https://www.cnblogs.com/gouhaiping/p/17457953.html