1. You might be able to run a query against OpenTSDB, but I'm not sure if you will really be able to easily do anything useful right now. Every column qualifier in an HBase table results in a column in Drill. In the OpenTSDB format, the column qualifiers are simply time offsets from the base timestamp which is encoded in the row key. And I believe this offset could be either seconds or milliseconds, and a single row holds the data for an entire hour. So there could very easily be thousands of columns.
Another potential issue is that the column qualifiers are not Strings, but some encoded integer. I am not sure Drill allows non-printable column names. I'm not sure how Drill will handle the case of non-UTF8 column qualifiers. If we can get past those potential issues, I think you would want to use KVGEN and FLATTEN. Once you've done this, you could filter based on the rowkey and the offset in order to return the data within a time range. 2. Yes, you can query multiple clusters. Just configure separate hbase plugins in the Storage panel of the Web UI. On Tue, Oct 20, 2015 at 11:33 AM, Kirankumar Gowdru <kgow...@salesforce.com> wrote: > I'm new to apache Drill. I have few questions. > > 1.An we use Apache drill to query TSDB? If so what is the bets approach? > 2. Can we use drill to query to multiple hbase clusters? > > Thanks, > Kiran >
