You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@tajo.apache.org by Apache Wiki <wi...@apache.org> on 2013/10/19 19:47:02 UTC

[Tajo Wiki] Update of "tsql" by HyunsikChoi

Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Tajo Wiki" for change notification.

The "tsql" page has been changed by HyunsikChoi:
https://wiki.apache.org/tajo/tsql?action=diff&rev1=1&rev2=2

   * -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 9004 in default.
+  * -p '''''port''''' (--port '''''port''''') : Specifies the TCP port. If it is not set, the port will be 26002 in default.
  
  == Entering Tajo Interactive 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.
@@ -17, +17 @@

  {{{
  bin/tsql
  
- 2013-07-07 23:42:27,374 INFO  client.TajoClient (TajoClient.java:connect(76)) - connected to tajo cluster (127.0.0.1:9004)
- 
  tajo>
  }}}
  
  If you want to connect a specified TajoMaster, you should use '-h' and (or) 'p' options as follows:
  {{{
  bin/tsql -h localhost -p 9004
- 2013-07-07 23:43:41,390 INFO  client.TajoClient (TajoClient.java:connect(76)) - connected to tajo cluster (127.0.0.1:9004)
  
  tajo> 
  }}}
@@ -34, +31 @@

  
  In tsql, anything command that begins with an unquoted backslash ('\') is a tsql meta-command that is processed by tsql itself.
  
- ||\d||List tables||
- ||\d '''''table name'''''||Describe a given table||
- ||\q||Quit||
+ In the current implementation, there are meta commands as follows:
+ {{{
+ tajo> \?
+ 
+ General
+   \copyright  show Apache License 2.0
+   \version    show Tajo version
+   \?          show help
+   \q          quit tsql
+ 
+ 
+ Informational
+   \d         list tables
+   \d  NAME   describe table
+ 
+ 
+ Documentations
+   tsql guide        http://wiki.apache.org/tajo/tsql
+   Query language    http://wiki.apache.org/tajo/QueryLanguage
+   Functions         http://wiki.apache.org/tajo/Functions
+   Backup & restore  http://wiki.apache.org/tajo/BackupAndRestore
+   Configuration     http://wiki.apache.org/tajo/Configuration
+ }}}
  
  == Examples ==