To avoid maintain sqlflow.proto file in the separated repo

Question

To avoid maintain sqlflow.proto file in the separated repo

Yancey1989 opened this issue 5 years ago · 6 comments

Yancey1989 commented 5 years ago

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

Answer 1 · 2019-06-20T04:49:12.000Z

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

Answer 2 · 2019-06-20T14:00:46.000Z

Just for discussion: #70 (comment)

Answer 3 · 2019-07-03T03:00:00.000Z

How can I run extended SQL using pysqlflow

Answer 4 · 2019-07-03T03:03:38.000Z

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

Answer 5 · 2019-07-03T03:59:29.000Z

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?

Answer 6 · 2019-07-03T05:23:01.000Z

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.