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