diff options
Diffstat (limited to 'tests/dialects/test_hive.py')
| -rw-r--r-- | tests/dialects/test_hive.py | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/tests/dialects/test_hive.py b/tests/dialects/test_hive.py index f13d92c..c569d96 100644 --- a/tests/dialects/test_hive.py +++ b/tests/dialects/test_hive.py @@ -761,13 +761,13 @@ class TestHive(Validator): }, ) self.validate_all( - "SELECT TRUNC(CAST(ds AS TIMESTAMP), 'MONTH') AS mm FROM tbl WHERE ds BETWEEN '2023-10-01' AND '2024-02-29'", + "SELECT TRUNC(CAST(ds AS TIMESTAMP), 'MONTH')", read={ - "hive": "SELECT TRUNC(CAST(ds AS TIMESTAMP), 'MONTH') AS mm FROM tbl WHERE ds BETWEEN '2023-10-01' AND '2024-02-29'", - "presto": "SELECT DATE_TRUNC('MONTH', CAST(ds AS TIMESTAMP)) AS mm FROM tbl WHERE ds BETWEEN '2023-10-01' AND '2024-02-29'", + "hive": "SELECT TRUNC(CAST(ds AS TIMESTAMP), 'MONTH')", + "presto": "SELECT DATE_TRUNC('MONTH', CAST(ds AS TIMESTAMP))", }, write={ - "presto": "SELECT DATE_TRUNC('MONTH', TRY_CAST(ds AS TIMESTAMP)) AS mm FROM tbl WHERE ds BETWEEN '2023-10-01' AND '2024-02-29'", + "presto": "SELECT DATE_TRUNC('MONTH', TRY_CAST(ds AS TIMESTAMP))", }, ) self.validate_all( |