The world's fastest open query engine for sub-second analytics both on and off the data lakehouse. With the flexibility to support nearly any scenario, StarRocks provides best-in-class performance for multi-dimensional analytics, real-time analytics, and ad-hoc queries. A Linux Foundation project.
样本数据
设置 conditions 为 json 后
"conditions" : "G998||Other specified disorders of nervous system in diseases classified elsewhere,",
"conditions" : "4||Measurement and Monitoring,",
设置 conditions 为 string 后
ERROR 1064 (HY000): Expected value of type: VARCHAR; but found type: Array; Document slice is : ["Myopia"]
1.Create ES External Table
2.Execute Query
SELECT
company_ids, conditions FROM t2
WHERE
array_contains(conditions, '4||Measurement and Monitoring,')
LIMIT 20
;
或
SELECT
company_ids
,conditions
FROM
t2, unnest(conditions) AS unnest
WHERE
unnest in ('4||Measurement and Monitoring,')
LIMIT 20
;
haoranchuixue
commented
1 month ago
Steps to reproduce the behavior (Required)
样本数据 设置 conditions 为 json 后 "conditions" : "G998||Other specified disorders of nervous system in diseases classified elsewhere,", "conditions" : "4||Measurement and Monitoring,", 设置 conditions 为 string 后 ERROR 1064 (HY000): Expected value of type: VARCHAR; but found type: Array; Document slice is : ["Myopia"]
1.Create ES External Table 2.Execute Query SELECT company_ids, conditions FROM t2 WHERE array_contains(conditions, '4||Measurement and Monitoring,') LIMIT 20 ; 或 SELECT company_ids ,conditions FROM t2, unnest(conditions) AS unnest WHERE
unnest in ('4||Measurement and Monitoring,') LIMIT 20 ;
Expected behavior (Required)
CN does not crash and can query data normally
Real behavior (Required)
StarRocks version (Required)
3.2.8-759cc78