hive

select topic, regexp_replace(topic, '\\[|\\]', '')
from newsdb.news_algorithm_vector a 
where create_time like '2017-12-11%'
limit 10;

需要注意的是，我们在shell中用hive -e去执行的时候，需要再加一层转义\

sql="
select a.content_id, tt.topic
from newsdb.news_algorithm_vector a 
lateral view explode(split(regexp_replace(topic, '\\\[|\\\]', ''),',')) tt as topic
"

hive -e $sql