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)