Relative Content

Tag Archive for polardb

PolarDB archive partition table

We are using PolarDB 8.0.1, we want to archive the old data partition to csv/orc format to save storage space (only store current data in the ibd file). We tried it at table level, and it seems work fine:

The initial SELECT runs fine, but adding a LEFT JOIN causes an error

I am a user of PolarDB for Xscale. When I executed the statement, the first part of the Select ran without issues, but adding a left join in the second part resulted in the error shown in the image. How should I resolve this?
error image
This is my first time using the PolarDB database, and I couldn’t find the error code in the documentation.