Introducing to TSQL

Synopsis

bin/tsql [options] [database name]

If a database_name is given, tsql connects to the database at startup time. Otherwise, tsql connects to default database.

Options

  • -c "quoted sql" : Execute quoted sql statements, and then the shell will exist.
  • -f filename (--file filename) : Use the file named filename as the source of commands instead of interactive shell.
  • -h hostname (--host hostname) : Specifies the host name of the machine on which the Tajo master is running.
  • -p port (--port port) : Specifies the TCP port. If it is not set, the port will be 26002 by default.
  • -conf configuration (--conf configuration) : Setting Tajo configuration value.
  • -param parameter (--param parameter) : Use a parameter value in SQL file.
  • -B (--background) : Execute as background process.

Entering tsql shell

If the hostname and the port num are not given, tsql will try to connect the Tajo master specified in ${TAJO_HOME}/conf/tajo-site.xml.

bin/tsql

default>

If you want to connect a specified TajoMaster, you should use ‘-h’ and (or) ‘p’ options as follows:

bin/tsql -h localhost -p 9004

default>

The prompt indicates the current database.