Jump to content
Changes to the Jaspersoft community edition download ×

create domain/adhoc views from hive tables with Array


Jane.Yu

Recommended Posts

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.

 

Link to comment
Share on other sites

  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...