+1 vote
in Big Data | Hadoop by

Insert

Inserting data into a table.

To avoid any transactional issue, create table in this way.

hive> create table records (name string,age int,cgpa decimal(3,2))clustered by (age) into 2 buckets stored as orc tblproperties('transactional'='true');

hive> insert into table records values('john Cena',45,8.02),('batista',48,8.96);

hive> select * from records;
OK
batista    48    8.96
john Cena    45    8.02
Time taken: 0.109 seconds, Fetched: 2 row(s)

Related questions

0 votes
asked Apr 3, 2020 in Big Data | Hadoop by Tate
0 votes
asked Mar 10, 2020 in Big Data | Hadoop by Hodge
...