I’m trying to use Drill to query time-series data stored in OpenTSDB <http://opentsdb.net/>. The row keys are supposed to be byte array encoded according to this schema: http://opentsdb.net/docs/build/html/user_guide/backends/hbase.html
When trying to do a simple CONVERT_FROM I get the following results: 0: jdbc:drill:zk=172.16.1.175:5181,172.16.1.1> select CONVERT_FROM(row_key, 'UTF8') from tsdb limit 100; +------------+ | EXPR$0 | +------------+ | U5p | | U5p! | | U5p" | | U5p% | | U5p& | | U5p* | | U5"� | | U5"�! | Which is a long way off of what’s described in the opentsdb schema page. Any tips for properly querying this kind of data? Chris Matta cma...@mapr.com 215-701-3146