diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-27 02:50:21 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2024-04-27 02:50:21 +0000 |
| commit | da8fc943704a221b86f0f6938f4131f0dd679f82 (patch) | |
| tree | bef7144499ea444319403ba8dbf68480ae3a4e39 /tests/dialects/test_hive.py | |
| parent | Adding upstream version 23.10.0. (diff) | |
| download | sqlglot-da8fc943704a221b86f0f6938f4131f0dd679f82.tar.xz sqlglot-da8fc943704a221b86f0f6938f4131f0dd679f82.zip | |
Adding upstream version 23.12.1.upstream/23.12.1
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'tests/dialects/test_hive.py')
| -rw-r--r-- | tests/dialects/test_hive.py | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/tests/dialects/test_hive.py b/tests/dialects/test_hive.py index 33294ee..9215f05 100644 --- a/tests/dialects/test_hive.py +++ b/tests/dialects/test_hive.py @@ -429,6 +429,9 @@ class TestHive(Validator): "INSERT OVERWRITE TABLE zipcodes PARTITION(state = 0) VALUES (896, 'US', 'TAMPA', 33607)" ) self.validate_identity( + "INSERT OVERWRITE DIRECTORY 'x' ROW FORMAT DELIMITED FIELDS TERMINATED BY '\001' COLLECTION ITEMS TERMINATED BY ',' MAP KEYS TERMINATED BY ':' LINES TERMINATED BY '' STORED AS TEXTFILE SELECT * FROM `a`.`b`" + ) + self.validate_identity( "SELECT a, b, SUM(c) FROM tabl AS t GROUP BY a, b, GROUPING SETS ((a, b), a)" ) self.validate_identity( @@ -524,9 +527,11 @@ class TestHive(Validator): self.validate_all( "APPROX_COUNT_DISTINCT(a)", write={ + "bigquery": "APPROX_COUNT_DISTINCT(a)", "duckdb": "APPROX_COUNT_DISTINCT(a)", "presto": "APPROX_DISTINCT(a)", "hive": "APPROX_COUNT_DISTINCT(a)", + "snowflake": "APPROX_COUNT_DISTINCT(a)", "spark": "APPROX_COUNT_DISTINCT(a)", }, ) |