Dear Wiki user, You have subscribed to a wiki page or wiki category on "Tajo Wiki" for change notification.
The "QueryLanguage" page has been changed by HyunsikChoi: https://wiki.apache.org/tajo/QueryLanguage?action=diff&rev1=3&rev2=4 [ORDER BY <expression> [ASC|DESC] [NULL FIRST|NULL LAST] [, ...]] }}} - === INSERT === + === INSERT (OVERWRITE) INTO === Tajo provides INSERT OVERWRITE statement like Hive. Tajo's INSERT OVERWRITE statement follows 'INSERT INTO SELECT' statement of SQL. The examples are as follows: @@ -43, +43 @@ create table t1 (col1 int8, col2 int4, col3 float4); -- when a target table schema and output schema are equivalent to each other - insert overwrite into t1 select l_orderkey, l_partkey, l_quantity from lineitem; + INSERT OVERWRITE INTO t1 SELECT l_orderkey, l_partkey, l_quantity FROM lineitem; -- or - INSERT OVERWRITE INTO t1 select * FROM lineitem; + INSERT OVERWRITE INTO t1 SELECT * FROM lineitem; -- when the output schema are smaller than the target table schema INSERT OVERWRITE INTO t1 SELECT l_orderkey FROM lineitem;
