【详述】问题详细描述
基于Streamload的导入方式，表结构中包含varbinary类型，导入始终提示错误信息：Not support cast VARCHAR(1048576) to VARBINARY(1).
{
“TxnId”: 83,
“Label”: “03473eb2-61aa-4484-b674-069f6f81214a”,
“Status”: “Fail”,
“Message”: “Not support cast VARCHAR(1048576) to VARBINARY(1).”,
“NumberTotalRows”: 0,
“NumberLoadedRows”: 0,
“NumberFilteredRows”: 0,
“NumberUnselectedRows”: 0,
“LoadBytes”: 17,
“LoadTimeMs”: 10,
“BeginTxnTimeMs”: 2,
“StreamLoadPlanTimeMs”: 3,
“ReadDataTimeMs”: 0,
“WriteDataTimeMs”: 4,
“CommitAndPublishTimeMs”: 0
}
【背景】做过哪些操作？
使用StreamLoad的导入
【业务影响】
【StarRocks版本】 3.1.4-0c4b2a3
【集群规模】Docker 部署
【机器信息】Mac：M2芯片 + 32G内存
【表模型】
CREATE TABLE test_binary_2 (
id int(11) NOT NULL COMMENT “”,
test varbinary NULL COMMENT “”
) ENGINE=OLAP
PRIMARY KEY(id)
DISTRIBUTED BY HASH(id) BUCKETS 4
PROPERTIES (
“replication_num” = “1”,
“in_memory” = “false”,
“enable_persistent_index” = “true”,
“replicated_storage” = “true”,
“compression” = “LZ4”
);
【导入或者导出方式】StreamLoad 导入
1赞
