您好 ,
我们非常希望doris拥有any \ match \ equals 函数,请问有没有?
value 的数据是, "123,ab,32"
any是, select any(value , '123,ab2') from base_metadata , 任意一个,true。
match是,select match是(value , 'ab2,ba2') from base_metadata , 子集,false。
equals,select equals(value , '32,123,ab') from base_metadata , 等于,true。
CREATE TABLE
`base_metadata` (
`id` bigint(20) NOT NULL COMMENT '主键',
`gmt_create` datetime NULL COMMENT '创建时间',
`gmt_modified` datetime NULL COMMENT '修改时间',
`value` text NULL COMMENT 'value'
) ENGINE = OLAP UNIQUE KEY(`id`) COMMENT '数据字典' DISTRIBUTED BY HASH(`id`) BUCKETS 1 PROPERTIES (
"replication_allocation" = "tag.location.default: 3",
"is_being_synced" = "false",
"storage_format" = "V2",
"enable_unique_key_merge_on_write" = "true",
"light_schema_change" = "true",
"disable_auto_compaction" = "false",
"enable_single_replica_compaction" = "false"
);