Impala连接和转换字符串列以创建日期

CREATE TABLE example_table (
    id INT,
    date_string VARCHAR(20)
);

INSERT INTO example_table (id, date_string) VALUES
(1, '2021-08-01'),
(2, '2021-08-02'),
(3, '2021-08-03');

SELECT id, STR_TO_DATE(date_string, '%Y-%m-%d') AS date
FROM example_table;

+----+------------+
| id |    date    |
+----+------------+
|  1 | 2021-08-01 |
|  2 | 2021-08-02 |
|  3 | 2021-08-03 |
+----+------------+

SELECT id, CAST(date_string AS DATE) AS date
FROM example_table;