A Hive table (example: Table1) has a column ( column1) which is of struct type. This struct has a JSON-column which needs to converted to a hive table. ( JSON column data needs to be flattened and displayed in a hive view)
id : " "
claim-number : "123"
claim-description : "test data"
The select query to display the json data is below
create view as
The result set is all null.
can you please suggest.
Each JSON record must be on a single line (no new-line characters allowed).
A return of 'null' just means that Hive cannot parse the JSON as directed.