There is a table in hive. It has array like this:
tax_idx array<struct<TAX_SEQ_NO:string,TAX_CODE:string,TAX_ID_NO:string>>
I need to create a domain in Jasper report server and extract TAX_SEQ_NO field.
But the following query doesn't work when creating derived table.
Select field1,
analysis_d1.TAX_SEQ_NO,
analysis_d1.TAX_CODE
from
hiveTable LATERAL VIEW explode(tax_idx) adTable AS analysis_d1;
Please help. Thank you.