Reply
nad
New Contributor
Posts: 1
Registered: ‎06-20-2016

lateral view explode returns null value via hive context

Hi everyone,

I'm facing a big problem using the hive context. I need to get the elements of an array of strings; this array is stored in a table.

For that, I have a query which works fine on the hive editor via hue. But when I try to run the same query on spark-sql using the hive context, I get nothing but null values.

It as if it isn't able to read such values


Do you have any idea ?


Additionnal elements :


Query  : select   targets  from tcampaign lateral view explode(tcampaign.target ) scit as targets

 target is an array<String>

Spark-sql version : 1.6