Best way to create a view with index from explode ?

[Viraj Bhat]

Hi all,

I have an input table which has 3 columns one of which is an array list,

 

bcookie, id, info [Schema: string, string,
arraylist<map<string,string>>]

 

Here is a sample row

 

1245, 1, {[myid#id2, myage#100], [myid#id3, myage#101], [myid#id3,
myage#102]}

 

I wanted to explode the arraylist column and create an additional column
which represents the index of the info

 

bcookie, id, info, index

1245, 1, [myid#id2, myage#100], 0

1245, 1, [myid#id3, myage#101], 1

1245, 1, [myid#id3, myage#102] , 2

 

I was thinking of the lines of:

SELECT * FROM srctable LATERAL VIEW explode(info)... ;

 

Is UDTF the only way to achieve this?

Thanks Viraj