Hey - thanks for the very quick reply! I tried out the CONVERT_FROM JSON:
Select CONVERT_FROM(my_table.my_column.tweet, ‘JSON’) as tweet from `hbase`.`my_table` as my_table But I’m getting a new issue: org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: java.lang.IllegalArgumentException: You tried to write a Bit type when you are using a ValueWriter of type SingleMapWriter. Fragment 1:0 Any idea what I might look at to diagnose? -Steve On 9/4/15, 3:14 PM, "Jacques Nadeau" <[email protected]> wrote: >You should use CONVERT_FROM(my_table.my_column.tweet, 'JSON'). Your data >is expected to be UTF8 encoded JSON. Your email was slightly corrupted but >it looks like you had 'UTF8' instead of 'JSON'. > >-- >Jacques Nadeau >CTO and Co-Founder, Dremio > >On Fri, Sep 4, 2015 at 12:06 PM, <[email protected]> >wrote: > >> Hello, >> >> I¹ve got an hbase table with some json data in one of the columns. I¹m >> able to query the table and get the column but I¹m having trouble >>drilling >> into the json document in the column. Is it possible to do it? >> >> >> select CONVERT_FROM(my_table.my_column.tweet, ŒUTF8¹) as tweet from >> `hbase`.`my_table` as my_table >> >> >> Returns: >> tweet: >> {"created_at":"Fri Oct 31 11:12:28 +0000 2014², ³text²:²hello², Š} >> >> >> >> select T.tweet.text from (select CONVERT_FROM(my_table.my_column.tweet, >> ŒUTF8¹) as tweet from `hbase`.`my_table` as my_table) as T >> >> Returns: >> EXPR$0: >> null >> >> Is it possible to do what I¹m attempting or do I need to redefine the >> table? >> >> Thanks for any tips, >> Steve >> >>
