dp api
06/21/2023, 4:49 PMjdbc_url = os.environ.get('MYSQL_JDBC_URL')
jdbc_table_name = os.environ.get('MYSQL_TABLE_NAME')
jdbc_username = os.environ.get('MYSQL_USERNAME')
jdbc_password = os.environ.get('MYSQL_PASSWORD')
sink_mysql = f"""
CREATE TABLE pending_orders_table (
rest_id VARCHAR,
pending_count INT,
PRIMARY KEY (rest_id) NOT ENFORCED
) WITH (
'connector' = 'jdbc',
'url' = '{jdbc_url}',
'table-name' = '{jdbc_table_name}',
'username' = '{jdbc_username}',
'password' = '{jdbc_password}'
)
"""
t_env.execute_sql(sink_mysql)
I am getting an error when I am running this script in a docker container with environment variables set accordingly.
The error is something like -
Caused by: org.apache.flink.sql.parser.impl.ParseException: Encountered "jdbc" at line 8, column 19.
Was expecting one of:
"UESCAPE" ...
<QUOTED_STRING> ...
")" ...
"," ...
What needs to be changed syntactically for this ?
Thanks in advance!!