topic Databricks sql not able to evaluate expression current_user in Data Engineering

Databricks sql not able to evaluate expression current_user

Himanshu_90 — Wed, 22 Feb 2023 08:14:40 GMT

Hi,

I have a table as below:

create table default.test_user(

ID bigint NOT NULL GENERATED BY DEFAULT AS IDENTITY (START WITH 1 INCREMENT BY 1),

usr1 varchar(255) NOT NULL,

ts1 timestamp NOT NULL,

usr2 varchar(255) NOT NULL,

ts2 timestamp NOT NULL) USING Delta;

I tried to insert data as below:

insert into table default.test_user

(usr1,ts1,usr2,ts2)

values

(current_user,current_timestamp,current_user,current_Timestamp)

I am getting error as below:

cannot evaluate expression current_user() AS `current_user()` in inline table definition; line 4 pos 1

Please suggest.

Re: Databricks sql not able to evaluate expression current_user

Kemp48 — Wed, 22 Feb 2023 09:03:14 GMT

The current_user function in Databricks SQL is not evaluated as a valid expression, as it is not supported by the platform. Instead, you can use the current_user_name function to retrieve the current user's name.

Thanks,

Aetna Medicare

Re: Databricks sql not able to evaluate expression current_user

Ajay-Pandey — Wed, 22 Feb 2023 10:13:41 GMT

Hi @Himanshu Agrawal ,

It's working for me, please refer below snapshot for the same-

Re: Databricks sql not able to evaluate expression current_user

Himanshu_90 — Wed, 22 Feb 2023 11:27:05 GMT

select current_user works for me as well... but it does not work for the specific scenario which i have pasted... with the current_timestamp

Try this:

insert into table default.test_user

(usr1,ts1,usr2,ts2)

values

(current_user,current_timestamp,current_user,current_Timestamp)

Re: Databricks sql not able to evaluate expression current_user

Himanshu_90 — Wed, 22 Feb 2023 11:32:28 GMT

select current_user is working for me... it is the combination with current_timestamp which is not working. Please try this:

insert into table default.test_user

(usr1,ts1,usr2,ts2)

values

(current_user,current_timestamp,current_user,current_Timestamp)

Re: Databricks sql not able to evaluate expression current_user

Sundot — Wed, 22 Feb 2023 14:13:17 GMT

Syntax. Copy. current_date()
Arguments. This function takes no arguments.
Returns. A DATE. The braces are optional.
Examples. SQL Copy. > SELECT current_date(); 2020-04-25 > SELECT current_date; 2020-04-25.
Related functions. current_timestamp function

Re: Databricks sql not able to evaluate expression current_user

youssefmrini — Thu, 23 Feb 2023 09:43:13 GMT

I tried it in Databricks SQL It does work.

Re: Databricks sql not able to evaluate expression current_user

SergeRielau — Wed, 01 Mar 2023 20:32:27 GMT

It appears current_user() is blocked from VALUES because it is considered non-detereministic.

I've taken the liberty of opening:

https://issues.apache.org/jira/browse/SPARK-42638

feel free to open a support ticket to add some **ompf**.....

Re: Databricks sql not able to evaluate expression current_user

Anonymous — Mon, 24 Apr 2023 10:01:02 GMT

Hi @Himanshu Agrawal

Hope everything is going great.

Just wanted to check in if you were able to resolve your issue. If yes, would you be happy to mark an answer as best so that other members can find the solution more quickly? If not, please tell us so we can help you.

Cheers!