Condition on UInt64 field in WHERE clause in ClickHouse

Question

In ClickHouse Playground dataset conditions on UInt64 fields don't seem to work. For example query:

SELECT * FROM hits_100m_obfuscated where WatchID = 8120543446287443000

doesn't return anything (even though I copied the ID from the dataset). Same is true if the condition is on UserID. But the following works just fine:

SELECT * FROM hits_100m_obfuscated where ClientIP = 3078276782

I guess the reason is that ClientIP field has type UInt32, but both UserID and WatchID - UInt64. I tried to use toUInt64 and CAST, but didn't succeed.

Any idea what am I doing wrong?

I think it's some weird bug with playground – Denny Crane May 11 '20 at 22:37 — Denny Crane, May 11 '20 at 22:37

vladimir · Answer 1 · 2020-05-11T23:19:41.647

1

It looks like it is a bug of Playground.

As a temporary workaround, you can send a direct request to service endpoint using the favorite HTTP API client such as Postman, Fiddler, curl etc:

curl "https://play.clickhouse.tech/api/v20.3/?database=datasets&user=playground&password=clickhouse&query=SELECT+*+FROM+hits_100m_obfuscated+where+WatchID=8927014313511165737+limit+1+format+Vertical"

edited May 11 '20 at 23:19

answered May 11 '20 at 22:00

vladimir

13,428
2
44
70

Denny Crane · Accepted Answer · 2020-05-11T22:53:25.703

1

seems web/frontend issue

SELECT '- '||toString(max(WatchID))||' -', max(WatchID), toString(max(WatchID)) FROM hits_100m_obfuscated


- 9223372033328793741 - | 9223372033328794000   | 9223372033328794000

https://github.com/ClickHouse/ClickHouse/issues/10824

edited May 11 '20 at 22:53

answered May 11 '20 at 22:44

Denny Crane

11,574
2
19
30

Thanks, Denis. Will try to install and run it with the client. – leftjab May 11 '20 at 22:55

Condition on UInt64 field in WHERE clause in ClickHouse

2 Answers2