hi all,

       I have a scenario where i should generate the sequence id . All
my tables are in DB2

Hi all,

I have a scenario where all my tables are in DB2 and after dumping
them into HDFS.
A unique sequence id (or) unique identifier an extra column should be
added at beginning or at the end of the table can anyone help me on
this please.

Thanks

Regards
Abhi.

Try something like this :
public class MyUniqueNumber
{
    private static MyUniqueNumber myUniqueNumber;
    int number;
    int seedValue=365432; //custom seed value to begin with

    private MyUniqueNumber(){ //Singleton !!!
        number=seedValue; //init to zero
    }

    public static MyUniqueNumber getInstance(){
        if(myUniqueNumber==null){
            myUniqueNumber=new MyUniqueNumber();
        }
        return myUniqueNumber;
    }

    public int getUniqueNumber(){
        number+=1; //simple increment by 1 , you can modify this further
        return number;
    }
    public static void main(String[] args)
    {
        MyUniqueNumber myUniqueNumber=MyUniqueNumber.getInstance();
        for(int n=0;n<=5;n++){
            System.out.println("read number:
"+myUniqueNumber.getUniqueNumber());
        }
    }
}
On Thu, Jun 7, 2012 at 6:14 PM, abhishek dodda <[EMAIL PROTECTED]>wrote:

> hi all,
>
>       I have a scenario where i should generate the sequence id . All
> my tables are in DB2
>

--
∞
Shashwat Shriparv

or some string + timestamp+ lastrow +1

On Thu, Jun 7, 2012 at 6:52 PM, shashwat shriparv <[EMAIL PROTECTED]
> wrote:

> Try something like this :
>
>
> public class MyUniqueNumber
> {
>     private static MyUniqueNumber myUniqueNumber;
>     int number;
>     int seedValue=365432; //custom seed value to begin with
>
>     private MyUniqueNumber(){ //Singleton !!!
>         number=seedValue; //init to zero
>     }
>
>     public static MyUniqueNumber getInstance(){
>         if(myUniqueNumber==null){
>             myUniqueNumber=new MyUniqueNumber();
>         }
>         return myUniqueNumber;
>     }
>
>     public int getUniqueNumber(){
>         number+=1; //simple increment by 1 , you can modify this further
>         return number;
>     }
>     public static void main(String[] args)
>     {
>         MyUniqueNumber myUniqueNumber=MyUniqueNumber.getInstance();
>         for(int n=0;n<=5;n++){
>             System.out.println("read number:
> "+myUniqueNumber.getUniqueNumber());
>         }
>     }
> }
>
>
> On Thu, Jun 7, 2012 at 6:14 PM, abhishek dodda <[EMAIL PROTECTED]>wrote:
>
>> hi all,
>>
>>       I have a scenario where i should generate the sequence id . All
>> my tables are in DB2
>>
>
>
>
> --
>
>
> ∞
> Shashwat Shriparv
>
>
>
--
∞
Shashwat Shriparv

Can try snowflake https://github.com/twitter/snowflake

On Thu, Jun 7, 2012 at 6:20 PM, abhishek dodda
<[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I have a scenario where all my tables are in DB2 and after dumping
> them into HDFS.
> A unique sequence id (or) unique identifier an extra column should be
> added at beginning or at the end of the table can anyone help me on
> this please.
>
> Thanks
>
> Regards
> Abhi.

--
thanks
ashish

Blog: http://www.ashishpaliwal.com/blog
My Photo Galleries: http://www.pbase.com/ashishpaliwal

Ashish - Note though that Twitter's Snowflake is only roughly
sequential in generation.

Abhishek - Do you really require proper sequence IDs? Why not just
keep and work with timestamps?

On Thu, Jun 7, 2012 at 6:57 PM, Ashish <[EMAIL PROTECTED]> wrote:
> Can try snowflake https://github.com/twitter/snowflake
>
> On Thu, Jun 7, 2012 at 6:20 PM, abhishek dodda
> <[EMAIL PROTECTED]> wrote:
>> Hi all,
>>
>> I have a scenario where all my tables are in DB2 and after dumping
>> them into HDFS.
>> A unique sequence id (or) unique identifier an extra column should be
>> added at beginning or at the end of the table can anyone help me on
>> this please.
>>
>> Thanks
>>
>> Regards
>> Abhi.
>
>
>
> --
> thanks
> ashish
>
> Blog: http://www.ashishpaliwal.com/blog
> My Photo Galleries: http://www.pbase.com/ashishpaliwal

--
Harsh J

Actually trying to look how we can write a mapreduce program.

On Thu, Jun 7, 2012 at 7:12 AM, Harsh J <[EMAIL PROTECTED]> wrote:
> Ashish - Note though that Twitter's Snowflake is only roughly
> sequential in generation.
>
> Abhishek - Do you really require proper sequence IDs? Why not just
> keep and work with timestamps?
>
> On Thu, Jun 7, 2012 at 6:57 PM, Ashish <[EMAIL PROTECTED]> wrote:
>> Can try snowflake https://github.com/twitter/snowflake
>>
>> On Thu, Jun 7, 2012 at 6:20 PM, abhishek dodda
>> <[EMAIL PROTECTED]> wrote:
>>> Hi all,
>>>
>>> I have a scenario where all my tables are in DB2 and after dumping
>>> them into HDFS.
>>> A unique sequence id (or) unique identifier an extra column should be
>>> added at beginning or at the end of the table can anyone help me on
>>> this please.
>>>
>>> Thanks
>>>
>>> Regards
>>> Abhi.
>>
>>
>>
>> --
>> thanks
>> ashish
>>
>> Blog: http://www.ashishpaliwal.com/blog
>> My Photo Galleries: http://www.pbase.com/ashishpaliwal
>
>
>
> --
> Harsh J

Actually trying to code this using map reduce program.

On Thu, Jun 7, 2012 at 6:22 AM, shashwat shriparv
<[EMAIL PROTECTED]> wrote:
> Try something like this :
>
>
> public class MyUniqueNumber
> {
>    private static MyUniqueNumber myUniqueNumber;
>    int number;
>    int seedValue=365432; //custom seed value to begin with
>
>    private MyUniqueNumber(){ //Singleton !!!
>        number=seedValue; //init to zero
>    }
>
>    public static MyUniqueNumber getInstance(){
>        if(myUniqueNumber==null){
>            myUniqueNumber=new MyUniqueNumber();
>        }
>        return myUniqueNumber;
>    }
>
>    public int getUniqueNumber(){
>        number+=1; //simple increment by 1 , you can modify this further
>        return number;
>    }
>    public static void main(String[] args)
>    {
>        MyUniqueNumber myUniqueNumber=MyUniqueNumber.getInstance();
>        for(int n=0;n<=5;n++){
>            System.out.println("read number:
> "+myUniqueNumber.getUniqueNumber());
>        }
>    }
> }
>
>
> On Thu, Jun 7, 2012 at 6:14 PM, abhishek dodda <[EMAIL PROTECTED]>wrote:
>
>> hi all,
>>
>>       I have a scenario where i should generate the sequence id . All
>> my tables are in DB2
>>
>
>
>
> --
>
>
> ∞
> Shashwat Shriparv