hey I was trying to use geoindex feature in pinot....
# generalc
Chengxuan Wang
03/04/2022, 2:12 PMhey I was trying to use geoindex feature in pinot. but seems the index doesn’t apply because the
numEntriesScannedInFilter0.8.0 Copy code
select count(*) from some_table where st_distance(resto_st_point, st_point(116.459717 , 39.955734, 1)) < 3000 Copy code
"fieldConfigList": [
{
"name": "resto_st_point",
"encodingType": "RAW",
"indexType": "H3",
"properties": {
"resolutions": "12"
}
}
],
.....
"noDictionaryColumns": [
"resto_st_point"
],m
Mayank
03/04/2022, 5:25 PM
@User ^^
y
Yupeng Fu
03/04/2022, 9:52 PMcheck the query plan in trace mode and see why index is not in use
c
Chengxuan Wang
03/04/2022, 11:21 PMlet me check.
Chengxuan Wang
03/04/2022, 11:47 PMis this the right trace:
Copy code
"0_0": [
{
"H3IndexFilterOperator Time": 0
},
{
"RangeDocIdSetOperator Time": 0
},
{
"ProjectionOperator Time": 0
},
{
"RangeDocIdSetOperator Time": 0
},
{
"ProjectionOperator Time": 0
},Chengxuan Wang
03/04/2022, 11:49 PMand this is for meter is 300.
Copy code
{
"H3IndexFilterOperator Time": 6
},
{
"DocIdSetOperator Time": 6
},
{
"ProjectionOperator Time": 6
},Chengxuan Wang
03/04/2022, 11:49 PMcc @User @User
y
Yupeng Fu
03/05/2022, 4:03 AMThat means the h3index operator is used
Yupeng Fu
03/05/2022, 4:03 AMFor both queries
c
Chengxuan Wang
03/05/2022, 4:24 AMoh.ok.
Chengxuan Wang
03/05/2022, 4:26 AMdoes it mean i didn’t setup resolution correct? for the first query (threshold is 3000 meters),
H3IndexFilterOperator Time01Chengxuan Wang
03/05/2022, 4:27 AM@User
y
Yupeng Fu
03/05/2022, 4:30 AMwhats the resolution did you use?
Yupeng Fu
03/05/2022, 4:30 AMcheck this table https://h3geo.org/docs/core-library/restable
c
Chengxuan Wang
03/05/2022, 4:30 AM12
y
Yupeng Fu
03/05/2022, 4:30 AMif resolution is too small, then you'll have lots of small indices
Yupeng Fu
03/05/2022, 4:31 AM12 is 9m
Yupeng Fu
03/05/2022, 4:31 AMtoo small
c
Chengxuan Wang
03/05/2022, 4:33 AMoh. I see. i understand it wrong. i thought the resolution is the bigger the faster.