Re: Oracle TIMESTAMP(9) equivalent in Cassandra

2015-10-29 Thread DuyHai Doan
You can use TimeUUID data type and provide the value yourself from client side. The Java driver offers an utility class com.datastax.driver.core.utils.UUIDs and the method timeBased() to generate the TimeUUID. The precision is only guaranteed up to 100 nano seconds. So you can have possibly 10k

Re: Oracle TIMESTAMP(9) equivalent in Cassandra

2015-10-29 Thread Jon Haddad
Keep in mind that in a distributed environment you probably have so much variance that nanosecond precision is pointless. Even google notes that in the paper, Dapper, a Large-Scale Distributed Systems Tracing Infrastructure [http://research.google.com/pubs/pub36356.html

RE: Oracle TIMESTAMP(9) equivalent in Cassandra

2015-10-29 Thread chandrasekar.krc
. Regards, Chandra Sekar KR From: DuyHai Doan [mailto:doanduy...@gmail.com] Sent: 29/10/2015 5:13 PM To: user@cassandra.apache.org Subject: Re: Oracle TIMESTAMP(9) equivalent in Cassandra You can use TimeUUID data type and provide the value yourself from client side. The Java driver offers an utility

Re: Oracle TIMESTAMP(9) equivalent in Cassandra

2015-10-29 Thread Kai Wang
> *To:* user@cassandra.apache.org > *Subject:* Re: Oracle TIMESTAMP(9) equivalent in Cassandra > > > > You can use TimeUUID data type and provide the value yourself from client > side. > > > > The Java driver offers an utility class > com.datastax.driver.core.util

Re: Oracle TIMESTAMP(9) equivalent in Cassandra

2015-10-29 Thread Clint Martin
gt; >> >> >> Also, the preference is to generate values during record insertion from >> database side, rather than client side. Something similar to SYSTIMESTAMP >> in Oracle. >> >> >> >> Regards, Chandra Sekar KR >> >> *From:

Re: Oracle TIMESTAMP(9) equivalent in Cassandra

2015-10-29 Thread Brice Dutheil
> >>> Also, the preference is to generate values during record insertion from >>> database side, rather than client side. Something similar to SYSTIMESTAMP >>> in Oracle. >>> >>> >>> >>> Regards, Chandra Sekar KR >>> >>

Re: Oracle TIMESTAMP(9) equivalent in Cassandra

2015-10-29 Thread Jonathan Haddad
;>> >>>> Is the timeBased() method available in Java driver similar to now() >>>> function >>>> in cqlsh. Does both provide identical results. >>>> >>>> >>>> >>>> Also, the preference is to generate values durin

Re: Oracle TIMESTAMP(9) equivalent in Cassandra

2015-10-29 Thread Brice Dutheil
gt;> >>>>> >>>>> >>>>> Is the timeBased() method available in Java driver similar to now() >>>>> function >>>>> in cqlsh. Does both provide identical results. >>>>> >>>>> >>>>> &