sql-machine-learning/pysqlflow

Support for command line

BlackPoint-CX opened this issue · 2 comments

BlackPoint-CX commented

Description:
SQLFlow should support command line like 'hive -e ' or 'hive -f '.
It could help developer or other users to schedule the running of SQLFlow task.

tonyyang-svail commented

Hi @BlackPoint-CX, thanks for the issue. This is a great suggestion. The command line belongs to the pysqlflow, so I am transferring this issue there.

tonyyang-svail commented

Actually, there is already a command line sqlflow. If you type sqlflow -h in our docker image, you should be able to see the following.

sqlflow -h
usage: sqlflow [-h] [--url URL] [--ca_crt CA_CRT] sql [sql ...]

positional arguments:
  sql              sql

optional arguments:
  -h, --help       show this help message and exit
  --url URL        server url
  --ca_crt CA_CRT  Path to CA certificates of SQLFlow client.

However, I just realize there is a bug in our command line, so I am filing a PR to fix it.

The updated command line should be available in the next release.

@Yancey1989 Let's aim to release it together with sql-machine-learning/sqlflow#966 next week.