Support Questions

Find answers, ask questions, and share your expertise
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Advanced Search
Announcements
Check out our newest addition to the community, the Cloudera Data Analytics (CDA) group hub.

lateral view explode in impala?

Labels:
Sullivan
New Contributor

Created on ‎09-03-2018 02:04 AM - edited ‎09-16-2022 06:39 AM

I have data as source as below. How to transform the multi rows?

Any function like lateral view explode in impala?

impala.JPG

8,289 Views
0 Kudos
2 REPLIES 2

Tim Armstrong
Guru

Created ‎09-11-2018 11:16 AM

We don't support this in Impala right now. We'd generally recommend using Hive to prepare such data for querying.
8,214 Views

peng123
New Contributor

Created ‎11-09-2022 02:46 AM

Is it supported now?

1,016 Views
0 Kudos
Take a Tour of the Community
Don't have an account?
Register
Your experience may be limited. Sign in to explore more.
Announcements
What's New @ Cloudera
Cloudera Operational Database (COD) UI supports creating a smaller cluster using a predefined Data Lake template
What's New @ Cloudera
Cloudera Operational Database (COD) supports scaling up the clusters vertically
Product Announcements
CDP Public Cloud: April 2023 Release Summary
What's New @ Cloudera
Cloudera Machine Learning launches "Add Data" feature to simplify data ingestion
What's New @ Cloudera
Simplify Data Access with Custom Connection Support in CML
View More Announcements