But I can t use this select from realtime sjc wmequality rep

Question

But I can t use this select from realtime sjc wmequality report where webexConferenceId=189852985506937900 limit 1000 to get it

Xiang Fu · Answer

What s the error

Xiang Fu · Answer

Use single quote for big int

Charles · Answer

webexConferenceId is LONG type I just use where webexConferenceId=189852985506937900

Charles · Answer

but no response

Kishore G · Answer

< Jackie> ^^

Jackie · Answer

Didn t find the root cause yet Trying to reproduce it

Jackie · Answer

`webexConferenceId gt 189852985506937900` works but not `webexConferenceId = 189852985506937900`

Xiang Fu · Answer

is this column with dictionary

Xiang Fu · Answer

does `webexConferenceId gt = 189852985506937900` work

Jackie · Answer

Yes it has dictionary and inverted index

Jackie · Answer

Checked the segment and verified that the inverted index exists

Jackie · Answer

I checked out `0 6 0` and created a segment with value from 189852985506937900 to 189852985506938000 but cannot reproduce the issue