Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Mismatched minReaderVersion and readerFeatures

1. I used csv file to create table `bot` in lakehouse, it had 3 rows in the begining. 2. I created a notebook to get the latest id in table `bot`, the code is as below:         # Welcome to yo...
power bi
  • govindarajan_d's avatar
    govindarajan_d
    2 years ago

    Hi Anonymous ,

    You can take a backup of the table and try to alter the property by running the SQL command below in Spark notebook:

    ALTER TABLE <table-identifier> SET TBLPROPERTIES('delta.minReaderVersion' = '1', 'delta.minWriterVersion' = '3')
    This might help to fix the issue. 
     
    But as you said, this looks like a bug since it had been working in previous executions. 
scca's avatar
scca
Advocate III
2 years ago

I'm getting the same error. Weird thing is, I'm running the same notebook concurrently going through different tables in the same manner and the rest succeeds with no issues except for one and it even occurs during manual runs...

Naveen-004's avatar
Naveen-004
Frequent Visitor
2 years ago

I'm also getting the same error. 

  • Naveen-004's avatar
    Naveen-004
    Frequent Visitor
    2 years ago

    I found a temporary fix for the problem: we can simply create a new table and copy the existing table data to the new table.

    • scca's avatar
      scca
      Advocate III
      2 years ago

      Yeah, though it's helpful in Dev. It's quite the problem when running a live pipeline and the just comes out of nowhere. Haven't had that problem for a while but it is annoying when it does unless it's a problem solvable by the user.

      • Naveen-004's avatar
        Naveen-004
        Frequent Visitor
        2 years ago

        Yup, I agree.