Hi,

Does anybody know how to generate a unique ID in Hive? I have a table:
hive> describe results;
OK
id int
test string

Time taken: 0.091 seconds
When I insert data into the table results, i want to generate a unqiue Id,
which is like a sequence in RDBMS.

Regards,
afancy

Please refer https://github.com/twitter/snowflake

On Mon, Nov 15, 2010 at 5:09 PM, afancy <[EMAIL PROTECTED]> wrote:
> Hi,
> Does anybody know how to generate a unique ID in Hive? I have a table:
> hive> describe results;
> OK
> id int
> test string
> Time taken: 0.091 seconds
>
> When I insert data into the table results, i want to generate a unqiue Id,
> which is like a sequence in RDBMS.
> Regards,
> afancy

--
Best Regards

Jeff Zhang

Hi, Zhang,

How to integrate this snowflake <https://github.com/twitter/snowflake> with
Hive?  Thanks!

Regards,
afancy

On Mon, Nov 15, 2010 at 10:35 AM, Jeff Zhang <[EMAIL PROTECTED]> wrote:

> Please refer https://github.com/twitter/snowflake
>
>
>
> On Mon, Nov 15, 2010 at 5:09 PM, afancy <[EMAIL PROTECTED]> wrote:
> > Hi,
> > Does anybody know how to generate a unique ID in Hive? I have a table:
> > hive> describe results;
> > OK
> > id int
> > test string
> > Time taken: 0.091 seconds
> >
> > When I insert data into the table results, i want to generate a unqiue
> Id,
> > which is like a sequence in RDBMS.
> > Regards,
> > afancy
>
>
>
> --
> Best Regards
>
> Jeff Zhang
>

Does it need to be a sequential INT? If not, then a UUID works very well.

Cheers,
Tim
On Tue, Nov 16, 2010 at 8:55 AM, afancy <[EMAIL PROTECTED]> wrote:
> Hi, Zhang,
> How to integrate this snowflake with Hive?  Thanks!
> Regards,
> afancy
>
> On Mon, Nov 15, 2010 at 10:35 AM, Jeff Zhang <[EMAIL PROTECTED]> wrote:
>>
>> Please refer https://github.com/twitter/snowflake
>>
>>
>>
>> On Mon, Nov 15, 2010 at 5:09 PM, afancy <[EMAIL PROTECTED]> wrote:
>> > Hi,
>> > Does anybody know how to generate a unique ID in Hive? I have a table:
>> > hive> describe results;
>> > OK
>> > id int
>> > test string
>> > Time taken: 0.091 seconds
>> >
>> > When I insert data into the table results, i want to generate a unqiue
>> > Id,
>> > which is like a sequence in RDBMS.
>> > Regards,
>> > afancy
>>
>>
>>
>> --
>> Best Regards
>>
>> Jeff Zhang
>
>

Hi, Tim,

I think sequential integer would be better. Is it difficult to generate a
global integer?
BTW: how to generate UUID in Hive? thanks

Regards,
afancy

On Tue, Nov 16, 2010 at 9:11 AM, Tim Robertson <[EMAIL PROTECTED]>wrote:

> Does it need to be a sequential INT? If not, then a UUID works very well.
>
> Cheers,
> Tim
>
>
> On Tue, Nov 16, 2010 at 8:55 AM, afancy <[EMAIL PROTECTED]> wrote:
> > Hi, Zhang,
> > How to integrate this snowflake with Hive?  Thanks!
> > Regards,
> > afancy
> >
> > On Mon, Nov 15, 2010 at 10:35 AM, Jeff Zhang <[EMAIL PROTECTED]> wrote:
> >>
> >> Please refer https://github.com/twitter/snowflake
> >>
> >>
> >>
> >> On Mon, Nov 15, 2010 at 5:09 PM, afancy <[EMAIL PROTECTED]> wrote:
> >> > Hi,
> >> > Does anybody know how to generate a unique ID in Hive? I have a table:
> >> > hive> describe results;
> >> > OK
> >> > id int
> >> > test string
> >> > Time taken: 0.091 seconds
> >> >
> >> > When I insert data into the table results, i want to generate a unqiue
> >> > Id,
> >> > which is like a sequence in RDBMS.
> >> > Regards,
> >> > afancy
> >>
> >>
> >>
> >> --
> >> Best Regards
> >>
> >> Jeff Zhang
> >
> >
>

Write a UDF that generates a UUID in Java

something like this:

@description(name = "uuid", value = "_FUNC_() - Generate a unique uuid")
@SuppressWarnings({"UnusedDeclaration"})
public class Uuid extends UDF{
  public Text evaluate() {
    return new Text(UUID.randomUUID().toString());
  }
}

On Tue, Nov 16, 2010 at 10:23 AM, afancy <[EMAIL PROTECTED]> wrote:

> Hi, Tim,
>
> I think sequential integer would be better. Is it difficult to generate a
> global integer?
> BTW: how to generate UUID in Hive? thanks
>
> Regards,
> afancy
>
> On Tue, Nov 16, 2010 at 9:11 AM, Tim Robertson <[EMAIL PROTECTED]>wrote:
>
>> Does it need to be a sequential INT? If not, then a UUID works very well.
>>
>> Cheers,
>> Tim
>>
>>
>> On Tue, Nov 16, 2010 at 8:55 AM, afancy <[EMAIL PROTECTED]> wrote:
>> > Hi, Zhang,
>> > How to integrate this snowflake with Hive?  Thanks!
>> > Regards,
>> > afancy
>> >
>> > On Mon, Nov 15, 2010 at 10:35 AM, Jeff Zhang <[EMAIL PROTECTED]> wrote:
>> >>
>> >> Please refer https://github.com/twitter/snowflake
>> >>
>> >>
>> >>
>> >> On Mon, Nov 15, 2010 at 5:09 PM, afancy <[EMAIL PROTECTED]> wrote:
>> >> > Hi,
>> >> > Does anybody know how to generate a unique ID in Hive? I have a
>> table:
>> >> > hive> describe results;
>> >> > OK
>> >> > id int
>> >> > test string
>> >> > Time taken: 0.091 seconds
>> >> >
>> >> > When I insert data into the table results, i want to generate a
>> unqiue
>> >> > Id,
>> >> > which is like a sequence in RDBMS.
>> >> > Regards,
>> >> > afancy
>> >>
>> >>
>> >>
>> >> --
>> >> Best Regards
>> >>
>> >> Jeff Zhang
>> >
>> >
>>
>
>