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 serial range scan problem

Highlighted

Phoenix serial range scan problem

Contributor

Dear all.

 

I'd like to know it is possible to force PARALLEL RANGE SCAN.

 

Now I have execution plan below.

And this plan takes about 10 seconds, So I hope to run this with parallel 80-way range scan.

How can I fix this problem?

 

Help me! Thanks.

 

+-------------------------------------------------------------------------------------------------------------+
| PLAN |
+-------------------------------------------------------------------------------------------------------------+
| CLIENT 80-CHUNK 4683260417 ROWS 377487413197 BYTES SERIAL 80-WAY RANGE SCAN OVER _LOCAL_IDX_DEVICE_HISTORY |
| SERVER FILTER BY FIRST KEY ONLY |
| SERVER 1000 ROW LIMIT |
| CLIENT MERGE SORT |
| CLIENT 1000 ROW LIMIT |
+-------------------------------------------------------------------------------------------------------------+