Betternan opened a new issue, #12262: URL: https://github.com/apache/pinot/issues/12262
The data in Pinot table "x1" looks like: ID and tags column are text type ID | tags --|----- 1 | ABC 2 | #ABC 3 | ABC, DEF 4 | ABC, CDE When I use following SQL: select count(distinct (ID)) from x1 where text_match(tags, '#ABC'); The query will return 4 as result, but I think the expect result would be 1, since only one record match with '#ABC'. I tried with following text_match write syntax, but it seems the same result. text_match(tags, '"#ABC"') text_match(tags, '\#ABC') text_match(tags, '\#ABC') When I use following syntax, the query returns 0. text_match(tags, '/#ABC.*/') Is there anybody meet this case? Or any solution for this? Waiting for your reply. Thanks. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org
