This helps Spark optimize the execution plan on these queries.
Dropping a nested column from Spark DataFrame.
You can drop only types with no type or table dependencies. Specify the name of the object, varray, or nested table type to be dropped. If you omit schema, then Oracle Database assumes the type is in your own schema. In Spark my requirement was to convert single column value (Array of values) into multiple rows. Recently I was working on a task to convert Cobol VSAM file which often has nested columns defined in it. The following SQL deletes the 'ContactName' column from the 'Customers' table The DROP COLUMN command is used to delete a column in an existing table.
