Shanmugavel-J opened a new issue, #56995:
URL: https://github.com/apache/doris/issues/56995
When executing a SELECT DISTINCT query on a table that includes **JSON** or
**VARIANT** columns, the query fails with the following error:
```
SQL Error [1105] [HY000]: errCode = 2, detailMessage = Doris hll, bitmap,
array, map, struct, jsonb, variant column must use with specific function, and
don't support filter, group by or order by. please run 'help hll' or 'help
bitmap' or 'help array' or 'help map' or 'help struct' or 'help jsonb' or 'help
variant' in your mysql client.
```
### How to Reproduce
**Create Table:**
```
CREATE TABLE IF NOT EXISTS test_json_distinct (
id VARCHAR(100),
name VARCHAR(100),
data JSON,
update_date DATETIME
) DUPLICATE KEY(id)
DISTRIBUTED BY HASH(id) BUCKETS 1
PROPERTIES ("replication_num" = "1");
```
**Insert Into Table:**
```
INSERT INTO test_json_distinct VALUES
('1', 'Alice', '{"age": 30, "city": "NYC"}', '2024-01-01 10:00:00'),
('2', 'Bob', '{"age": 25, "city": "LA"}', '2024-01-02 10:00:00'),
('3', 'Charlie', '{"age": 35, "city": "NYC"}', '2024-01-03 10:00:00');
```
**Select Table:**
```
SELECT DISTINCT id, name, data FROM test_json_distinct;
```
**Doris version:** 3.1.1
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
