*****************************
Introducing to TSQL
*****************************

==========
Synopsis
==========

.. code-block:: bash

  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.