Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # user - Data Loaded but Select returns nothing!


Copy link to this message
-
RE: Data Loaded but Select returns nothing!
Connell, Chuck 2012-07-30, 13:04
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:[EMAIL PROTECTED]]
Sent: Monday, July 30, 2012 7:59 AM
To: [EMAIL PROTECTED]
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