[MDEV-24394] Support CREATE TABLE for S3 engine to allow projections Created: 2020-12-11  Updated: 2020-12-11

Status: Open
Project: MariaDB Server
Component/s: Storage Engine - S3
Fix Version/s: None

Type: Task Priority: Minor
Reporter: Claudio Nanni Assignee: Unassigned
Resolution: Unresolved Votes: 0
Labels: None


 Description   

It's possbile that someone would want to archive a subset of columns of a local table in S3, so this would be a valid statement:

create table z02 (name varchar(20)) engine=s3 select user from mysql.user;

But currently CREATE TABLE is not supported in S3:

ERROR 1005 (HY000): Can't create table `s3_schema`.`z02` (errno: 131 "Command not supported by the engine")

It would allow to do a vertical partitioning excluding non important data or just split tables on separate S3 tables without the need to create them locally first.


Generated at Thu Feb 08 09:29:39 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.