Re: How to generate global unique ID?

Hi, Zhang, How to integrate this snowflake with Hive? Thanks! Regards, afancy On Mon, Nov 15, 2010 at 10:35 AM, Jeff Zhang wrote: > Please refer https://github.com/twitter/snowflake > > > > On Mon, Nov 15, 2010 at 5:09 PM, afancy wrote: > > Hi, > > Does

How to receive File input paths about one select statement

There is select statement, as below: SELECT itemId FROM (SELECT user_id AS itemId FROM r_dm_pv_vstcat1_dm WHERE cat_id1 IN ('14', '1101', '1201', '50008090', '50012164', '11', '1512') AND (pt <= recentdate('dd',1) AND pt >= recentdate('dd',5)) GROUP BY user_id ) sqTab limit 30; recentdate is

Re: How to generate global unique ID?

Please refer https://github.com/twitter/snowflake On Mon, Nov 15, 2010 at 5:09 PM, afancy 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

How to generate global unique ID?

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