`jdbc_url = os.environ.get('MYSQL_JDBC_URL')` ...
# troubleshooting
d
jdbc_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!!