fx19880617 commented on issue #4041: Use hex string as the representation of byte array for queries URL: https://github.com/apache/incubator-pinot/pull/4041#issuecomment-478678169 > > > Can you add some motivation behind the change? I am guessing (but not sure) that we want to ingest string data that are known to be hexbytes. Is that right? Is this a part of a bigger design document? If so, can you point me to one (or, add one under https://cwiki.apache.org/confluence/display/PINOT/Design+Documents) > > > thanks > > > > > > My major motivation is related to this issue: #4040. > > Basically I want to ingest data like `uid` as bytes format and write a lookup query on top of it. Since hex string is used to display bytes type in query results, I extend this concept and make hex string/bytes both accepted for this column. > > Is it not possible to use a string datatype for this? Assuming that the string is byte-array encoded does not seem right to me. Perhaps I am missing something here This is to match the data in select query. Basically in `select uid from myTable limit 10` query, I got a random row with `uid` value shown as `"c8b3bce0b378fc5ce8067fc271a34892"` which is a hex string. And if I want to fetch this row with predicate, I should use the same hex string in my query, say `select * from myTable where uid="c8b3bce0b378fc5ce8067fc271a34892"`
---------------------------------------------------------------- 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]
