But I can’t use this “select * from realtime_sjc_w...
# troubleshootingc
Charles
03/31/2021, 12:31 AMBut 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?
Xiang Fu
03/31/2021, 12:50 AM
Use single quote for big int?
c
Charles
03/31/2021, 12:50 AMwebexConferenceId is LONG type ,I just use where webexConferenceId=189852985506937900
Charles
03/31/2021, 12:51 AMbut no response
k
Kishore G
03/31/2021, 3:01 AM
@Jackie ^^
j
Jackie
03/31/2021, 3:02 AMDidn’t find the root cause yet. Trying to reproduce it
Jackie
03/31/2021, 3:03 AMwebexConferenceId > 189852985506937900webexConferenceId = 189852985506937900x
Xiang Fu
03/31/2021, 4:54 AM
is this column with dictionary ?
Xiang Fu
03/31/2021, 4:55 AM
does
webexConferenceId >= 189852985506937900j
Jackie
03/31/2021, 5:02 AMYes, it has dictionary and inverted index
Jackie
03/31/2021, 5:03 AMChecked the segment and verified that the inverted index exists
Jackie
03/31/2021, 5:04 AMI checked out
0.6.0