There is a table in hive. It has array like this:
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.
hiveTable LATERAL VIEW explode(tax_idx) adTable AS analysis_d1;
Please help. Thank you.