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. 
govindarajan_d's avatar
govindarajan_d
Super User
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. 
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous , govindarajan_d 
Apologies for the issue you have been facing. You are right. This is a bug and I got confirmation from the internal team that the fix is rolling in production and the ETA is end of this week across the world.
So try to rerun the pipelines on the tables next week and do let me know if you are still facing any issues.

Please let me know if you have any further questions.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous 
    We haven’t heard from you on the last response and was just checking back to see if your query got resolved. Otherwise, will respond back with the more details and we will try to help.
    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi @eddiehsu 
      We haven’t heard from you on the last response and was just checking back to see if your query got resolved. Otherwise, will respond back with the more details and we will try to help.
      Thanks

      • Kryt0n's avatar
        Kryt0n
        Advocate I
        2 years ago

        Just hit this issue... source table was created via a DF Gen 2 and trying to read it ("select *") from a notebook gets the above error

  • rowrowrow2's avatar
    rowrowrow2
    Advocate I
    2 years ago

    I'm still getting this issue. I thought it was supposed to be fixed?