loadData是导入数据，导入的colums为dt,name,province,os,id,pv=hll_hash(id)
分隔符是'
建表语句是
create table test_hll(
dt date,
id int,
name char(10),
province char(10),
os char(10),
pv hll hll_union
)
Aggregate KEY (dt,id,name,province,os)
distributed by hash(id) buckets 10
PROPERTIES(
"replication_num" = "1",
"in_memory"="false"
);
出现错误日志：
2025/02/06 11:36:29 - DorisStreamLoad输出.0 - ERROR (version Unknown, build 0 from 2025/02/06 11:36:23.100 by stf) : statusCode--:200
loadData=
'2025-02-06','测试 01','江苏常州','windows',' 1'
'2025-02-06','测试 01','江苏常州','windows',' 1'
'2025-02-06','测试 01','江苏常州','windows',' 1'
'2025-02-06','测试 01','江苏常州','windows',' 1'
'2025-02-06','测试 01','江苏常州','windows',' 1'
'2025-02-06','测试 01','江苏常州','windows',' 1'
'2025-02-06','测试 01','江苏常州','windows',' 1'
'2025-02-06','测试 01','江苏常州','windows',' 1'
'2025-02-06','测试 01','江苏常州','windows',' 1'
'2025-02-06','测试 01','江苏常州','windows',' 1'
'2025-02-06','测试 01','江苏常州','windows',' 1'
'2025-02-06','测试 01','江苏常州','windows',' 1'
'2025-02-06','测试 01','江苏常州','windows',' 1'
'2025-02-06','测试 01','江苏常州','windows',' 1'
'2025-02-06','测试 01','江苏常州','windows',' 1'
'2025-02-06','测试 01','江苏常州','windows',' 1'
'2025-02-06','测试 01','江苏常州','windows',' 1'
'2025-02-06','测试 01','江苏常州','windows',' 1'
'2025-02-06','测试 01','江苏常州','windows',' 1'
'2025-02-06','测试 01','江苏常州','windows',' 1'
'2025-02-06','测试 01','江苏常州','windows',' 1'
'2025-02-06','测试 01','江苏常州','windows',' 1'
----,Stream load failed,load result={
"TxnId": 1018,
"Label": "2dff999f-04cd-48f1-b365-7423b0589f16",
"Comment": "",
"TwoPhaseCommit": "false",
"Status": "Fail",
"Message": "[ANALYSIS_ERROR]TStatus: errCode = 2, detailMessage = can not cast from origin type varchar(65533) to target type=hll",
"NumberTotalRows": 0,
"NumberLoadedRows": 0,
"NumberFilteredRows": 0,
"NumberUnselectedRows": 0,
"LoadBytes": 0,
"LoadTimeMs": 0,
"BeginTxnTimeMs": 0,
"StreamLoadPutTimeMs": 2,
"ReadDataTimeMs": 0,
"WriteDataTimeMs": 0,
"ReceiveDataTimeMs": 0,
"CommitAndPublishTimeMs": 0
}
