create domain/adhoc views from hive tables with Array

0

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
45
Joined: Jun 30 2016 - 2:11pm
Last seen: 1 year 1 month ago

1 Answer:

0

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
4303
Joined: Mar 5 2012 - 9:19am
Last seen: 1 month 1 week ago
Feedback
randomness