- 6897 Views
- 2 replies
- 0 kudos
Adding column as StructType
Hi Team,Just wondering, how can I add a column to an existing table.I'd tried the below script but giving me an error:ParseException: [PARSE_SYNTAX_ERROR] Syntax error at or near '<'(line 1, pos 121)ALTER TABLE table_clone ADD COLUMNS col_name1 STRUC...
- 6897 Views
- 2 replies
- 0 kudos
- 0 kudos
To add a STRUCT column to an existing table, use the correct syntax without $ symbols, such as ALTER TABLE table_clone ADD COLUMNS (col_name1 STRUCT<type: STRING, values: ARRAY<STRING>>)
- 0 kudos
- 2760 Views
- 1 replies
- 0 kudos
Reading multi-dimensional json files
So I've been having some issues reading a json file that's been provided to the business with another nesting layer, so instead of a json being an:'array of objects' -> [ {} ,{} ,{} ] It's an 'array of arrays of objects' -> [ [ {}, {} ,{} ], [ {} ,{}...
- 2760 Views
- 1 replies
- 0 kudos
- 0 kudos
You can use the explode function to flatten the array to rows, can you post a simple example of your data?
- 0 kudos