Can you go into more detail about the data is structured in HBase? Especially in table B. HBase doesn't have built in data types so people typically need to CONVERT_FROM a format (including JSON). The docs are here: https://cwiki.apache.org/confluence/display/DRILL/SQL+Functions#SQLFunctions-ConvertFunctions
Note that for some reason, JSON isn't listed in that list. It is available for conversion as well. On Thu, Oct 30, 2014 at 1:02 AM, MohammadReza Mofateh <[email protected]> wrote: > Hi, > I can't find a tutorial explaining how to get started with Drill (besides > querying the sample data that comes with Drill like Arrays or JSON). > > I have some Array data on HBASE that I would like to query (Join row_keys > of table A with Arrays in table B) > , how do I query? > > I asked a way for JSON but no body didn't answer me.But I found the way. > > Best >
