Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Use "SELECT" command to executes a select SQL statement. The shell uses a logging view to display the result for now (table view will be supported in the future and users will be allowed to choose among various views by the SET command). 

// TODO: INSERT A SELECT VIEW HERE

...

Use "INSERT INTO" to execute an INSERT INTO statement. User gets an execution ID if this non-query statement is submitted successfully, and they can use the ID to control the execution later.
Use "LIST" command to list all the non-query executions that have been executed. It displays the ID, status and original statement of the execution. You can also use “LS [id1, id2...]” to list specific executions.
Use "STOP" command to stop the specified execution(s).
Use "RM" command to remove stopped executions(s) that from showing in the future.

SET: Use “SET”  “SET” command to display the name and value of all environment variables that impacts the behavior of the shell and the "SqlExecutor". Use “SET <<name>=<value>>” to set a variable.   These environment variables can also be set in the configuration file, namely "conf/shell-defaults.conf".


CLEAR: Clears the screen.   
EXIT/QUIT: Quits the shell.

...