Re: What is the corresponding java/scala code to 'lateral view explode' in hql ?

[Anshuman Dwivedi]

Hi,

In short, its a way to improve the system performance by storing multiple 
values of a column for a row in a single list.

Original data:

Id      Location
1       New York
2       London
3       Delhi
4       Tokyo
2       Sydney
Exploded data: Here you can see, location values in id-2 are stored as list.

Id      Location
1       New York
2       London, Sydney
3       Delhi
4       Tokyo
For further clarification, please feel free to mail me personally. 

Regards,
Anshuman Dwivedi



-----&#24352;&#26126;&#30922; <18717838...@163.com> wrote: -----
To: user@hive.apache.org
From: &#24352;&#26126;&#30922; <18717838...@163.com>
Date: 05/31/2017 06:01PM
Subject: What is the corresponding java/scala code to 'lateral view explode' in 
hql ?

Hello experts,
      I was wondering to know as the subject said, what is the corresponding 
java or scala code to the hive semantics "lateral view explode" ? In my 
recently work, i am a new to hql and have to do some work about 
&#8220;&#8221;Real-time off-line fusion&#8220;&#8221;. That was translate hql 
languages into "real time" code, running on the platform of storm or flink.  
So, I searched it on google but still confused. I have to ask for help to hive 
community, Could you share some light on it ?

Thanks,
Minglei.





 
=====-----=====-----=====
Notice: The information contained in this e-mail
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you