Databricks

Himanshu_90 · 02-22-2023

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 Del...

Himanshu_90 · 02-22-2023

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)

Himanshu_90 · 02-22-2023

select current_user works for me as well... but it does not work for the specific scenario which i have pasted... with the current_timestampTry this:insert into table default.test_user(usr1,ts1,usr2,ts2)values(current_user,current_timestamp,current_u...

Databricks

User Stats

User Activity

Databricks sql not able to evaluate expression current_user

Re: Databricks sql not able to evaluate expression current_user

Re: Databricks sql not able to evaluate expression current_user