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.chitra...@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
