tajo-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Tajo Wiki] Update of "GettingStarted" by HenrySaputra
Date Thu, 20 Jun 2013 07:27:42 GMT
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
  

Mime
View raw message