Re: Frozen type sin cassandra.

2017-03-07 Thread Tyler Hobbs
h the simpler option of frozen<list>. > Also how to create a solr index on such columns? > I have no idea, sorry. -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Frozen type support

2017-01-24 Thread Tyler Hobbs
sions of Cassandra ? > > > Thx. > Ahmed > > > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Import failure for use python cassandra-driver

2016-10-26 Thread Tyler Hobbs
0, in > >> from cassandra.cluster import Cluster, _NOT_SET, NoHostAvailable, > >> UserTypeDoesNotExist > >> ImportError: > >> dlopen(/Library/Python/2.7/site-packages/cassandra/cluster.so, 2): > Symbol > >> not found: _PyException_Check > >> Referenced from: /Library/Python/2.7/site- > packages/cassandra/cluster.so > >> Expected in: flat namespace > >> in /Library/Python/2.7/site-packages/cassandra/cluster.so > >> > >> Thanks, > >> Jason > >> > >> > > > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Cannot set TTL in COPY command

2016-10-26 Thread Tyler Hobbs
On Wed, Oct 26, 2016 at 10:07 AM, techpyaasa . <techpya...@gmail.com> wrote: > Can some one please tell me how to set TTL using COPY command? It looks like you're using Cassandra 2.0. I don't think COPY supports the TTL option until at least 2.1. -- Tyler Hobbs DataStax <http://datastax.com/>

Re: CASSANDRA-5376: CQL IN clause on last key not working when schema includes set,list or map

2016-09-15 Thread Tyler Hobbs
partition/cluster (last) columns? >> >> If it was fixed properly to support retrieving collections with IN >> clause, then is it a bug in 3.7 release that i get the same message? >> >> Could you please explain, if it not fixed as intended, if there are plans >> to support this in future? >> >> Thanks & Regards, >> Samba >> > > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: race condition for quorum consistency

2016-09-14 Thread Tyler Hobbs
gle client's perspective, you get monotonic reads. -- Tyler Hobbs DataStax <http://datastax.com/>

Re: ServerError: An unexpected error occurred server side; in cassandra java driver

2016-09-01 Thread Tyler Hobbs
have faced a similar issue could provide his/her > views. > > Thanks > Siddharth > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: How to create a TupleType/TupleValue in a UDF

2016-08-19 Thread Tyler Hobbs
for some examples and details: http://cassandra.apache.org/doc/latest/cql/functions.html#user-defined-functions -- Tyler Hobbs DataStax <http://datastax.com/>

Re: How to create a TupleType/TupleValue in a UDF

2016-08-18 Thread Tyler Hobbs
t;>, blob]' failed: > java.security.AccessControlException: > access denied ("java.io.FilePermission" "/etc/cassandra/logback.xml" > "read”)" > > Or CodecNotFoundException for Cassandra not being able to find a codec for > "map<date, frozen<tuple<timestamp, timestamp>>>”. > > Is this a bug or I’m doing something wrong? > > > Thanks, > > Drew > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: migrating from 2.1.2 to 3.0.8 log errors

2016-08-10 Thread Tyler Hobbs
orator.run(DefaultThreadFactory.java:137) > ~[netty-all-4.0.23.Final.jar:4.0.23.Final] > at java.lang.Thread.run(Thread.java:745) [na:1.8.0_101] > > we have installed java-8_101 > > anya idea what woud be the problem? > > thanks > > Adil > does anyone > > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: (C)* stable version after 3.5

2016-07-13 Thread Tyler Hobbs
tly. There should not be a difference in terms of how well the upgrade is supported. -- Tyler Hobbs DataStax <http://datastax.com/>

Re: C* 2.2.7 ?

2016-06-29 Thread Tyler Hobbs
nly. It may contain proprietary material, confidential > information and/or be subject to legal privilege. It should not be > copied, disclosed to, retained or used by any other party. If you are not > an intended recipient then please promptly delete this e-mail and any > attachment and all copies and inform the sender. -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Read operation can read uncommitted data?

2016-06-28 Thread Tyler Hobbs
! > 5. read/results phase fails by ReadTimeoutException caused by failure of > node C > > Thanks, > Yuji Ito > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Adding column to materialized view

2016-06-28 Thread Tyler Hobbs
to add a column to a materialized view, > but ALTER MATERIALIZED VIEW doesn't seem to allow that. So we ended up > dropping the view and recreating it. Is that expected or did I miss > something in the docs? > > -J > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Token Ring Question

2016-06-24 Thread Tyler Hobbs
driver's calculation is incorrect for some reason, token-aware routing is just an optimization. Nothing will break if a query is sent to a node that's not a replica. -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Installing Cassandra from Tarball

2016-06-14 Thread Tyler Hobbs
gt; > You need to disable swap in order to avoid this message, using swap space > can have serious performance implications. Make sure you disable fstab > entry as well for swap partition. > It looks like swap is actually disabled, but the nofile and nproc limits are too low. -- Tyler Hobbs DataStax <http://datastax.com/>

Re: select query on entire primary key returning more than one row in result

2016-06-14 Thread Tyler Hobbs
; verma.siddha...@snapdeal.com> wrote: > >> No, all rows were not the same. >> Querying only on the partition key gives 20 rows. >> In the erroneous result, while querying on partition key and clustering >> key, we got 16 of those 20 rows. >> >> And for "*tombstone_threshold"* there isn't any entry at column family >> level. >> >> Thanks, >> Siddharth Verma >> >> >> > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Tick Tock version numbers

2016-06-14 Thread Tyler Hobbs
. > > Based on what I have gather seems like it is matter of: > bring node down > install new version > bring up > run nodetool upgradesstables -a > For upgrades within the 3.x line, you don't need to run upgradesstables. Other than that, this is correct. -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Lightweight Transactions during datacenter outage

2016-06-07 Thread Tyler Hobbs
ghtweight transactions working > even during a DC outage/split would be nice. > > Thanks in advance for any help/hints. > > Best regards, Jero > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Token Ring Question

2016-06-03 Thread Tyler Hobbs
code check for such conditions and instead put > it on some node in DC1 ? What is the true meaning of “primary” token range > in such scenarios ? > > > > Is this how things works roughly speaking or am I missing something ? > > > > Thanks ! > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Blob or columns

2016-06-03 Thread Tyler Hobbs
ire less server and driver resources for serialization and deserialization. Since you don't need to update anything in the blob individually, I recommend going with that. -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Get clustering column in Custom cassandra trigger

2016-05-26 Thread Tyler Hobbs
, I couldn't understand. > > I am already using > UnfilteredRowIterator unfilteredRowIterator > =partition.unfilteredIterator(); > > while(unfilteredRowIterator.hasNext()){ > next.append(unfilteredRowIterator.next().toString()+"\001"); > } > > Is there another wa

Re: Setting bloom_filter_fp_chance < 0.01

2016-05-26 Thread Tyler Hobbs
ticket here for that? https://issues.apache.org/jira/browse/CASSANDRA -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Internal Handling of Map Updates

2016-05-25 Thread Tyler Hobbs
Wuppertal > Vorstand: Michael Hochgürtel . Mirko Novakovic . Rainer Vehns > Aufsichtsrat: Patric Fedlmeier (Vorsitzender) . Klaus Jäger . Jürgen Schütz > > Diese E-Mail einschließlich evtl. beigefügter Dateien enthält vertrauliche > und/oder rechtlich geschützte Informationen. Wenn Sie nicht der richtige > Adressat sind oder diese E-Mail irrtümlich erhalten haben, informieren Sie > bitte sofort den Absender und löschen Sie diese E-Mail und evtl. > beigefügter Dateien umgehend. Das unerlaubte Kopieren, Nutzen oder Öffnen > evtl. beigefügter Dateien sowie die unbefugte Weitergabe dieser E-Mail ist > nicht gestattet > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Low cardinality secondary index behaviour

2016-05-12 Thread Tyler Hobbs
rom an SSTable. If you need to run this query very frequently, that may add too much load to your cluster, and some sort of inverted table approach may be more appropriate. -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Cassandra 3.0.6 Release?

2016-05-10 Thread Tyler Hobbs
We've been holding it up to sync it with the 3.6 release. There were a couple of bugs in the first 3.6-tentative tag that forced us to re-roll and restart test runs. The release vote for 3.0.6 and 3.6 should start within the next couple of days, and takes 72 hours to complete. -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Discrepancy while paging through table, and static column updated inbetween

2016-04-19 Thread Tyler Hobbs
y for that partition key was ignored, is an assumption > from our end. > We can't understand why some entries were not printed in the table scan. > > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Proper use of COUNT

2016-04-19 Thread Tyler Hobbs
(et al) is memory limited as well as time. > Deduping (i.e. normal conflict resolution) happens per-page, so in the worst case the memory requirements for the coordinator are RF * page size. -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Compaction Error When upgrading from 2.1.9 to 3.0.2

2016-04-14 Thread Tyler Hobbs
> > > Do you know what would cause this error? Is it something to do with > tombstoned or deleted rows? > > > I'm not sure, I haven't looked into it too deeply yet. From the stacktrace it looks related to reading the static columns of a row. -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Leak Detected while bootstrap

2016-04-13 Thread Tyler Hobbs
ache.cassandra.utils.concurrent.WrappedSharedCloseable$1@203187780:[[OffHeapBitSet]] > was not released before the reference was garbage collected* > > > > Thanks ! > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Compaction Error When upgrading from 2.1.9 to 3.0.2

2016-04-13 Thread Tyler Hobbs
nnableAdapter.call(Executors.java:511) > > at java.util.concurrent.FutureTask.run(FutureTask.java:266) > > at > java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) > > at > java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) > > at java.lang.Thread.run(Thread.java:745) > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Adding Options to Create Statements...

2016-04-01 Thread Tyler Hobbs
create; >> } >> >> I don't want to have to return the Create.Options object from this method >> (as I may need to add other columns). Is there a way to have the options >> "decorate" the Create directly without having to return the Create.Options? >> >> -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Thrift composite partition key to cql migration

2016-03-31 Thread Tyler Hobbs
Also, can you paste the results of the relevant portions of "SELECT * FROM system.schema_columns" and "SELECT * FROM system.schema_columnfamilies"? On Thu, Mar 31, 2016 at 2:35 PM, Tyler Hobbs <ty...@datastax.com> wrote: > In the Thrift schema, is the key_

Re: Thrift composite partition key to cql migration

2016-03-31 Thread Tyler Hobbs
foo.bar ( > key1 text, > key2 text, > column1 text, > column2 text, > value blob, > PRIMARY KEY ((key1, key2), column1, column2) > ) > > Cheers, > Jan > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Inconsistent query results and node state

2016-03-31 Thread Tyler Hobbs
tly query this row and that timestamp doesn't fit in the normal ordering. > > Thoughts on how to proceed? > Please open a ticket at https://issues.apache.org/jira/browse/CASSANDRA and include your schema and queries. If possible, it would also be extremely helpful if you can upload the sstables

Re: Inconsistent query results and node state

2016-03-30 Thread Tyler Hobbs
tor.java:617) >> [na:1.8.0_74] >> at java.lang.Thread.run(Thread.java:745) [na:1.8.0_74] >> >> The tracing files are attached and seem to show that in the failed case, >> content is skipped because of tombstones if we understand it correctly. >> This could be an inconsistency problem on 192.168.10.9 Unfortunately, >> attempts to compact on 192.168.10.9 only give the following error without >> any stack trace detail and are not fixed with repair. >> >> root@cutthroat:/usr/local/bin/analyzer/bin# nodetool compact >> error: null >> -- StackTrace -- >> java.lang.ArrayIndexOutOfBoundsException >> >> Any suggestions on how to fix or what to search for would be much >> appreciated. >> >> Thanks, >> >> Jason >> >> >> >> > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Drop and Add column with different datatype in Cassandra

2016-03-29 Thread Tyler Hobbs
lection* column with the same name. Other types of columns are fine. -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Python to type field

2016-03-19 Thread Tyler Hobbs
program which I am > writing. where I prepare and then bind, I get this error while executing > > TypeError: Received an argument of invalid type for column "evetag". > Expected: VarcharType))'>, Got: ; (Received a string for a type that > expects a sequence) >

Re: Understanding SELECT * paging/ordering

2016-03-18 Thread Tyler Hobbs
token range and perform the standard conflict resolution. [1] In reality, based on estimates of how many token ranges it will need to query in order to meet the page size, it will query multiple token ranges in parallel. See CASSANDRA-1337 for details. -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Automatically connect to any up node via cqlsh

2016-03-09 Thread Tyler Hobbs
supply ip_address and > port of the UP node as arguments to cqlsh, but I am looking at automatic > detection. > No, right now cqlsh is designed to connect to only a single node. -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Isolation for atomic batch on the same partition key

2016-03-01 Thread Tyler Hobbs
can't use LWT conditions (i.e. "IF condition_1") in batches that span multiple partitions keys. If you did not include the condition, then you would get per-partition isolation, as you describe. > > > 3. I assume CL SERIAL or LOCAL_SERIAL on reads will try applying the above >

Re: IF NOT EXISTS with multiple static columns confusion

2016-03-01 Thread Tyler Hobbs
nts.report_payments (id, foo) VALUES (NOW(), 1) IF NOT > EXISTS; // fails, even though foo=null, and has never been written too > """ > > Nimi > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: copy and rename sstable files as keyspace migration approach

2016-02-23 Thread Tyler Hobbs
you can skip the Summary.db files and they'll be rebuilt on startup. -- Tyler Hobbs DataStax <http://datastax.com/>

Re: High Bloom filter false ratio

2016-02-18 Thread Tyler Hobbs
have been running the cluster for a long time now but have > added significant traffic from Jan this year, which would not lead to > writes in the db but would lead to high reads to see if are any values. > > Are there any settings that can be changed to allow better ratio. > > Thanks > Anishek > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: „Using Timestamp“ Feature

2016-02-18 Thread Tyler Hobbs
th 'insert'). Is there a good reason for this, or is it > a bug? > The "USING TIMESTAMP" goes in a different place in update statements. It should be something like: UPDATE mytable USING TIMESTAMP ? SET col = ? WHERE key = ? -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Duplicated key with an IN statement

2016-02-04 Thread Tyler Hobbs
On Thu, Feb 4, 2016 at 9:57 AM, Jack Krupansky <jack.krupan...@gmail.com> wrote: > there's a bug in CHANGES.TXT for this issue. It says: "Duplicate rows > returned when in clause has repeated values (CASSANDRA-6707)", but the > issue number is really 6706. > Thanks,

Re: Cqlsh hangs & closes automatically

2016-02-02 Thread Tyler Hobbs
ows using > select * query. Cassandra-cli does the job. Any solution? > > > > Thanks > Anuj > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Cassandra 3.1.1 with respect to HeapSpace

2016-01-14 Thread Tyler Hobbs
ssandra.service.CassandraDaemon.main(CassandraDaemon.java:677) > [apache-cassandra-3.1.1.jar:3.1.1] > > I can no longer start my nodes. > > How can I restart my cluster? > Is this problem known? > Is there a better Cassandra 3 version which would behave better with > respect to this problem? > Would there be a better memory configuration to select for my nodes? > Currently I use MAX_HEAP_SIZE="6G" HEAP_NEWSIZE=“496M” for a 16M RAM node. > > > Thank you very much for your advice. > > Kind regards > > Jean > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Sorting & pagination in apache cassandra 2.1

2016-01-07 Thread Tyler Hobbs
a materialized view, if you're using 3.0+) that uses a different clustering order. Cassandra purposefully only supports simple and efficient queries that can be handled quickly (with a few exceptions), and arbitrary ordering is not part of that, especially if you consider complications like paging.

Re: Cassandra 3.1 - Aggregation query failure

2015-12-29 Thread Tyler Hobbs
over QUORUM replicas, the query may timeout very > quickly. > Yes, that's possible. Timeouts for these queries should be adjusted accordingly. It's worth noting that the read_request_timeout_in_ms setting applies per-page, so coordinator-level timeouts shouldn't be severely affected by this. -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Cassandra 3.1 - Aggregation query failure

2015-12-18 Thread Tyler Hobbs
* use paging internally, so at most one page worth of data will be held in memory at a time. However, if your aggregation function retains a large amount of data, this may contribute to heap pressure. -- Tyler Hobbs DataStax <http://datastax.com/>

Re: [RELEASE] Apache Cassandra 3.1 released

2015-12-11 Thread Tyler Hobbs
3.0.1? Why is > there a different release scheme specifically for 3.0.x instead of putting > those fixes to 3.1? > We don't know how well the tick-tock release scheme will stabilize yet. As a safety net, we're doing our traditional release scheme for 3.0.x. -- Tyler Hobbs DataStax <http://datastax.com/>

Re: [RELEASE] Apache Cassandra 3.1 released

2015-12-09 Thread Tyler Hobbs
>> >> This version is a bug fix release[1] on the 3.x series. As always, please >> pay >> attention to the release notes[2] and Let us know[3] if you were to >> encounter >> any problem. >> >> Enjoy! >> >> [1]: http://goo.gl/rQJ9yd (CHANGES.txt) >> [2]: http://goo.gl/WBrlCs (NEWS.txt) >> [3]: https://issues.apache.org/jira/browse/CASSANDRA >> [4]: http://www.planetcassandra.org/blog/cassandra-2-2-3-0-and-beyond/ >> >> >> > > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Cassandra 3.0.0 connection problem

2015-11-19 Thread Tyler Hobbs
ersions isn't supported, which is why we recommend that you take a snapshot before upgrading. Your only real option for downgrading without data loss is to dump your data (using cqlsh's COPY TO or something similar) and then re-load it on 2.2 (using cqlsh's COPY FROM or something similar). -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Cqlsh copy to and copy from

2015-11-19 Thread Tyler Hobbs
ows was > not imported. > > Do you plan to fix that, e.g. fill with default values or exclude them? > > Thanks. > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Timeout with static column

2015-11-12 Thread Tyler Hobbs
tones (even though the trace above doesn't tell that). > > What's strange is that it seems the query scans the whole set of records, > even though it should return only the static column (whose by definition > has only one value indepedently of the number of records), so it should be > pretty fast, isn't it? > > Note that using `SELECT DISTINCT` doesn't seem to change anything > regarding speed (I understand that it is the recommended way of doing this > kind of queries). > > Anyone can explain me how this problem can be solved, or what could be its > root cause? > > Thanks for any answers, > -- > Brice Figureau > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Multi-column slice restrictions not respected by the returned result

2015-11-11 Thread Tyler Hobbs
amp;& b>y) in > CQL, it only implies full tuple comparison. That explains why my condition > (a, b) > (2, 10) was matching row (2, 11). > > On Wed, Nov 11, 2015 at 2:31 PM, Tyler Hobbs <ty...@datastax.com> wrote: > >> This is a known problem with multi-col

Re: Multi-column slice restrictions not respected by the returned result

2015-11-11 Thread Tyler Hobbs
3, 12, 91) ; > > select * from dur where s='x' and (nd,ts) > (2, 11); > > s | nd | ts | tid > ---+++- > x | 2 | 10 | 94 > x | 3 | 12 | 91 > x | 3 | 11 | 92 > x | 3 | 10 | 97 > (4 rows) > > The first row in the result does not sat

Re: why cassanra max is 20000/s on a node ?

2015-11-05 Thread Tyler Hobbs
t;>> >>> 东软集团股份有限公司 >>> 上海市闵行区紫月路1000号东软软件园 >>> Postcode:200241 >>> Tel:(86 21) 33578591 >>> Fax:(86 21) *23025565-111* >>> Mobile:13764970711 >>> Email:ha...@neusoft.com >>> Http://www.neusoft.com <http://www.neusoft.com/> >>> >>> >>> >>> >>> >>> >>> >>> --- >>> Confidentiality Notice: The information contained in this e-mail and any >>> accompanying attachment(s) >>> is intended only for the use of the intended recipient and may be >>> confidential and/or privileged of >>> Neusoft Corporation, its subsidiaries and/or its affiliates. If any >>> reader of this communication is >>> not the intended recipient, unauthorized use, forwarding, printing, >>> storing, disclosure or copying >>> is strictly prohibited, and may be unlawful.If you have received this >>> communication in error,please >>> immediately notify the sender by return e-mail, and delete the original >>> message and all copies from >>> your system. Thank you. >>> >>> --- >>> >> >> -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Error code=1000

2015-11-03 Thread Tyler Hobbs
plicas': 2, >> 'alive_replicas': 1, 'consistency': 'LOCAL_QUORUM’} >> >> I am using cassandra standalone >> >> Thanks >> >> -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Error Code

2015-10-29 Thread Tyler Hobbs
>> > wrote: >> >>> Hi Guys, >>> >>> Does anyone know what error code in cassandra is? >>> >>> Error decoding response from Cassandra. opcode: 0008; >>> >>> Thanks >>> >> >> >> > > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Is there any configuration so that local program on C* node can connect using localhost and remote program using IP/name?

2015-10-20 Thread Tyler Hobbs
> using localhost as connection url and remote program's using IP/name in > connection url? Set rpc_address to 0.0.0.0 to bind all interfaces. -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Cassandra query degradation with high frequency updated tables.

2015-10-09 Thread Tyler Hobbs
andra-2.2.2.jar:2.2.2] > ... 4 common frames omitted > Caused by: java.io.IOException: Seek position 182054 is not within mmap > segment (seg offs: 0, length: 182054) > at > org.apache.cassandra.io.util.ByteBufferDataInput.seek(ByteBufferDataInput.java:47) > ~[apache-cassandra-2.2.2

Re: Cassandra query degradation with high frequency updated tables.

2015-10-09 Thread Tyler Hobbs
kip(RowIndexEntry.java:155) > ~[apache-cassandra-2.2.2.jar:2.2.2] > at > org.apache.cassandra.io.sstable.format.big.BigTableReader.getPosition(BigTableReader.java:244) > ~[apache-cassandra-2.2.2.jar:2.2.2] > > > > > On Oct 9, 2015, at 9:26 AM, Carlos Alonso <i

Re: Cassandra query degradation with high frequency updated tables.

2015-10-08 Thread Tyler Hobbs
n. So what do we think can be done to resolve this > ? > > BTW, I am using Cassandra 2.2.1 . And since this is a test , this is just > running on a single node. > > > > > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: CQL error when adding multiple conditional update statements in the same batch

2015-10-08 Thread Tyler Hobbs
n=10; >> UPDATE activities SET state='ALLOCATED',version=2 WHERE key='Key2' IF >> version=1; >> APPLY BATCH; >> >> gives the following error >> >> Bad Request: Duplicate and incompatible conditions for column version >> >> Is there anyway to upd

Re: How are writes handled while adding nodes to cluster?

2015-10-06 Thread Tyler Hobbs
r are they being written to the > joining node? > > In the former case I guess I have to make sure my max_hint_window_in_ms > is long enough for the node to become NORMAL or hints will get dropped > and I must do repair. Am I right? > > Thanks, > \EF > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Repair corrupt SSTable from power outage?

2015-10-02 Thread Tyler Hobbs
:1.8.0_60] >> at java.util.concurrent.FutureTask.run(FutureTask.java:266) >> [na:1.8.0_60] >> at >> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) >> [na:1.8.0_60] >> at >> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) >> [na:1.8.0_60] >> at java.lang.Thread.run(Thread.java:745) [na:1.8.0_60] >> Caused by: java.io.EOFException: null >> at >> java.io.DataInputStream.readUnsignedShort(DataInputStream.java:340) >> ~[na:1.8.0_60] >> at java.io.DataInputStream.readUTF(DataInputStream.java:589) >> ~[na:1.8.0_60] >> at java.io.DataInputStream.readUTF(DataInputStream.java:564) >> ~[na:1.8.0_60] >> at >> org.apache.cassandra.io.compress.CompressionMetadata.(CompressionMetadata.java:106) >> ~[apache-cassandra-2.1.9.jar:2.1.9] >> ... 14 common frames omitted >> >> >> Is there a fix for this? >> > > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: JSON Order By

2015-10-02 Thread Tyler Hobbs
sort the rules Array by property ruleOrder when i select > Unfortunately, that's not possible. Cassandra can only order result rows by the clustering columns. The new JSON functionality doesn't change this, it just adds a new input/output format. You'll need to sort the results client-side.

Re: Secondary index is causing high CPU load

2015-09-29 Thread Tyler Hobbs
ess even distribution with current > vnode random allocation, but you will pay less of a penalty for having > multiple ranges... > > =Rob > > > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: who does generate timestamp during the write?

2015-09-08 Thread Tyler Hobbs
ach version of the value (by adding a timuuid to the primary key, for example), but in some cases lightweight transactions may also be suitable. -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Trace evidence for LOCAL_QUORUM ending up in remote DC

2015-09-08 Thread Tyler Hobbs
rtition beginning in data file > | 10.55.156.67 | 10417 | SharedPool-Worker-3 > Key cache hit for sstable 389 > | 10.55.156.67 | 10586 | SharedPool-Worker-3 > > My question is: how is it possible

Re: who does generate timestamp during the write?

2015-09-04 Thread Tyler Hobbs
15 at 10:26 AM, ibrahim El-sanosi < >>>>> ibrahimsaba...@gmail.com> wrote: >>>>> >>>>>> Dear folks, >>>>>> >>>>>> When we hear about the notion of Last-Write-Wins in Cassandra >>>>>> according to timestamp, *who does generate this timestamp during the >>>>>> write, coordinator or each individual replica in which the write is going >>>>>> to be stored?* >>>>>> >>>>>> >>>>>> *Regards,* >>>>>> >>>>>> >>>>>> >>>>>> *Ibrahim* >>>>>> >>>>> >>>>> >>>> >>> >> > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: Order By limitation or bug?

2015-09-04 Thread Tyler Hobbs
ny way. If you received this email in error, > please notify the sender immediately by return email and delete the > message. Unless expressly stated otherwise, the information in this email > should not be regarded as an offer to sell or as a solicitation of an offer > to buy any financial product or service, an official confirmation of any > transaction, or as an official statement of the entity sending this > message. Neither Macquarie Group Limited, nor any of its subsidiaries, > guarantee the integrity of any emails or attached files and are not > responsible for any changes made to them by any other person. > -- Tyler Hobbs DataStax <http://datastax.com/>

Re: TTLs on tables with *only* primary keys?

2015-08-05 Thread Tyler Hobbs
the best way to proceed here? -- Founder/CEO Spinn3r.com Location: *San Francisco, CA* blog: http://burtonator.wordpress.com … or check out my Google+ profile https://plus.google.com/102718274791889610666/posts -- Tyler Hobbs DataStax http://datastax.com/

Re: Thrift to cql : mixed static and dynamic columns with secondary index

2015-07-16 Thread Tyler Hobbs
, value=image/jpeg, timestamp=1437035145227000) = (name=name, value=file2, timestamp=1437035073596000) Thanks for your help ! -- Tyler Hobbs DataStax http://datastax.com/

Re: Read Consistency

2015-06-30 Thread Tyler Hobbs
://www.cloudera.com/content/cloudera/en/campaign/data-impact-awards.html -- Tyler Hobbs DataStax http://datastax.com/

Re: Read Consistency

2015-06-30 Thread Tyler Hobbs
noting that if you get an Unavailable response, you are guaranteed that the data has not been written to any replicas, because the coordinator already knew that the replicas were down when it got the response. -- Tyler Hobbs DataStax http://datastax.com/

Re: Inconsistent behavior during read

2015-06-25 Thread Tyler Hobbs
, in old Thrift terms) don't do read repair. -- Tyler Hobbs DataStax http://datastax.com/

Re: MarshalException after upgrading to 2.1.6

2015-06-11 Thread Tyler Hobbs
Exception encountered during startup: unable to make version 1 UUID from 'currencyCode' -- Tyler Hobbs DataStax http://datastax.com/

Re: Cassandra 2.2, 3.0, and beyond

2015-06-10 Thread Tyler Hobbs
from normal tables any more. You can read a few details about the new storage format here: https://github.com/pcmanus/cassandra/blob/8099_engine_refactor/guide_8099.md#storage-format-on-disk-and-on-wire -- Tyler Hobbs DataStax http://datastax.com/

Re: TTL and gc_grace_period

2015-06-05 Thread Tyler Hobbs
case. -- Tyler Hobbs DataStax http://datastax.com/

Re: TTL and gc_grace_period

2015-06-05 Thread Tyler Hobbs
it be a problem, since they would themselves be marked as expired? You don't need to worry about expired data being revived because every node that has a copy of that data will have the same TTL. -- Tyler Hobbs DataStax http://datastax.com/

Re: Coordination of expired TTLs compared to tombstones

2015-05-29 Thread Tyler Hobbs
that will replicate to the other nodes. Correct, that's why they can't be purged immediately. -- Tyler Hobbs DataStax http://datastax.com/

Re: A few stupid questions...

2015-05-26 Thread Tyler Hobbs
is to benchmark it with your own usecase. -- Tyler Hobbs DataStax http://datastax.com/

Re: Clarification of property: storage_port

2015-05-15 Thread Tyler Hobbs
importantly: It seems to me that storage_port MUST be configured to be the same port for _all_ nodes in a cluster, is this correct? That's correct. -- Tyler Hobbs DataStax http://datastax.com/

Re: Leap sec

2015-05-15 Thread Tyler Hobbs
are the workaorund other than upgrading kernel to 3.4+? Are you upgrading clusters to Java 7 or higher on client and C* servers? -- Tyler Hobbs DataStax http://datastax.com/

Re: Caching the PreparedStatement (Java driver)

2015-05-15 Thread Tyler Hobbs
). There are plans to persist prepared statements in a system table: https://issues.apache.org/jira/browse/CASSANDRA-8831 -- Tyler Hobbs DataStax http://datastax.com/

Re: CQL 3.x Update ...USING TIMESTAMP...

2015-04-21 Thread Tyler Hobbs
light weight transactions in a multi-data center traffic. I don't know who's doing that off the top of my head, but I imagine they're using LOCAL_SERIAL. -- Tyler Hobbs DataStax http://datastax.com/

Re: High latencies for simple queries

2015-03-31 Thread Tyler Hobbs
To clarify, that's in Cassandra 2.1+. In 2.0 and earlier, we used http://code.google.com/a/apache-extras.org/p/cassandra-dbapi2/ for cqlsh. On Tue, Mar 31, 2015 at 10:40 AM, Tyler Hobbs ty...@datastax.com wrote: The python driver that we bundle with Cassandra for cqlsh is the normal python

Re: High latencies for simple queries

2015-03-31 Thread Tyler Hobbs
as I'm able to get 0.5ms queries locally and that's even with trace turned on. Using python-driver? -- Ben Bromhead Instaclustr | www.instaclustr.com | @instaclustr http://twitter.com/instaclustr | (650) 284 9692 -- Tyler Hobbs DataStax http://datastax.com/

Re: High latencies for simple queries

2015-03-27 Thread Tyler Hobbs
is different, but for some scenarios this difference can matter. The question is: is it normal for Cassandra to have a minimum latency of 1 millisecond? I'm using Cassandra 2.1.2, python-driver. -- Tyler Hobbs DataStax http://datastax.com/

Re: High latencies for simple queries

2015-03-27 Thread Tyler Hobbs
}; cqlsh USE foo; cqlsh:foo CREATE TABLE foo(i int PRIMARY KEY, j text); cqlsh:foo TRACING ON; Now tracing requests. cqlsh:foo INSERT INTO foo (i, j) VALUES (1, 'yay'); -- Tyler Hobbs DataStax http://datastax.com/

Re: Not seeing keyspace in nodetool compactionhistory

2015-03-25 Thread Tyler Hobbs
that is? I did fill up the data in those two tables within the span of about 4 hours (I ran a script to migrate existing data from legacy rdbms dbs). Could that have something to do with it? I'm using SizeTieredCompactionStrategy for all tables. -- Tyler Hobbs DataStax http://datastax.com/

Re: Not seeing keyspace in nodetool compactionhistory

2015-03-25 Thread Tyler Hobbs
if that's issue, since the size isn't growing. The size is about what i'd expect. On Thu, Mar 26, 2015 at 12:44 AM, Tyler Hobbs ty...@datastax.com wrote: What version of Cassandra are you using? Since it sounds like you aren't doing any reads, it could be https://issues.apache.org/jira/browse

Re: error in bulk loading

2015-03-24 Thread Tyler Hobbs
with double-quotes to handle this (or change the quote character with the QUOTE option for COPY). -- Tyler Hobbs DataStax http://datastax.com/

Re: CQL 3.x Update ...USING TIMESTAMP...

2015-03-24 Thread Tyler Hobbs
it is sound but does rely on correct conflict resolution in Cassandra. I'm curious if I'm missing or misunderstanding something important. On Wed, Mar 11, 2015 at 4:11 PM, Tyler Hobbs ty...@datastax.com wrote: Don't use the version as your timestamp. It's possible, but you'll end up

Re: CQL 3.x Update ...USING TIMESTAMP...

2015-03-11 Thread Tyler Hobbs
like this? If so was the behavior as expected? Regards Sachin -- Tyler Hobbs DataStax http://datastax.com/

Re: sstables remain after compaction

2015-03-03 Thread Tyler Hobbs
.x. -- Tyler Hobbs DataStax http://datastax.com/

Re: Documentation of batch statements

2015-03-03 Thread Tyler Hobbs
can be visible, unapplied applied. That's a matter of isolation, not atomicity. Although, with a long enough gap between partial and full application, the distinction becomes somewhat pedantic, I suppose. -- Tyler Hobbs DataStax http://datastax.com/

  1   2   3   4   5   6   >