Hello, I have added updated the table with indexin...
# troubleshooting
t
Hello, I have added updated the table with indexing config to add indices on some columns. After this I triggered
Reload All Segments
to apply the indexes. When I try to check the
Reload Status
, I get this error on the UI
Copy code
Table type : REALTIME not yet supported.
I have checked the tableIndexConfig in the IDEAL STATE of the table and the indices were present. Is this the source of truth for me to check if the indexing has been applied or not? If not, how can I check if the indexing has been applied to that table?
j
There are 2 ways: 1. Make a query
select count(*) from table where col = 123
and check the
numEntriesScannedInFilter
, if it is 0, then that means the inverted index on
col
is present 2. Log in to the server and check the segment directory under data directory. In the
index_map
file you should be able to find the inverted index for that column if it exists
thankyou 1
t
Thanks @Jackie 🙂