Hi Team,
How to create index on col1 wher data loo...
# generaln
Nikhil Thomas
11/08/2023, 4:56 AMHi Team,
How to create index on col1 wher data looks like below
Nikhil Thomas
11/08/2023, 4:56 AMIMG_20231108_102454.jpg
Nikhil Thomas
11/08/2023, 4:56 AMBut in code I have used like
Nikhil Thomas
11/08/2023, 4:57 AMCould you please help how to create index on transformed column in pinot query . Plan to crate range index here
x
Xiang Fu
11/08/2023, 5:01 AM
Is this column a timestamp type? If so you can just epoch value for predicate
n
Nikhil Thomas
11/08/2023, 5:02 AMThis is string column from source
x
Xiang Fu
11/08/2023, 5:03 AM
Another option is timestamp index (https://docs.pinot.apache.org/basics/indexing/timestamp-index)
Xiang Fu
11/08/2023, 5:03 AM
Or derived column