pysqlflow icon indicating copy to clipboard operation
pysqlflow copied to clipboard

To avoid maintain sqlflow.proto file in the separated repo

Open Yancey1989 opened this issue 5 years ago • 6 comments

Mabe adds the sqlflow repo as the submodule of pysqlflow is a good way.

Yancey1989 avatar Jun 19 '19 11:06 Yancey1989

I believe it is better to have a little duplication than importing a huge library for a single file. :) ref

tonyyang-svail avatar Jun 20 '19 04:06 tonyyang-svail

Just for discussion: https://github.com/sql-machine-learning/pysqlflow/pull/70#issuecomment-504036707

typhoonzero avatar Jun 20 '19 14:06 typhoonzero

How can I run extended SQL using pysqlflow

LiuGuodong1314 avatar Jul 03 '19 03:07 LiuGuodong1314

Hi @LiuGuodong1314 , you can use the all-in-one Docker image, please go to https://github.com/sql-machine-learning/sqlflow/blob/develop/doc/demo.md

Yancey1989 avatar Jul 03 '19 03:07 Yancey1989

Hi @Yancey1989, I execute "SELECT * FROM iris.train TRAIN DNNClassifier WITH n_classes = 3 COLUMN sepal_length, sepal_width, petal_length, petal_width LABEL class INTO sqlflow_models.my_dnn_model" in python language using pysqlflow, but it throws "runExec failed: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version ...." How can I manage it?

LiuGuodong1314 avatar Jul 03 '19 03:07 LiuGuodong1314

It seems that the extended SQL should be ... WITH n_classes = 3, hidden_units = [10, 20] COLUMN ... ? And your problem is not related to this issue, maybe you can recreate an issue at https://github.com/sql-machine-learning/sqlflow/issues if the problem persists.

Yancey1989 avatar Jul 03 '19 05:07 Yancey1989