Databricks Community

deng77 · 01-17-2023

I want to add a column to an existing delta table with a timestamp for when the data was inserted. I know I can do this by including current_timestamp with my SQL statement that inserts into the table. Is it possible to add a column to an existing de...

deng77 · 04-28-2023

How are you adding values to the table? I have encountered that issue previously when I didn't specify columns in an INSERT statement where the table I was writing to had an identity column that is automatically generated.

deng77 · 03-10-2023

Thanks for this, I tried it out on my end with a cluster running DBR 12.2 LTS and I was able to get it to work.CREATE TABLE test (id int, time timestamp); ALTER TABLE test SET TBLPROPERTIES('delta.minReaderVersion' = '1', 'delta.minWriterVersion'='7'...

deng77 · 03-10-2023

That doesn't work for me, I get the following error:[PARSE_SYNTAX_ERROR] Syntax error at or near 'GENERATED'(line 2, pos 32).It sounds like delta lake generated columns have to be based on other columns in the table:Delta Lake supports generated colu...

deng77 · 01-17-2023

Thanks for the response Hubert, hopefully the functionality for delta tables will be added soon.

Databricks Community

User Stats

User Activity

Using current_timestamp as a default value in a delta table

Re: Using current_timestamp as a default value in a delta table

Re: Using current_timestamp as a default value in a delta table

Re: Using current_timestamp as a default value in a delta table

Re: Using current_timestamp as a default value in a delta table