[IMPALA-12692] Typo in docs about random() function

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 4.4.0
• Fix Version/s: Impala 4.4.0
• Component/s: Docs
• Labels: newbie
• Epic Color: ghx-label-7
• Assignee: Anshula Jain
• Reporter: Joe McDonnell
• Created: 09/Jan/24 06:51
• Updated: 08/Mar/24 16:38
• Resolved: 08/Mar/24 16:34

Description

The docs for rand()/random() has a typo that refers to "randome":

          RAND(), RAND(BIGINT seed), RANDOME(), RANDOME(BIGINT seed)

https://github.com/apache/impala/blob/master/docs/topics/impala_math_functions.xml#L1466

It should be random().

[localhost:21050] functional> select randome();
Query: select randome()
Query submitted at: 2024-01-08 22:50:44 (Coordinator: http://joemcdonnell-22743:25000)
ERROR: AnalysisException: functional.randome() unknown for database functional. Currently this db has 0 functions.

[localhost:21050] functional> select random();
Query: select random()
Query submitted at: 2024-01-08 22:51:21 (Coordinator: http://joemcdonnell-22743:25000)
Query progress can be monitored at: http://joemcdonnell-22743:25000/query_plan?query_id=7e467178f9a8af8e:771d01ee00000000
+--------------+
| random()     |
+--------------+
| 0.4784972579 |
+--------------+
Fetched 1 row(s) in 0.11s