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

2017-05-31 Thread 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 st

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

2017-05-31 Thread Edward Capriolo
For each row, for each element in exploded list emit 1 row. Row r = { col1 } Set x = [ a,b,c] for (Object y : x){ emit(row, y) } If the set x size is 3 , three rows are output. On Wed, May 31, 2017 at 8:31 AM, 张明磊 <18717838...@163.com> wrote: > Hello experts, > I was wondering to know

Remove subscription form list

2017-05-31 Thread John Tench
Could someone unsubscribe me from this list? I’ve followed the instructions for removing my subscription ( that is, send a message to: < user-unsubscr...@hive.apache.org> but this isn’t working. Much appreciated. John.

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

2017-05-31 Thread 张明磊
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 “”Real-time off-line fusion“”. That was translate hql languages into