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 ==