Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

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

New Contributor

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;

1 REPLY 1

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

Cloudera Employee

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?