Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

lateral view explode returns null value via hive context

Highlighted

lateral view explode returns null value via hive context

New Contributor

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