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/06/20 09:27:42 UTC

[Tajo Wiki] Update of "GettingStarted" by HenrySaputra

Dear Wiki user,

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

The "GettingStarted" page has been changed by HenrySaputra:
http://wiki.apache.org/tajo/GettingStarted?action=diff&rev1=5&rev2=6

Comment:
Add semicolon to commands run in CLI due to commit for TAJO-7

  {{{
  $ $TAJO_HOME/bin/tajo cli
  
- tajo> create external table table1 (id int, name text, score float, type text) using csv with ('csvfile.delimiter'='|') location 'file:/home/x/table1'
+ tajo> create external table table1 (id int, name text, score float, type text) using csv with ('csvfile.delimiter'='|') location 'file:/home/x/table1';;
  }}}
  
  In order to load an external table, you need to use 'create external table' statement. In the location clause, you should use the absolute directory path with an appropriate scheme. If the table resides in HDFS, you should use 'hdfs' instead of 'file'.
  
  If you want to know DDL statements in more detail, please see Query Language.
  {{{
- tajo> /t
+ tajo> /t;
  table1
  }}}
  
  '/t' command shows the list of tables.
  
  {{{
- tajo> /d table1
+ tajo> /d table1;
  
  table name: table1
  table path: file:/home/x/table1
@@ -155, +155 @@

  Now, you can execute SQL queries as follows:
  
  {{{
- tajo> select * from table1 where id > 2
+ tajo> select * from table1 where id > 2;
  final state: QUERY_SUCCEEDED, init time: 4.118 sec, execution time: 4.334 sec, total response time: 8.452 sec
  result: hdfs://x.x.x.x:8020/user/x/tajo/q_1363768615503_0001_000001