Cloudera Community
Announcements
Celebrating as our community reaches 100,000 members! Thank you!
Srikar
user rank
New Contributor
My Accepted Solutions
Show All

Re: Convert columns to rows

by New Contributor in Support Questions
‎08-27-2018 04:47 AM
‎08-27-2018 04:47 AM
Hello Tomas79,   Yes, it looks good. Since we go with cross join doesn't it effect the performance? If I have 100000 records then if I go with 10 UNION ALL then the count of records will go to 1million. Is there any suggestion please to improve the performance with this approach? ... View more

Convert columns to rows

by New Contributor in Support Questions
‎08-25-2018 04:34 PM
‎08-25-2018 04:34 PM
Hi Team,   I want to convert columns as rows as per user requirement. I know that this can be done using UNION ALL but I have 60 columns need to be converted. If I go with UNION ALL then I would need to write 60 UNION ALLs which will impact the performance. Is there any direct way of converting columns to rows like using any functions etc.,   ... View more
Labels:
Contact Me
Online
Offline
Last Visited
‎09-13-2018 05:40 AM
Community Statistics
Member Since ‎08-20-2018 08:39 PM
Last Visited ‎09-13-2018 05:40 AM
Posts 3