Operations Allowed on S3 Tables¶
ALTER TABLE S3 supports all types, keys and other options that are supported by the Aria engine. One can also perform ALTER TABLE on an S3 table to add or modify columns etc.
DROP TABLE
SELECT Any SELECT operations you can perform on a normal table should work with an S3 table.
SHOW TABLES will show all tables that exist in the current defined S3 location.
S3 tables can be part of partitions. See Discovery below.