THIS IS A TEST INSTANCE. ALL YOUR CHANGES WILL BE LOST!!!!
...
Code Block |
---|
SET 'sql-gateway.table-dynamic-option-provider-factory'='jdbc-security-provider'; // Set the jdbc security provider for Sql-Gateway CREATE TABLE my_jdbc_table ( val1 INT, val2 INT) WITH ( 'connector' = 'jdbc', 'url' = 'jdbc:mysql://localhost:3306/test', 'table-name' = 'mysql_table' //'username' = '****' We don't need to provide username and password in DDL here and the security provider above will generate the `username` and `password` options for my_jdbc_tablejobs here //'password' = '****' ); INSERT INTO my_jdbc_table SELECT ... FROM ... GROUP BY ...; |
...