Hi I am using Hive CLI (Cloudera VM). Yes i am using Hive from /user/bin
Thanks, Kuldeep From: Matouk Iftissen [mailto:miftis...@cyres.fr] Sent: 30 July 2012 17:44 To: user@hive.apache.org Subject: RE: Data Loaded but Select returns nothing! 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<mailto: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
