create domain/adhoc views from hive tables with Array

[Jane.Yu]

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.

 

[elizam]

You can create a Domain if you use a JDBC driver to access Hive, but depending on the driver features, the domain might not work.