sql-machine-learning / sqlflow

Brings SQL and AI together.
https://sqlflow.org
Apache License 2.0
5.09k stars 699 forks source link

Support ODPS Query settings in SQLFlow SQL #769

Closed Yancey1989 closed 5 years ago

Yancey1989 commented 5 years ago

Is your feature request related to a problem? Please describe. In some scenarios, The MaxCompute can set runtime settings while executing the query, ref here

Describe the solution you'd like In my opinion, SQLFLow can allow users to specify the query settings on the client-side like:

odps.sql.type.system.odps2=true;
CREATE TABLE xxxx
tonyyang-svail commented 5 years ago

The server splits multiple SQL statements according to ; token. Adding support for query settings will break this splitting strategy.

I suggest putting this feature on hold.