[IMPALA-397] ORDER BY rand() does not work.

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: Impala 1.0.1, Impala 2.3.0
• Fix Version/s: Impala 2.9.0
• Component/s: Frontend
• Labels: correctness downgraded planner usability
• Target Version: Product Backlog
• Assignee: Thomas Tauber-Marshall
• Reporter: Alexander Behm
• Created: 05/Jun/13 20:37
• Updated: 27/Apr/17 18:22
• Resolved: 27/Apr/17 18:22

Description

The cause of the issue below is that r is not materialized.

select id, name, rand() r from countries order by r limit 10;
Query: select id, name, rand() r from countries order by r limit 10
Query finished, fetching results ...
+----+----------------+-----------------------+
| id | name           | r                     |
+----+----------------+-----------------------+
| 3  | Canada         | 0.0004714746030380365 |
| 5  | Australia      | 0.5895895192351144    |
| 1  | United States  | 0.4431900859080209    |
| 4  | Ireland        | 0.0739258840093044    |
| 6  | Netherlands    | 0.4621509646354946    |
| 2  | United Kingdom | 0.6679162032287178    |
| 9  | France         | 0.8352529978543767    |
| 8  | Germany        | 0.1610932858479644    |
| 7  | New Zealand    | 0.4815021690360746    |
| 91 | Antigua        | 0.5511845208477156    |
+----+----------------+-----------------------+
Returned 10 row(s) in 0.48s

Issue Links

• is related to: IMPALA-4592 IllegalStateException when using nondeterministic functions in partition filter
• is related to: IMPALA-4731 Sorter crash Impalad instance