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
