[SPARK-42638] current_user() is blocked from VALUES, but current_timestamp() is not

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.3.0
• Component/s: Spark Core
• Assignee: Unassigned
• Reporter: Serge Rielau
• Created: 01/Mar/23 20:30
• Updated: 04/Mar/23 06:26

Description

VALUES(current_user());
returns:

cannot evaluate expression current_user() in inline table definition.; line 1 pos 8

 

The same with current_timestamp() works.

It appears current_user() is recognized as non-deterministic. But it is constant within the statement, just like current_timestanmp().

PS: It's not clear why we block non-deterministic functions to begin with....