Union Two DataFrames of Different Types Spark : In my recent project, i need to union two dataframes of different sizes.
For example:

Here is my sample data:

df1:

    name    number    address
    kevin	101		NZ
    gevin	102		CA

here all the fields are of type String.

df2:

    name    number    address
    kevin	[101,102]	NZ
    gevin	[102,103]	CA

Here name and address are type string and number is of type array<string>.

Now i need to union these two dataframes. My expexcted outcome is like:

    name    number    address
    kevin	101		NZ
    gevin	102		CA
    kevin	[101,102]	NZ
    gevin	[102,103]	CA

final df types should be same as the df2(string, array<string>, string).

Thanks in Advance.

