Even though the main requirement is addressed based on the choice of selected answer, thought I should log this for reference in the future: 0: jdbc:hive2://node1.hortonworks.com:10000/d> select * from src;
+----------+------------+--+
| src.key | src.value |
+----------+------------+--+
| 1 | Value1 |
| 2 | Value2 |
+----------+------------+--+
2 rows selected (0.187 seconds)
0: jdbc:hive2://node1.hortonworks.com:10000/d> select * from tgt;
+----------+------------+--+
| tgt.key | tgt.value |
+----------+------------+--+
+----------+------------+--+
No rows selected (0.154 seconds)
0: jdbc:hive2://node1.hortonworks.com:10000/d> from (from src select transform(src.key,src.value) using '/bin/cat' as (tkey,tvalue) )tmap insert overwrite table tgt select tkey,tvalue;
INFO : Tez session hasn't been created yet. Opening session
INFO : Dag name: from (from src select transfor...tkey,tvalue(Stage-1)
INFO :
INFO : Status: Running (Executing on YARN cluster with App id application_1471888656011_0009)
INFO : Map 1: -/-
INFO : Map 1: 0/1
INFO : Map 1: 0/1
INFO : Map 1: 0(+1)/1
INFO : Map 1: 1/1
INFO : Loading data to table default.tgt from hdfs://node1.hortonworks.com:8020/apps/hive/warehouse/tgt/.hive-staging_hive_2016-08-25_21-51-10_715_1000932141605500109-1/-ext-10000
INFO : Table default.tgt stats: [numFiles=1, numRows=2, totalSize=18, rawDataSize=16]
No rows affected (19.992 seconds)
0: jdbc:hive2://node1.hortonworks.com:10000/d> select * from tgt;
+----------+------------+--+
| tgt.key | tgt.value |
+----------+------------+--+
| 1 | Value1 |
| 2 | Value2 |
+----------+------------+--+
2 rows selected (0.197 seconds)
... View more
