.
> Also how to create a solr index on such columns?
>
I have no idea, sorry.
--
Tyler Hobbs
DataStax <http://datastax.com/>
gt;
>
> Thx.
> Ahmed
>
>
>
--
Tyler Hobbs
DataStax <http://datastax.com/>
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/>
On Wed, Oct 26, 2016 at 10:07 AM, techpyaasa . 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/>
> 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/>
gle client's perspective, you get monotonic reads.
--
Tyler Hobbs
DataStax <http://datastax.com/>
have faced a similar issue could provide his/her
> views.
>
> Thanks
> Siddharth
>
--
Tyler Hobbs
DataStax <http://datastax.com/>
:
http://cassandra.apache.org/doc/latest/cql/functions.html#user-defined-functions
--
Tyler Hobbs
DataStax <http://datastax.com/>
ed Function failure]
> message="execution of ’testdb.min_max_by_timestamps_udf[map frozen>>, blob]' failed:
> java.security.AccessControlException:
> access denied ("java.io.FilePermission" "/etc/cassandra/logback.xml"
> "read”)"
>
> Or CodecNotFoundExcept
readFactory.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/>
terms of how well the
upgrade is supported.
--
Tyler Hobbs
DataStax <http://datastax.com/>
ontain 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/>
e fails by ReadTimeoutException caused by failure of
> node C
>
> Thanks,
> Yuji Ito
>
--
Tyler Hobbs
DataStax <http://datastax.com/>
or are there changes
> preventing this from working anymore?
>
> I have attempted this several times and it did actually work the first
> time, but when I moved around to the other nodes it no longer worked.
>
> Thanks,
> Paul Fife
>
>
--
Tyler Hobbs
DataStax <http://datastax.com/>
eded 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/>
r 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/>
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/>
069 *EXT*: 12369
> Plot # 362, ASF Centre - Tower A, Udyog Vihar,
> Phase -4, Sector 18, Gurgaon, Haryana 122016, INDIA
>
> On Mon, Jun 13, 2016 at 11:11 PM, Siddharth Verma <
> 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/>
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/>
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/>
e 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/>
urces
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/>
, I couldn't understand.
>
> I am already using
> UnfilteredRowIterator unfilteredRowIterator
> =partition.unfilteredIterator();
>
> while(unfilteredRowIterator.hasNext()){
> next.append(unfilteredRowIterator.next().toString()+"\001");
> }
>
> Is there anoth
//issues.apache.org/jira/browse/CASSANDRA
--
Tyler Hobbs
DataStax <http://datastax.com/>
richt 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/>
u 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/>
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/>
entry 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/>
rnatives are:
- counters
- a static count that's periodically refreshed by a batch/background
process
- LWT increments on an int column
- an external datastore like redis
Obviously, each of these has a different set of tradeoffs.
--
Tyler Hobbs
DataStax <http://datastax.com/>
ited 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/>
>
>
> 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/>
edCloseable$1@203187780:[[OffHeapBitSet]]
> was not released before the reference was garbage collected*
>
>
>
> Thanks !
>
--
Tyler Hobbs
DataStax <http://datastax.com/>
Adapter.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/>
t 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/>
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 wrote:
> In the Thrift schema, is the key_validation_class actually set to
&
ext,
> key2 text,
> column1 text,
> column2 text,
> value blob,
> PRIMARY KEY ((key1, key2), column1, column2)
> )
>
> Cheers,
> Jan
>
--
Tyler Hobbs
DataStax <http://datastax.com/>
stamp 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 for that table.
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/>
ion* column with the
same name. Other types of columns are fine.
--
Tyler Hobbs
DataStax <http://datastax.com/>
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)
>
> I tried casting the variable in python to list, tuple, but same error.
>
>
>
--
Tyler Hobbs
DataStax <http://datastax.com/>
en 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/>
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/>
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
> logged batch if it is committed but not applied. Right?
>
Correct.
--
Tyler Hobbs
DataStax <http://datastax.com/>
s SET foo = 1 WHERE
> id=99c3-b01a-11e5-b170-0242ac110002 IF foo=null; // fails, even though
> foo=null
> TRUNCATE test;
> INSERT INTO cmpayments.report_payments (id, bar) VALUES
> (99c3-b01a-11e5-b170-0242ac110002, 1); // succeeds
> INSERT INTO cmpayments.report_payments (i
ace for commitlog segments.
--
Tyler Hobbs
DataStax <http://datastax.com/>
.db files and they'll be
rebuilt on startup.
--
Tyler Hobbs
DataStax <http://datastax.com/>
ng 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/>
27;). 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/>
On Thu, Feb 4, 2016 at 9:57 AM, Jack Krupansky
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, I've fixed this.
query. Cassandra-cli does the job. Any solution?
>
>
>
> Thanks
> Anuj
>
--
Tyler Hobbs
DataStax <http://datastax.com/>
.apache.cassandra.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/>
7;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.
--
Tyler Hobbs
r and reconcile 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/>
t 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/>
tell to run 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/>
cassandra.apache.org/
>>
>> Downloads of source and binary distributions are listed in our download
>> section:
>>
>> http://cassandra.apache.org/download/
>>
>> This version is a bug fix release[1] on the 3.x series. As always, please
>> pay
>&
>
> Do you plan to fix that, e.g. fill with default values or exclude them?
>
> Thanks.
>
--
Tyler Hobbs
DataStax <http://datastax.com/>
ngrading major versions 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/>
bounded
> by sequence_nr (and are pretty fast), so there are certainly many
> tombstones (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/>
> 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 wrote:
>
>> This is a known problem with multi-column slices and mixed ASC/DESC
>> clustering
('x', 3, 11, 92) ;
> insert INTO dur (s, nd, ts, tid) values ('x', 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 satisfy the restriction (nd,ts) >
> (2, 11). Am I doing something incorrectly?
>
> Thanks,
> --Yuri
>
--
Tyler Hobbs
DataStax <http://datastax.com/>
; 金融华东事业部
>>>
>>> 东软集团股份有限公司
>>> 上海市闵行区紫月路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/>
; wrote:
>
>> Hi guys,
>>
>> Could you help me with this error?
>>
>> cassandra.Unavailable: code=1000 [Unavailable exception] message="Cannot
>> achieve consistency level LOCAL_QUORUM" info={'required_replicas': 2,
>> 'alive_re
7304797626cc69957eb6008695be1e/cassandra/connection.py#L573
>>
>> Is your error message complete?
>>
>> On Thu, Oct 29, 2015 at 9:45 AM, Eduardo Alfaia > > 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/>
nection 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/>
ache-cassandra-2.2.2.jar:2.2.2]
> at
> org.apache.cassandra.db.SliceFromReadCommand.getRow(SliceFromReadCommand.java:85)
> ~[apache-cassandra-2.2.2.jar:2.2.2]
> at
> org.apache.cassandra.service.StorageProxy$LocalReadRunnable.runMayThrow(StorageProxy.java:1537)
> ~[apache-cassandra
55)
> ~[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 wrote:
>
> Yeah, I was about t
> select * from myprofile where id=‘1’ and month=‘Oct’ and day=‘’ and hour=‘'
>
> This will have only about 500 rows or so.
>
>
> I believe that this is cause by the fact there are multiple updates done
> to this specific partition. So what do we think can be done to r
7;Key1' IF
>> version=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
n 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/>
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/>
uleOrder 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.
--
Tyler Hobbs
DataStax <http://datastax.com/>
ot too surprised to hear of this performance degradation.
>
> Yes, it is relatively likely to be the use of vnodes which is causing this
> problem. You could verify by having one of your nodes use 64 vnodes instead
> of the default 256... you will get less even distribution with current
&g
Seeking to partition 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 qu
g a timuuid to the primary key, for example),
but in some cases lightweight transactions may also be suitable.
--
Tyler Hobbs
DataStax <http://datastax.com/>
ease 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/>
t;>>> 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/>
n the second column .. (signature).
>
> And the value doesn’t seem to be TTLd.
>
> What’s 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/>
='';
>
> Requesting :
>
> [default@DUNE_metadonnees] list REF_File;
> Using default limit of 100 Using default cell limit of 100
> ---
> RowKey: id1
> => (name=COM_1, value=, timestamp=1437034903045000) => (name=COM_2,
> value=, timestamp=1437034911121000) => (name=folder, value=folder1,
> timestamp=1437034833452000) => (name=name, value=file1,
> timestamp=1437034851993000) => (name=size, value=1234,
> timestamp=1437034871356000)
> ---
> RowKey: id2
> => (name=COM_1, value=, timestamp=1437035169011000) => (name=folder,
> value=folder1, timestamp=143703506208) => (name=mime, value=image/jpeg,
> timestamp=1437035145227000) => (name=name, value=file2,
> timestamp=1437035073596000)
>
> Thanks for your help !
>
--
Tyler Hobbs
DataStax <http://datastax.com/>
ent).
It's worth 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/>
ired and all 3 replicas have different data
> with different timestamps.
>
> Options: data with latest timestamp is returned OR something else???
>
> Thanks
> Anuj
>
> Sent from Yahoo Mail on Android
> <https://overview.mail.yahoo.com/mobile/?.src=Android>
>
>
>
>
> --
> Arun
>
>
>
>
>
> --
> Arun
> Senior Hadoop/Cassandra Engineer
> Cloudwick
>
>
> 2014 Data Impact Award Winner (Cloudera)
>
> http://www.cloudera.com/content/cloudera/en/campaign/data-impact-awards.html
>
>
>
>
>
> --
> Arun
> Senior Hadoop/Cassandra Engineer
> Cloudwick
>
>
> 2014 Data Impact Award Winner (Cloudera)
>
> http://www.cloudera.com/content/cloudera/en/campaign/data-impact-awards.html
>
>
>
>
--
Tyler Hobbs
DataStax <http://datastax.com/>
e, in old Thrift
terms) don't do read repair.
--
Tyler Hobbs
DataStax <http://datastax.com/>
Timestamp(TimestampSerializer.java:111)
> at org.apache.cassandra.db.marshal.UUIDType.fromString(UUIDType.java:184)
> ... 12 more
> Caused by: java.text.ParseException: Unable to parse the date: currencyCode
> at
> org.apache.commons.lang3.time.DateUtils.parseDateWithLeniency(DateUtils.java:336)
> at
> org.apache.commons.lang3.time.DateUtils.parseDateStrictly(DateUtils.java:286)
> at
> org.apache.cassandra.serializers.TimestampSerializer.dateStringToTimestamp(TimestampSerializer.java:107)
> ... 13 more
> Exception encountered during startup: unable to make version 1 UUID from
> 'currencyCode'
>
>
>
>
>
--
Tyler Hobbs
DataStax <http://datastax.com/>
rom 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/>
On Fri, Jun 5, 2015 at 11:02 AM, Kévin LOVATO wrote:
> Great, so is there any reason I wouldn't want to set gc_grace_seconds to 0
> on an "insert once/ttl only" column family, since it feels like the best
> thing to do?
Nope, setting gc_grace_seconds to 0 is just fine i
ble to appear, and if so, would 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/>
k up. Voila, the formerly down node has a
> value that will replicate to the other nodes.
Correct, that's why they can't be purged immediately.
--
Tyler Hobbs
DataStax <http://datastax.com/>
commend testing it heavily with your use case for stability.
The best way to find out if your performance is good enough is to benchmark
it with your own usecase.
--
Tyler Hobbs
DataStax <http://datastax.com/>
aorund 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/>
e in latency).
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/>
s, etc).
>
> And more 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/>
mpanies have used 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/>
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 wrote:
> The python driver that we bundle with Cassandra for cqlsh is the normal
> python dr
increased by about 20%, but it still is an order of magnitude
>> faster than Cassandra.
>>
>>
>>> But I'm going to hazard a guess something else is going on with the
>>> Cassandra connection as I'm able to get 0.5ms queries locally and that's
>&
ALUES(3, 'yay');
>> INSERT 0 1
>> Time: 1.108 ms
>>
>> I then fired up a local copy of Cassandra (2.0.12)
>>
>> cqlsh> CREATE KEYSPACE foo WITH replication = { 'class' :
>> 'SimpleStrategy', 'replication_factor' : 1 };
>> 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/>
w that the
> nature of Cassandra compared to Postgresql 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/>
27;m not sure 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 wrote:
>>
>>> What version of Cassandra are you using? Since it sounds like you
>>> aren&#
t; Any reason why 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/>
round the field with double-quotes to handle this (or change the
quote character with the QUOTE option for COPY).
--
Tyler Hobbs
DataStax <http://datastax.com/>
olve
>>>>> *a*. You can see that we can't just use *b*'s clustering key to
>>>>> resolve that with LIMIT 1; also this is for DSE Solr, which wouldn't be
>>>>> able to query a by max b.foo anyway. So when we write to *b*, we
>>>&g
1 - 100 of 603 matches
Mail list logo
