Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-03-2023 05:00 PM
I have a dataframe with this format of columns:
[`first.second.third` , `alpha.bravo.test1` , `alpha.bravo.test2`]I'd like to get an output dataframe of this:
[ `first` | `alpha` ]
-------------------------------------------
[{'second': | [{'bravo':
[{'third': value}] | [{'test1': value}
| {'test2': value} ]
}] | }]I tried doing something like this but have some errors with using *select_list
AnalysisException: [UNRESOLVED_COLUMN.WITH_SUGGESTION] A column or function parameter with name `F`.`col("_timestamp"),` cannot be resolved.But manually putting in generated list of select cols with structs works but not exactly what I want.
In the above example the columns were...
[`cloud-provider` , `cloud-region` , `cloud-service-name`]So the desired result is supposed to be...
[`cloud`]
-------
[{'provider': value},
{'region': value},
{'service': {
'name': value}}]Thank you for your help!!!
Labels:
- Labels:
-
Dataframe
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-05-2023 09:43 PM