Excel Reader: Parguet Table Storage Format

KNIME Analytics Platform
1

Hi,

when I use the current Excel Reader, I keep getting warnings that

Invalid storage format 'org.knime.parquet.ParquetTableStoreFormat' -- using standard KNIME table format instead

Is there anything I can to to make this warning disappear?

Thanks!

2

I think this warning appears if the workspace at some point was configured in the Preferences to use the “KNIME Column Storage (based on Apache Parquet)” for the row-based table backend (I know, the naming is confusing since we now since a few years have the “columnar table backend” (based on Arrow)).

You can either install that extension (I think it’s unlisted, so to find it you have to disable grouping by category), or what I would do if you don’t need to use that format (I don’t see a need to use it personally) would be to go to Preferences → KNIME → Table Backend and switch the backend to “Columnar Backend”, hit Apply, then switch back to “Row-based Backend” and hit Apply again. This should overwrite any settings that are there from the Parquet-based backend.

Let me know if that helps to remove the warning.

2 Likes