I got an error while creating table using select query, step by this doc:
mysql jdbc 5.1
starrocks 2.5.10
my query
CREATE TABLE if not exists db.tmp_table
PRIMARY KEY(id)
COMMENT 'temp table'
PROPERTIES (
"replication_num" = "1"
)
AS SELECT
*,
'2024' cur_year
FROM db.source_table;
[42000][1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<EOF>' at line 7
Is the grammar correct or what else caused the syntax error?