Creating Nested dataframe from flat data.

[Prashant Bhardwaj]

Hi

Let's say I have a flat dataframe with 6 columns like.
{
"a": "somevalue",
"b": "somevalue",
"c": "somevalue",
"d": "somevalue",
"e": "somevalue",
"f": "somevalue"
}

Now I want to convert this dataframe to contain nested column like

{
"nested_obj1": {
"a": "somevalue",
"b": "somevalue"
},
"nested_obj2": {
"c": "somevalue",
"d": "somevalue",
"nested_obj3": {
"e": "somevalue",
"f": "somevalue"
}
}
}

How can I achieve this? I'm using Spark-sql in scala.

Regards
Prashant