diff options
Diffstat (limited to 'tests/dialects/test_athena.py')
-rw-r--r-- | tests/dialects/test_athena.py | 6 |
1 files changed, 5 insertions, 1 deletions
diff --git a/tests/dialects/test_athena.py b/tests/dialects/test_athena.py index ca91d4a..ef96938 100644 --- a/tests/dialects/test_athena.py +++ b/tests/dialects/test_athena.py @@ -62,8 +62,12 @@ class TestAthena(Validator): # CTAS goes to the Trino engine, where the table properties cant be encased in single quotes like they can for Hive # ref: https://docs.aws.amazon.com/athena/latest/ug/create-table-as.html#ctas-table-properties + # They're also case sensitive and need to be lowercase, otherwise you get eg "Table properties [FORMAT] are not supported." self.validate_identity( - "CREATE TABLE foo WITH (table_type='ICEBERG', external_location='s3://foo/') AS SELECT * FROM a" + "CREATE TABLE foo WITH (table_type='ICEBERG', location='s3://foo/', format='orc', partitioning=ARRAY['bucket(id, 5)']) AS SELECT * FROM a" + ) + self.validate_identity( + "CREATE TABLE foo WITH (table_type='HIVE', external_location='s3://foo/', format='parquet', partitioned_by=ARRAY['ds']) AS SELECT * FROM a" ) self.validate_identity( "CREATE TABLE foo AS WITH foo AS (SELECT a, b FROM bar) SELECT * FROM foo" |