forked from DTStack/dt-sql-parser
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathsyntaxSuggestion.sql
More file actions
53 lines (27 loc) · 892 Bytes
/
syntaxSuggestion.sql
File metadata and controls
53 lines (27 loc) · 892 Bytes
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
DROP CATALOG cat;
SELECT * FROM cat. ;
CREATE TABLE cat.db ;
SHOW TABLES FROM cat;
ALTER DATABASE cat.;
DROP VIEW v;
SELECT * FROM ;
CREATE VIEW cv;
SELECT name, calculate_age(birthdate) AS age FROM students;
CREATE FUNCTION fnc;
SHOW COLUMNS FROM vie;
SHOW CREATE TABLE tb1;
SHOW CREATE VIEW v1;
SELECT col ;
SELECT col FROM tb1;
SELECT col, FROM tb1;
SELECT * FROM tb ORDER BY ;
SELECT * FROM tb GROUP BY ;
INSERT INTO tb (col, tb.c );
CREATE TABLE yourTable (ts TIMESTAMP(3), WATERMARK FOR );
CREATE TABLE newTable ( );
SELECT SUM(amount) FROM Orders GROUP BY length(users) HAVING SUM(amount) > 50;
SELECT * FROM Orders ORDER BY orderTime LIMIT length(order_id);
SELECT age CASE WHEN age < 18 THEN 1 ELSE 0 END AS is_minor FROM dt_catalog.dt_db.subscriptions;
CREATE TABLE tmp_table (col INT) WITH ('connector'='kafka');
SELECT FROM tb1;
SELECT age FROM tb1;