I would like to create hive tables from nested XML files.
For simple XML files (without arrays) I am using Hive-XML-SerDe.
Example for arrays in XML:
<Header> <Header_name>Header Content</Header_name></Header><record>
Best solution, which I know for array
What I would like to have:
Header Content 03.06.2009
Header Content 03.06.2010
Header Content 03.06.2011
I had a similar problem wirh JSON. Here it is possible in SELECT statements to open arrays with "explode".
LATERAL VIEW explode (column_name_with_array) AdTable as column_name_View
Maybe the simplest way is to create JSON files from XML files and then to import JSON files into Hive.
- Is it possible to explode XML arrays similar to JSON?