delta icon indicating copy to clipboard operation
delta copied to clipboard

Reading the delta lake table will occasionally report that the table does not exist[BUG]

Open kongluo opened this issue 2 years ago • 2 comments

When I indirectly read the data in the table, the reading fails occasionally, and the error is that the table does not exist.

But in fact, this table has always existed. When using the delta1.0.0 version, this problem often occurred when using the DeltaTable.isDeltaTable method. Later, this method was avoided from the business level, and the delta lake was upgraded to 1.0.1. However, when reading, the problem of unrecognized table still occurs occasionally.

The data is stored on azure datalake storage gen2, and a connection is established with delta lake through hadoop-azure. I don't know if it is an internal problem of delta lake, resulting in occasional unrecognized tables.

At present, through the spark.read().format("delta").load() method, will there be an error that the table cannot be recognized

  • Delta Lake version: 1.0.1
  • Spark version: 3.1.1
  • Scala version: 2.12.2

kongluo avatar Jun 02 '22 06:06 kongluo

Are you able to try 1.1.0 or above? There is a fix for such issue https://github.com/delta-io/delta/commit/c424efad8b03c2dce6d988a927677a0e9c314a11

If you can provide the reproduction steps, we can help confirm if this is the root cause.

zsxwing avatar Jun 02 '22 06:06 zsxwing

Are you able to try 1.1.0 or above? There is a fix for such issue c424efa

If you can provide the reproduction steps, we can help confirm if this is the root cause.

ok, I'll try a later version of delta lake and see if the issue is online

kongluo avatar Jun 02 '22 06:06 kongluo