You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
(run-remote-test"SELECT 1")
(run-remote-test"describe iris.train")
(run-remote-test"select * from iris.train limit 5")
(run-remote-test"SELECT * FROM iris.test")
(run-remote-test"SELECT * FROM iris.predict LIMIT 5")
Failure
Run predictions and training statements such as
(run-remote-test"SELECT * FROM iris.train TO TRAIN DNNClassifier WITH model.n_classes = 3, model.hidden_units = [10, 10], train.epoch = 10 COLUMN sepal_length, sepal_width, petal_length, petal_width LABEL class INTO sqlflow_models.my_dnn_model")
(run-remote-test"SELECT * FROM iris.test TO PREDICT iris.predict.class USING sqlflow_models.my_dnn_model")
and got the same error message
1. Unhandled io.grpc.StatusRuntimeException
UNKNOWN: runSQLProgram error: syntax error near or before
"sqlflow_models.my_dnn_model". You might want to refer to the
https://sqlflow.org/sqlflow/doc/language_guide
1. Unhandled io.grpc.StatusRuntimeException
UNKNOWN: runSQLProgram error: syntax error near or before
"sqlflow_models.my_dnn_model". You might want to refer to the
https://sqlflow.org/sqlflow/doc/language_guide
I still don't know why I can't run training and prediction sentences.
I try CREATE DATABASE sqlflow_models; before running the two failed statements
(run-remote-test"DROP DATABASE sqlflow_models")
(run-remote-test"CREATE DATABASE sqlflow_models")
;; fail
(run-remote-test"SELECT * FROM iris.train TO TRAIN DNNClassifier WITH model.n_classes = 3, model.hidden_units = [10, 10], train.epoch = 10 COLUMN sepal_length, sepal_width, petal_length, petal_width LABEL class INTO sqlflow_models.my_dnn_model")
(run-remote-test"SELECT * FROM iris.test TO PREDICT iris.predict.class USING sqlflow_models.my_dnn_model")
and got same error, here is the output
"DROP DATABASE sqlflow_models"
"0 row affected"
"CREATE DATABASE sqlflow_models"
"1 row affected"
"SELECT * FROM iris.train TO TRAIN DNNClassifier WITH model.n_classes = 3, model.hidden_units = [10, 10], train.epoch = 10 COLUMN sepal_length, sepal_width, petal_length, petal_width LABEL class INTO sqlflow_models.my_dnn_model"
Execution error (StatusRuntimeException) at io.grpc.Status/asRuntimeException (Status.java:533).
UNKNOWN: runSQLProgram error: syntax error near or before "sqlflow_models.my_dnn_model". You might want to refer to the https://sqlflow.org/sqlflow/doc/language_guide
"SELECT * FROM iris.test TO PREDICT iris.predict.class USING sqlflow_models.my_dnn_model"
Execution error (StatusRuntimeException) at io.grpc.Status/asRuntimeException (Status.java:533).
UNKNOWN: runSQLProgram error: syntax error near or before "sqlflow_models.my_dnn_model". You might want to refer to the https://sqlflow.org/sqlflow/doc/language_guide
According to the SQLFlowRemoteTest test file, I used Clojure to wrap the test process.
Success
Run normal sql query statements such as
Failure
Run predictions and training statements such as
and got the same error message
I still don't know why I can't run training and prediction sentences.
Environment
The text was updated successfully, but these errors were encountered: