That doc link is wrong. VALUES clause works with any table. hive> create table T(a int, b int);
OK
Time taken: 0.326 seconds
hive> insert into T values(1,2),(3,4);
Query ID = cstm-hdfs_20170127172630_99a0bfa1-6f10-427b-aed1-fd0648f02f73
Total jobs = 1
Launching Job 1 out of 1
Status: Running (Executing on YARN cluster with App id application_1485331877667_0022)
--------------------------------------------------------------------------------
VERTICES STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED
--------------------------------------------------------------------------------
Map 1 .......... SUCCEEDED 1 1 0 0 0 0
--------------------------------------------------------------------------------
VERTICES: 01/01 [==========================>>] 100% ELAPSED TIME: 7.62 s
--------------------------------------------------------------------------------
Loading data to table tpch.t
Table tpch.t stats: [numFiles=1, numRows=2, totalSize=8, rawDataSize=6]
OK
Time taken: 9.487 seconds
hive> select * from T;
OK
1 2
3 4
Time taken: 0.232 seconds, Fetched: 2 row(s)
hive>
... View more
