Re: Multi Table Join & count Distinct

2012-05-21 Thread Nitin Pawar
try removing C1,C2 and C3 from select count should give you exactly one output, where as c1,c2,c3 may vary as per table On Tue, May 22, 2012 at 5:02 AM, cmdr taco wrote: > When I try to run below query, but for some reason I'm > getting weird results for the C2_CNT, its not giving distinct va

Re: how to create index on hbase?

2012-05-21 Thread Abhishek Pratap Singh
Does Hbase support secondary indexes? I don't think so!!! I m not sure you can create indexes in Hbase even if it is integrated with hive. Regards, Abhishek On Sun, May 13, 2012 at 7:10 PM, Hezhiqiang (Ransom) < ransom.hezhiqi...@huawei.com> wrote: > Hi all > I want to create index on hbase, bu

Re: Reduce operation stuck

2012-05-21 Thread Abhishek Pratap Singh
Can you paste the logs here? Abhishek On Sun, May 20, 2012 at 9:36 AM, Balaji Rao wrote: > There is only one task attempt that is lurking around and that never > completes. It probably times out or fails after a long time. > > -Balaji > > On Fri, May 18, 2012 at 11:50 PM, Ranjith > wrote: > >

How to Write a Simple SerDe?

2012-05-21 Thread Rubin, Bradley S.
My Hadoop MR job emits a value with three primitives via a custom Writable (see below). How do I write a corresponding custom SerDe so that Hive can read the output from HDFS? I can find complex SerDe examples (RegEx, JSON), but I can't find something simple to model from. I think that my cre

Re: user define data format

2012-05-21 Thread Bejoy Ks
Hi Richard       In hive the default record delimiter is the next line character. In your sample data set, a single row/record is spread across multiple lines. AFAIK The only possible option here is to write a custom serde for your data. Regards Bejoy KS From

user define data format

2012-05-21 Thread Richard
Hi, I want to use Hive on some data in the following format: \0x01 field1=val1\0x01 field2=val2\0x01 ... \0x01 the lines between and are a record. How should I define the table? thanks. Richard