[GitHub] [pinot] JasonLeeWeiHern commented on issue #10753: Wrong error message for incorrect column name during lookup

["JasonLeeWeiHern (via GitHub)" <gi...@apache.org>]

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: commits-unsubscribe@pinot.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@pinot.apache.org
For additional commands, e-mail: commits-help@pinot.apache.org