ALTER TABLE MOVE to external table

[arthurpassos]

For MergeTree tables we need an efficient way to move parts to Parquet. One part should map to one Parquet file, and MergeTree blocks should map to row groups. Sorting should be preserved.

[arthurpassos]

copy will suffice for now

[arthurpassos]

remember about It doesn't filter out rows that are deleted with lightweight deletes.

[arthurpassos]

Shoudl the user be able to specify the output file name? What about format settings?

[arthurpassos]

I missed the "move to external table" part. Format and storage location should be inferred from table.

Something like:

alter table xyz export partition 'abc' to table

[arthurpassos]

Well, since the goal is to move to a different table, this is slightly more complex. Some constraints light schema and partition expression must match, similar to attach partition functionality.

[arthurpassos]

I ignored the constraints for now and I am able to move a clickhouse partition from a merge tree table to s3 table engine, but there is a caveat: the partition must contain only one part. The reason is: multiple parts require multiple files on s3, therefore the s3 engine should be created with something that uniquely identifies files, such as uuid or _part macros. If a s3 table engine is created with any of those, it goes into readonly mode.

[arthurpassos]

I need to pay attention to this: MergeTree blocks should map to row groups. The current implementation will just call StorageObjectStorage::write API for each data part, but that doesn't guarantee the mapping from blocks to row groups.

[arthurpassos]

Investigate why inserts are not supported and how can we fix it