https://pinot.apache.org/ logo
c

Charles

03/31/2021, 12:31 AM
But I can’t use this “select * from realtime_sjc_wmequality_report where webexConferenceId=189852985506937900 limit 1000” to get it
x

Xiang Fu

03/31/2021, 12:49 AM
What's the error?
Use single quote for big int?
c

Charles

03/31/2021, 12:50 AM
webexConferenceId is LONG type ,I just use where webexConferenceId=189852985506937900
but no response
k

Kishore G

03/31/2021, 3:01 AM
@Jackie ^^
j

Jackie

03/31/2021, 3:02 AM
Didn’t find the root cause yet. Trying to reproduce it
webexConferenceId > 189852985506937900
works but not
webexConferenceId = 189852985506937900
x

Xiang Fu

03/31/2021, 4:54 AM
is this column with dictionary ?
does
webexConferenceId >= 189852985506937900
work?
j

Jackie

03/31/2021, 5:02 AM
Yes, it has dictionary and inverted index
Checked the segment and verified that the inverted index exists
I checked out
0.6.0
and created a segment with value from 189852985506937900 to 189852985506938000, but cannot reproduce the issue