Hi, might a silly question, but have been stuck for some time on this. My delta table detail shows the name as null. It was created by saving a dataframe as delta. Is there a way to update the name?

Which version of Delta Lake are you on? This was a bug that was fixed: https://github.com/delta-io/delta/issues/1549

i am using delta 2.1.0 (OSS), spark 3.3.0

Yup, this was fixed in 2.3.0!

@Scott Sandre (Delta Lake) is there a way to update it now that it is null? I want to run an alter table - alter column command to update a constraint on the table for which it needs the table name

Seems like the commit fixes finding the tableName .... i.e. the information is there, just not returned in delta lake 2.1.0 in the describe detail command

i will give it a try. Thanks!

What’s the code to show the details? If you use the table name to query, you will see it. But if you use the table path, name will be null

I am using deltatable.detail.toDF.show to view the details. I did use path to create the table. if name is null, how do i run queries like 'alter table...alter column' which expects a tablename?

`alter table delta.`your path``

i tried

spark.sql("ALTER TABLE delta.'/home/some/path' ALTER COLUMN col1 SET NOT NULL") 

and get error - 
at org.apache.spark.sql.catalyst.parser.ParseException.withCommand(ParseDriver.scala:306)
  at org.apache.spark.sql.catalyst.parser.AbstractSqlParser.parse(ParseDriver.scala:143)
  at org.apache.spark.sql.execution.SparkSqlParser.parse(SparkSqlParser.scala:52)
  at org.apache.spark.sql.catalyst.parser.AbstractSqlParser.parsePlan(ParseDriver.scala:89)
  at org.apache.spark.sql.SparkSession.$anonfun$sql$2(SparkSession.scala:620)
  at org.apache.spark.sql.catalyst.QueryPlanningTracker.measurePhase(QueryPlanningTracker.scala:111)
  at org.apache.spark.sql.SparkSession.$anonfun$sql$1(SparkSession.scala:620)
  at org.apache.spark.sql.SparkSession.withActive(SparkSession.scala:779)
  at org.apache.spark.sql.SparkSession.sql(SparkSession.scala:617)
  ... 49 elided

You need to use backticks.

thanks Ryan, backtick worked..but as you mentioned, not null did not work