[ 
https://issues.apache.org/jira/browse/PHOENIX-6445?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17321840#comment-17321840
 ] 

Lars Hofhansl commented on PHOENIX-6445:
----------------------------------------

Three. Final count is missing.
{code}
> explain select count(*) from (select * from test group by rand());
+----------------------------------------------------------------------------------+
|                                      PLAN                                     
   |
+----------------------------------------------------------------------------------+
| CLIENT 10-CHUNK 2578465 ROWS 314572800 BYTES PARALLEL 1-WAY FULL SCAN OVER 
TEST  |
|     SERVER FILTER BY FIRST KEY ONLY                                           
   |
+----------------------------------------------------------------------------------+
2 rows selected (0.03 seconds)
{code}

> Wrong query plans with functions
> --------------------------------
>
>                 Key: PHOENIX-6445
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-6445
>             Project: Phoenix
>          Issue Type: Wish
>            Reporter: Lars Hofhansl
>            Priority: Major
>
> Phoenix seems to sometimes create incorrect query plans when functions are 
> used.
> I'll post these in the comments.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to