Saturday, 1 August 2020

Multiple Row Insertion in Hive

create table sare (id int, name string);

insert into sare values (100,'Raja'),(101,'Ravi'),(102,'Siva')

hive> select * from sare;
OK
100 Raja
101 Ravi
102 Siva
Time taken: 0.127 seconds, Fetched: 3 row(s)
 

No comments:

Post a Comment

Flume - Simple Demo

// create a folder in hdfs : $ hdfs dfs -mkdir /user/flumeExa // Create a shell script which generates : Hadoop in real world <n>...