hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Connell, Chuck" <Chuck.Conn...@nuance.com>
Subject RE: Data Loaded but Select returns nothing!
Date Mon, 30 Jul 2012 13:04:41 GMT
An idea, in addition to what others have said...   You are starting with a complex table schema.
Start simpler, test it as you go, and then work up to partitions and buckets. That way you
make sure you have the basic features working correctly.

Chuck Connell
Nuance R&D Data Team
Burlington, MA



From: Kuldeep Chitrakar [mailto:kuldeep.chitrakar@synechron.com]
Sent: Monday, July 30, 2012 7:59 AM
To: user@hive.apache.org
Subject: 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