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 > >
