create domain/adhoc views from hive tables with Array

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.

 

Jane.Yu's picture
203
Joined: Jun 30 2016 - 2:11pm
Last seen: 4 years 9 months ago

1 Answer:

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.

elizam's picture
14370
Joined: Mar 5 2012 - 9:19am
Last seen: 2 years 10 months ago
Feedback
randomness