Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Phoenix Index for a table with UNION Operation

Highlighted

Phoenix Index for a table with UNION Operation

New Contributor

We have a query which has about 4 UNIONS on the same table and an order by clause. I wanted to know if it is ever possible to make a Phoenix query with 4 unions and orderby clause a sub second query?

Although I have created required indexes but query is taking about 3 sec to execute.

Is there a way of achieveing sub second query with 4 UNION operations?

Don't have an account?
Coming from Hortonworks? Activate your account here