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 <mofateh72@gmail.com>
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
>
|