antumbde commented on issue #3994: Adding ORC reader URL: https://github.com/apache/incubator-pinot/pull/3994#issuecomment-477282747 Adding a note about what is different (based on memory; please double check) Arrays in Pinot are like collapsed set of rows. If a table has array column, acol, with value [1,2,3] then that row will be selected by predicate condition 'where acol = 3'. This is different from Presto (and other DBs). For same result, users have to write their query as 'where 3 in acol'. Only value "[1,2,3]" will match a row "[1,2,3]" in presto.
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: [email protected] With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
