Basic usagesÂ¶

-f command allows tsql to execute more than one SQL statements stored in a text file as follows:

$ cat aggregation.sql
 select count(*) from table1;
 select sum(score) from table1;

Modified: tajo/site/docs/devel/tsql/intro.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/intro.html?rev=1682226&r1=1682225&r2=1682226&view=diff
==============================================================================
--- tajo/site/docs/devel/tsql/intro.html (original)
+++ tajo/site/docs/devel/tsql/intro.html Thu May 28 12:22:19 2015
@@ -202,16 +202,16 @@
 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.
+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.
+-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.

Modified: tajo/site/docs/devel/tsql/meta_command.html URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/meta_command.html?rev=1682226&r1=1682225&r2=1682226&view=diff ============================================================================== --- tajo/site/docs/devel/tsql/meta_command.html (original) +++ tajo/site/docs/devel/tsql/meta_command.html Thu May 28 12:22:19 2015 @@ -242,7 +242,7 @@ Documentations

Basic usagesÂ¶

\l command shows a list of all databases as follows:

default> \l
 default
 tpch
@@ -250,7 +250,7 @@ work1
 default>
 

\d command shows a list of tables in the current database as follows:

default> \d
 customer
 lineitem
@@ -262,7 +262,7 @@ region
 supplier
 

\d [table name] command also shows a table description as follows:

default> \d orders
 
 table name: orders
@@ -282,13 +282,13 @@ o_shippriority  INT4
 o_comment       TEXT
 

The prompt default> indicates the current database. Basically, all SQL statements and meta commands work in the current database. Also, you can change the current database with \c command.

default> \c work1
 You are now connected to database "test" as user "hyunsik".
 work1>
 

\df command shows a list of all built-in functions as follows:

default> \df
  Name            | Result type     | Argument types        | Description                                   | Type
 -----------------+-----------------+-----------------------+-----------------------------------------------+-----------
@@ -306,7 +306,7 @@ work1>
 For Reference, many details have been omitted in order to present a clear picture of the process.
 

\df [function name] command also shows a function description as follows:

default> \df round;
  Name            | Result type     | Argument types        | Description                                   | Type
 -----------------+-----------------+-----------------------+-----------------------------------------------+-----------

Modified: tajo/site/docs/devel/tsql/single_command.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/single_command.html?rev=1682226&r1=1682225&r2=1682226&view=diff
==============================================================================
--- tajo/site/docs/devel/tsql/single_command.html (original)
+++ tajo/site/docs/devel/tsql/single_command.html Thu May 28 12:22:19 2015
@@ -197,7 +197,7 @@
             
   
 Executing a single commandÂ¶
-You may want to run more queries without entering tsql prompt. Tsql provides the -c argument for above requirement. And Tajo assumes that queries are separated by semicolon as follows:
+You may want to run more queries without entering tsql prompt. Tsql provides the -c argument for above requirement. And Tajo assumes that queries are separated by semicolon as follows:
 $ bin/tsql  -c "select count(*) from table1; select sum(score) from table1;"
 Progress: 0%, response time: 0.217 sec
 Progress: 0%, response time: 0.218 sec

Modified: tajo/site/docs/devel/tsql/variables.html
URL: http://svn.apache.org/viewvc/tajo/site/docs/devel/tsql/variables.html?rev=1682226&r1=1682225&r2=1682226&view=diff
==============================================================================
--- tajo/site/docs/devel/tsql/variables.html (original)
+++ tajo/site/docs/devel/tsql/variables.html Thu May 28 12:22:19 2015
@@ -198,7 +198,7 @@
   
 Session VariablesÂ¶
 Each client connection to TajoMaster creates a unique session, and the client and TajoMaster uses the session until disconnect. A session provides session variables which are used for various configs per session.
-tsql provides the meta command \set to manipulate session variables. Just \set command shows all session variables.
+tsql provides the meta command \set to manipulate session variables. Just \set command shows all session variables.
 default> \set
 'name1'='val1'
 'name2'='val2'
@@ -206,7 +206,7 @@
      ...
 
 
-\set key val will set the session variable named key with the value val.
+\set key val will set the session variable named key with the value val.
 default> \set
 'CURRENT_DATABASE'='default'
 
@@ -217,41 +217,41 @@ default> \set
 'key1'='val1'
 
 
-Also, \unset key will unset the session variable named key.
+Also, \unset key will unset the session variable named key.
 Now, tajo provides the following session variables.
 
-DIST_QUERY_BROADCAST_JOIN_THRESHOLD
-DIST_QUERY_JOIN_TASK_VOLUME
-DIST_QUERY_SORT_TASK_VOLUME
-DIST_QUERY_GROUPBY_TASK_VOLUME
-DIST_QUERY_JOIN_PARTITION_VOLUME
-DIST_QUERY_GROUPBY_PARTITION_VOLUME
-DIST_QUERY_TABLE_PARTITION_VOLUME
-EXECUTOR_EXTERNAL_SORT_BUFFER_SIZE
-EXECUTOR_HASH_JOIN_SIZE_THRESHOLD
-EXECUTOR_INNER_HASH_JOIN_SIZE_THRESHOLD
-EXECUTOR_OUTER_HASH_JOIN_SIZE_THRESHOLD
-EXECUTOR_GROUPBY_INMEMORY_HASH_THRESHOLD
-MAX_OUTPUT_FILE_SIZE
-CODEGEN
-CLIENT_SESSION_EXPIRY_TIME
-CLI_MAX_COLUMN
-CLI_NULL_CHAR
-CLI_PRINT_PAUSE_NUM_RECORDS
-CLI_PRINT_PAUSE
-CLI_PRINT_ERROR_TRACE
-CLI_OUTPUT_FORMATTER_CLASS
-CLI_ERROR_STOP
-TIMEZONE
-DATE_ORDER
-TEXT_NULL
-DEBUG_ENABLED
-TEST_BROADCAST_JOIN_ENABLED
-TEST_JOIN_OPT_ENABLED
-TEST_FILTER_PUSHDOWN_ENABLED
-TEST_MIN_TASK_NUM
-BEHAVIOR_ARITHMETIC_ABORT
-RESULT_SET_FETCH_ROWNUM
+DIST_QUERY_BROADCAST_JOIN_THRESHOLD
+DIST_QUERY_JOIN_TASK_VOLUME
+DIST_QUERY_SORT_TASK_VOLUME
+DIST_QUERY_GROUPBY_TASK_VOLUME
+DIST_QUERY_JOIN_PARTITION_VOLUME
+DIST_QUERY_GROUPBY_PARTITION_VOLUME
+DIST_QUERY_TABLE_PARTITION_VOLUME
+EXECUTOR_EXTERNAL_SORT_BUFFER_SIZE
+EXECUTOR_HASH_JOIN_SIZE_THRESHOLD
+EXECUTOR_INNER_HASH_JOIN_SIZE_THRESHOLD
+EXECUTOR_OUTER_HASH_JOIN_SIZE_THRESHOLD
+EXECUTOR_GROUPBY_INMEMORY_HASH_THRESHOLD
+MAX_OUTPUT_FILE_SIZE
+CODEGEN
+CLIENT_SESSION_EXPIRY_TIME
+CLI_MAX_COLUMN
+CLI_NULL_CHAR
+CLI_PRINT_PAUSE_NUM_RECORDS
+CLI_PRINT_PAUSE
+CLI_PRINT_ERROR_TRACE
+CLI_OUTPUT_FORMATTER_CLASS
+CLI_ERROR_STOP
+TIMEZONE
+DATE_ORDER
+TEXT_NULL
+DEBUG_ENABLED
+TEST_BROADCAST_JOIN_ENABLED
+TEST_JOIN_OPT_ENABLED
+TEST_FILTER_PUSHDOWN_ENABLED
+TEST_MIN_TASK_NUM
+BEHAVIOR_ARITHMETIC_ABORT
+RESULT_SET_FETCH_ROWNUM

Executing Queries from FilesÂ¶

Basic usagesÂ¶

Basic usagesÂ¶

Executing a single commandÂ¶

Session VariablesÂ¶