Hi Tarun, Like Hive, Tajo does not support single row insertion by INSERT INTO [TABLE NAME] VALES statement. As you can see the answer about update statement, Tajo does not support UPDATE statement.
If you want to load new data to Tajo, you need to use CREATE EXTERNAL TABLE statement as follows: http://tajo.incubator.apache.org/tajo-0.2.0-doc.html#CreateTable create EXTERNAL table lineitem ( L_ORDERKEY bigint, L_PARTKEY bigint, ... L_COMMENT text) USING csv WITH ('csvfile.delimiter'='|','compression.codec'='org.apache.hadoop.io.compress.DeflateCodec') LOCATION 'hdfs://localhost:9010/tajo/warehouse/lineitem_100_snappy'; In addition, you can store the result of a query statement as follows: (http://tajo.incubator.apache.org/tajo-0.2.0-doc.html#InsertOverwrite) INSERT OVERWRITE INTO table1 SELECT a, b, c from table2; or you can create new table from the query result as follows: CREATE TABLE table2 AS SELECT a, b, c FROM ...; - hyunsik On Sat, Nov 30, 2013 at 9:46 PM, Tarun Kumar <[email protected]> wrote: > From documentation it looks like that Tajo doesn't support addition of new > rows in existing table. Just wanted to confirm, it is true? > > > > On Sat, Nov 30, 2013 at 12:26 PM, Tarun Kumar <[email protected]> wrote: > >> Hi, >> >> I couldn't locate anything on http://wiki.apache.org/tajo/QueryLanguagefor >> inserting data into existing table directly (not from any other >> existing table). >> >> I tried : >> >> insert into table1 values(1); // this table has only one column - >> id int >> insert overwrite into table1 values(1); >> >> None of these seem to work. >> >> Also, is there any way to alter table also? >>
