Re: Hive query result in sequence file

2012-01-25 Thread jingjung Ng
. > > Thanks, > Aniket > > > On Tue, Jan 24, 2012 at 11:41 PM, jingjung Ng wrote: > >> Hi, >> >> I have following hive query (pseudo hive query code) >> >> select name, address, phone from t1 join t2 >> >> Executing above query will end up fi

Hive query result in sequence file

2012-01-24 Thread jingjung Ng
Hi, I have following hive query (pseudo hive query code) select name, address, phone from t1 join t2 Executing above query will end up file stored in the format of name, address, phone format on the fie system (hdfs or local). However I'd like to write to either to a sequence file (key: name,

Re: hive select count(*) query exception

2011-12-17 Thread jingjung Ng
ion.FsPermission$2.())' > > - Alex > > On Fri, Dec 16, 2011 at 8:59 AM, jingjung Ng wrote: > > Hi, > > > > I have simple hive select count(*) query,which results in the following > > exception. I am using Cloudera cdh3u1 ( hadoop/hbase/hive). However I am

Re: hive select count(*) query exception

2011-12-16 Thread jingjung Ng
- Alex > > On Fri, Dec 16, 2011 at 8:59 AM, jingjung Ng wrote: > > Hi, > > > > I have simple hive select count(*) query,which results in the following > > exception. I am using Cloudera cdh3u1 ( hadoop/hbase/hive). However I am > > able to do "select * from

hive select count(*) query exception

2011-12-16 Thread jingjung Ng
Hi, I have simple hive select count(*) query,which results in the following exception. I am using Cloudera cdh3u1 ( hadoop/hbase/hive). However I am able to do "select * from t1" from hive CLI. Here is output after running "select count(*) from t1". hive> select count(*) from t1; Total MapReduce