Vida,

Thank you very much for your help

That works good but problem is I have to insert data from multiple queries. I have to declare collection of dataframes to store data from each query at the end I can union all dataframes and insert into an Hive table.

I tried to create collection of dataframe in scala , I am new to scala still struggling

Please let me know the syntax for declaring collection/array of dataframes

Regards,

~Sri