为了更快的定位您的问题,请提供以下信息,谢谢
【详述】问题详细描述
【背景】做过哪些操作?
【业务影响】
【StarRocks版本】starrocks/allin1-ubuntu:3.1.2(docker容器)
CREATE TABLE stock_ticker (
stock_symbol varchar(65533) NULL COMMENT “”,
closing_price decimal64(8, 2) NULL COMMENT “”,
closing_date datetime NULL COMMENT “”
) ENGINE=OLAP
DUPLICATE KEY(stock_symbol)
COMMENT “OLAP”
DISTRIBUTED BY HASH(closing_date) BUCKETS 3
PROPERTIES (
“replication_num” = “3”,
“in_memory” = “false”,
“storage_format” = “DEFAULT”,
“enable_persistent_index” = “false”,
“replicated_storage” = “true”,
“compression” = “LZ4”
);
select * from (select row_number() over() as row, tab.* from (select * from stock_ticker) as tab) e where row < 1;
大于能查,小于异常,hive都能,presto都能支持该语法,sr有异常。
3.0.3版本,也有类似现象。异常打印不一致而已。
