Since the previous Hive version faced a lot of problems in inserting values in a table in Hive.
The latest updated version of Hive(with ACID support) has arrived, where we can directly insert values into Hive table.
CREATE TABLE player (name VARCHAR(64), age INT);
INSERT INTO TABLE player
VALUES ('Amit', 25), ('Prateek', 24);
But still, if your system doesn’t support the queries, just follow the syntax below and make sure that you have a minimum 0.14 version of Hive.
INSERT INTO TABLE tablename [PARTITION (partcol1[=val1], partcol2[=val2] ...)] VALUES values_row [, values_row ...]
Where values_row is:
( value [, value ...] )
where value is either null or any valid SQL literal
If you are a beginner in Hive, you can refer to the following video which will teach you Hive from scratch: