Insert into table from Apache Hive

Question

I'm new to Apache Hive. I have installed Hadoop in pseudo-distributed mode and installed Hive after that. Then I was trying to create a table and then insert some values into it using query. The table creation had no problem but while inserting values into the table, the process gets stuck.

This is the query is :

hive> create table Students
    > (StudentID INT,
    > firstname VARCHAR(50),
    > LastName VARCHAR(50),
    > Gender Char(1),
    > Email VARCHAR(100));
OK
Time taken: 0.364 seconds

But when inserting values:

hive> INSERT INTO Students
    > VALUES
    > (1,'Janani','Ravi','F','[email protected]'),
    > (2,'Swetha','Kollalapudi','F','Swetha@loonycorn'),
    > (3,'Navdeep','Singh','M','[email protected]'),
    > (4,'Vitthal','Srinivasan','M','[email protected]');
WARNING: Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.
Query ID = neron_20180515174044_74a1eaaa-5d42-4267-9261-ff66bd20e215
Total jobs = 3
Launching Job 1 out of 3
Number of reduce tasks is set to 0 since there's no reduce operator
Starting Job = job_1526382077653_0002, Tracking URL = http://neron-Latitude-3580:8088/proxy/application_1526382077653_0002/
Kill Command = /home/neron/ProgramFiles/Hadoop/hadoop-3.1.0/bin/hadoop job  -kill job_1526382077653_0002

I'm getting this result and this process stucks there.

This is the tracking result:

Am I done anything wrong or what is the problem with this?

Anup Anup · Accepted Answer · 2018-05-15T12:41:05

You can not directly insert data like that. You have to several other alternatives for achieving the same in hive. Please refer: this post

Insert into table from Apache Hive

2 Answers