Re: Data Loaded but Select returns nothing!

2012-07-30 Thread Bejoy KS
, please excuse typos. -Original Message- From: Kuldeep Chitrakar Date: Mon, 30 Jul 2012 08:02:16 To: user@hive.apache.org; bejoy...@yahoo.com Reply-To: user@hive.apache.org Subject: RE: Data Loaded but Select returns nothing! Hi Bejoy, I modified the load command as below LOAD DATA LOC

RE: Data Loaded but Select returns nothing!

2012-07-30 Thread Kuldeep Chitrakar
I come across. Let me know if I am wrong. Thanks, Kuldeep From: Kuldeep Chitrakar [mailto:kuldeep.chitra...@synechron.com] Sent: 30 July 2012 18:32 To: user@hive.apache.org; bejoy...@yahoo.com Subject: RE: Data Loaded but Select returns nothing! Hi Bejoy, I modified the load command as below

RE: Data Loaded but Select returns nothing!

2012-07-30 Thread Connell, Chuck
, 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

RE: Data Loaded but Select returns nothing!

2012-07-30 Thread Kuldeep Chitrakar
. Thanks, Kuldeep From: Bejoy KS [mailto:bejoy...@yahoo.com] Sent: 30 July 2012 17:45 To: user@hive.apache.org Subject: Re: Data Loaded but Select returns nothing! Kuldeep Couple of things I hoticed here are Your table is bucketed, when you load data into a bucketed table you need to enable

RE: Data Loaded but Select returns nothing!

2012-07-30 Thread Kuldeep Chitrakar
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

Re: Data Loaded but Select returns nothing!

2012-07-30 Thread Bejoy KS
0 Jul 2012 06:58:33 To: user@hive.apache.org Reply-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

RE: Data Loaded but Select returns nothing!

2012-07-30 Thread Matouk Iftissen
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 noth

Data Loaded but Select returns nothing!

2012-07-30 Thread Kuldeep Chitrakar
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)