hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matouk Iftissen <miftis...@cyres.fr>
Subject RE: Data Loaded but Select returns nothing!
Date Mon, 30 Jul 2012 12:13:40 GMT
What do you use CLI (from command) or UI like HUE ? if you use CLI make sure that you are in
hive cmd (......./bin /hive>)

De : Kuldeep Chitrakar [mailto:kuldeep.chitrakar@synechron.com]
Envoyé : lundi 30 juillet 2012 13:59
À : user@hive.apache.org
Objet : Data Loaded but Select returns nothing!

Hi

I am trying to load a CSV file into HIve table.

Everything works fine but when a fire "select * from tablename" command. It does not retun
anything.

--Create Table

CREATE TABLE IF NOT EXISTS learn.crime_managed_native (
NoState String,
TypeofCrime String,
Crime String,
Year int,
Count int)
PARTITIONED BY (State String)
CLUSTERED BY (Crime) SORTED BY (Year ASC) INTO 8 BUCKETS
ROW FORMAT DELIMITED FIELDS TERMINATED BY ','
STORED AS TEXTFILE;

--Load Data

LOAD DATA LOCAL INPATH '/home/cloudera/CrimeHive.csv' INTO TABLE crime_managed_native;

What could be the possible issue.

Thanks,
Kuldeep




Mime
View raw message