Jane.Yu Posted June 12, 2017 Share Posted June 12, 2017 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_CODEfromhiveTable LATERAL VIEW explode(tax_idx) adTable AS analysis_d1; Please help. Thank you. Link to comment Share on other sites More sharing options...
elizam Posted June 12, 2017 Share Posted June 12, 2017 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. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now