Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Feature]Trino dialect supports insert syntax #52665

Open
1 task done
renzhimin7 opened this issue Nov 6, 2024 · 1 comment · Fixed by #52712
Open
1 task done

[Feature]Trino dialect supports insert syntax #52665

renzhimin7 opened this issue Nov 6, 2024 · 1 comment · Fixed by #52712

Comments

@renzhimin7
Copy link
Contributor

renzhimin7 commented Nov 6, 2024

Feature request

Is your feature request related to a problem? Please describe.

set sql_dialect='trino';
select doy(date '2022-03-06');
+-------------------------+
| dayofyear('2022-03-06') |
+-------------------------+
|                      65 |
+-------------------------+
1 row in set (0.04 sec)

insert into t3 select doy(date '2022-03-06');
ERROR 1064 (HY000): Getting analyzing error from line 1, column 22 to line 1, column 43. Detail message: No matching function with signature: doy(date)

Describe the solution you'd like

Implementing insert syntax in Trino dialect
Describe alternatives you've considered

Additional context

@wangsimo0
Copy link
Contributor

StarRocks > set sql_dialect='trino';
Query OK, 0 rows affected (0.01 sec)

StarRocks > select doy(date '2022-03-06');
+-------------------------+
| dayofyear('2022-03-06') |
+-------------------------+
|                      65 |
+-------------------------+
1 row in set (0.30 sec)

cannot reproduce in my cluster. I'm using 3.3.2

@renzhimin7 renzhimin7 changed the title Trino dialect supports insert syntax [Feature] Trino dialect supports insert syntax Nov 6, 2024
@renzhimin7 renzhimin7 changed the title [Feature] Trino dialect supports insert syntax Trino dialect supports insert syntax Nov 6, 2024
@renzhimin7 renzhimin7 changed the title Trino dialect supports insert syntax [Feature]Trino dialect supports insert syntax Nov 6, 2024
@wanpengfei-git wanpengfei-git reopened this Nov 8, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment