Reply
New Contributor
Posts: 4
Registered: ‎02-27-2015

Loading Data into Hive is taking more time ( more or less system is hanging).

1] Execute this command in $ prompt

hdfs dfs -ls /user/hdfs/incomingrawdata

2] Execute the below command in HIVE prompt,first type HIVE in $ PROMPT

CREATE DATABASE IF NOT EXISTS US5G;
CREATE TABLE IF NOT EXISTS US5G.Tenor(
ID_Tenor SMALLINT
,IsPseudo BOOLEAN
,TenorName STRING
,StartPeriodType STRING
,StartPeriodLength SMALLINT
,StartDateOverride TIMESTAMP
,EndPeriodType STRING
,EndPeriodLength SMALLINT
,EndDateOverride TIMESTAMP
,TenorStartCode STRING
,TenorEndCode STRING
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '|';

 

LOAD DATA INPATH '/user/hdfs/incomingrawdata/US5G_Tenor.txt'
INTO TABLE US5G.Tenor;

Cloudera Employee
Posts: 16
Registered: ‎01-27-2015

Re: Loading Data into Hive is taking more time ( more or less system is hanging).

Hi Parthiban,

 

Could you answer the following questions to help troubleshoot this issue?

- What's the version of CDH you're using?

- Is HDFS encryption enabled?

- What's the size of file /user/hdfs/incomingrawdata/US5G_Tenor.txt?

- Is there an error on hive.log that you see? Could you upload the hive.log?