Release Notes 2022.1.2

The 2022.1.2 release notes were released on 8/24/2022 and describe the following:

Version Content 

The 2022.1.2 Release Notes describes the following:

Automatic schema identification.
Optimized queries on external Parquet tables.

Storage Version 

The storage version presently in effect is version 41.

New Features 

The 2022.1.2 Release Notes include the following new features:

Parquet Read Optimization 

Querying Parquet foreign tables has been optimized and is now up to 20x faster than in previous versions.

Resolved Issues 

The following table lists the issues that were resolved in Version 2022.1.2:

SQ No.	Description
SQ-10892	An incorrect error message was displayed when users ran the `UPDATE` command on foreign tables.
SQ-11273	Clustering optimization only occurs when copying data from CSV files.

Operations and Configuration Changes 

No configuration changes were made.

Naming Changes 

No relevant naming changes were made.

Deprecated Features 

No features were deprecated for Version 2022.1.2.

End of Support 

The End of Support section is not relevant to Version 2022.1.2.

Upgrading to v2022.1.2 

Generate a back-up of the metadata by running the following command:
```
$ select backup_metadata('out_path');
```
Tip

SQream recommends storing the generated back-up locally in case needed.

SQream runs the Garbage Collector and creates a clean backup tarball package.
Shut down all SQream services.
Extract the recently created back-up file.
Replace your current metadata with the metadata you stored in the back-up file.
Navigate to the new SQream package bin folder.
Run the following command:
```
$ ./upgrade_storage <levelDB path>
```

Note

Upgrading from a major version to another major version requires you to follow the Upgrade Storage step. This is described in Step 7 of the Upgrading SQream Version procedure.