JasonLeeWeiHern commented on issue #10753:
URL: https://github.com/apache/pinot/issues/10753#issuecomment-1567973157
Error message: There are 580 invalid segment/s. This usually means that they
were created with an older schema. Please reload the table in order to refresh
these segments to the new schema.
Wrong query:
SELECT LOOKUP('table1', 'areaName', 'cityId', cityID, 'geohash', geohash) AS
areaName FROM table2 limit 10
Correct query:
SELECT LOOKUP('table1', 'areaName', 'cityId', cityID, 'geohash', geohash6)
AS areaName FROM table2 limit 10
The column geohash in table 2 should be labelled as geohash6. With this
incorrect column name, it throws the above error message.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
