this. When you delete a counter, you are basically saying I will
never use this counter again. If you try to use it again, the behavior is
undefined. It's one of the documented limitations of counters.
--
Tyler Hobbs
DataStax http://datastax.com/
, but yes, they are one way that cold
sstables may get compacted.
--
Tyler Hobbs
DataStax http://datastax.com/
supercolumn.
In my case, column is value of epoch time.
Just increment the timestamp you use for column_start by 1, then.
--
Tyler Hobbs
DataStax http://datastax.com/
and/or situations like scrub, range
queries ...?).
Well, I hope I'm wrong about this
Regards,
Ignace Desimpel
--
Tyler Hobbs
DataStax http://datastax.com/
='UTF8Type',super=True,
comparator='UTF8Type',key_validation_class='UTF8Type',
column_validation_classes=validators)
where validators={'longitude': 'DoubleType', 'latitude': 'DoubleType',}
--
Tyler Hobbs
DataStax http://datastax.com/
configurations:
python 2.7 apache cassandra 1.2.8, pycassa 1.10.0, thrift 0.9.1
any help would be greatly appreciated.
--
Tyler Hobbs
DataStax http://datastax.com/
in the OOM …
Is there someone that can make sense out of it?
I hope this helps in finding out what the reason is for this and maybe
could be avoided in the future. I still have the heap dump, so I can always
pass more information if needed.
Regards,
Ignace Desimpel
--
Tyler Hobbs
re-delete any deleted data that reappeared.
If you can set gc grace to 0, that will basically eliminate your tombstone
concerns entirely, so I would suggest that.
--
Tyler Hobbs
DataStax http://datastax.com/
On Tue, Jan 7, 2014 at 7:49 AM, Chris Burroughs
chris.burrou...@gmail.comwrote:
This has not reached a consensus in #cassandra in the past. Does
`nodetool cleanup` also remove data that has expired from a TTL?
No, cleanup only removes rows that the node is not a replica for.
--
Tyler
but in native memory?
That's correct.
--
Tyler Hobbs
DataStax http://datastax.com/
)
at java.lang.Thread.run(Thread.java:724)
What is your schema for this table?
--
Tyler Hobbs
DataStax http://datastax.com/
drivers, which don't normally get back the timestamp
for each column.
--
Tyler Hobbs
DataStax http://datastax.com/
=UTF8Type, )
- Here I want to specify, Column data types and row key type. How can
I do that ?
On Thu, Aug 15, 2013 at 12:30 PM, Tyler Hobbs ty...@datastax.com wrote:
The column_validation_classes arg is just for defining individual column
types. Glad you got it figured out, though
they
are defined in the schema first or run an ALTER statement, which may not be
the correct way to go. So is there a better way to model this type of data
with the new CQL world? Nor do I know how to query that type of data,
similar to the row slice by column name.
Thanks,
Bryce
--
Tyler Hobbs
/encryption is
not supported under the open source project and only with d-stax enterprise?
Thanks,
-David Laube
--
Tyler Hobbs
DataStax http://datastax.com/
--
Tyler Hobbs
DataStax http://datastax.com/
...@fusionts.comwrote:
Hi,
I’m looking for a way to view statistics. Mainly, I’d like to see the
distribution of writes and reads over the course of a day or a set of days.
Is there a way to do this through nodetool or by downloading a utility?
Thanks,
Parag
--
Tyler Hobbs
: rcp_timeout
- Hive /insert overwrite xxx from …. cannot specify columns / I
don’t want to save all columns and would like to restore into different
structure.
So what would be the solution? Is it possible at all?
Thanks.
--
Tyler Hobbs
DataStax http://datastax.com/
), but not (a). This is why I suggest using the same
rack for all nodes.
--
Tyler Hobbs
DataStax http://datastax.com/
loads - http://pastebin.com/ib3D0Pa
3. Nodetool tpstats - http://pastebin.com/s0AS7bGd
4. Cassandra-env.sh - http://pastebin.com/ubp4cGUx
5. GC log lines - http://pastebin.com/Y0TKphsm
Am I doing anything wrong. Any pointers will be appreciated.
Thanks in advance,
Ashish
--
Tyler Hobbs
caches are being used, despite them being turned on
in the cassandra.yaml file.
I'm using a 3 node cluster on amazon, using datastax community edition,
cassandra 2.0.1, in the same EC2 availability zone.
Many thanks,
@Mankins
--
Tyler Hobbs
DataStax http://datastax.com/
compression ?
Yes, compression is always on by default. Note that SSTable compression is
block-based and there's a fair amount of metadata in the SSTable that
compression can work on even if your column values aren't highly
compressable.
--
Tyler Hobbs
DataStax http://datastax.com/
out.
--
Tyler Hobbs
DataStax http://datastax.com/
.
Is this an error to worry about?
--
Tyler Hobbs
DataStax http://datastax.com/
behaves this way?
--
Tyler Hobbs
DataStax http://datastax.com/
that it will not.
--
Tyler Hobbs
DataStax http://datastax.com/
Oct 8 00:38
demodb-users-jb-6-Data.db
The two files look to be nearly the same size. There just appears to be
something special about that first SSTable and it not getting compacted.
On Tue, Oct 8, 2013 at 2:49 PM, Tyler Hobbs ty...@datastax.com wrote:
SizeTieredCompactionStrategy only
On Thu, Oct 3, 2013 at 8:37 AM, Girish Kumar girishkuma...@gmail.comwrote:
Additional capacity meaning add more writers and reader threads to handle
the requests ?
I think he means adding more nodes.
--
Tyler Hobbs
DataStax http://datastax.com/
On Tue, Oct 1, 2013 at 2:34 PM, Rene Kochen rene.koc...@emea.schange.comwrote:
However, Row Size and Column Count keep the values. When are they
re-evaluated?
They are re-evaluated during compaction.
--
Tyler Hobbs
DataStax http://datastax.com/
On Tue, Oct 1, 2013 at 3:52 PM, Rene Kochen rene.koc...@emea.schange.comwrote:
Does that mean that cfhistograms scans all Statistics.db files in order to
populate the Row Size and Column Count values?
On startup, yes. After that, it should be updated as new SSTables are
created.
--
Tyler
problem.
The documentation here (
http://www.datastax.com/documentation/cql/3.1/webhelp/index.html#cql/cql_reference/copy_r.html)
is misleading. Should I report this by other means than this post?
I've opened a ticket with our docs team to get this updated. Thanks!
--
Tyler Hobbs
DataStax
as a coordinator (due to hitting the timeout).
--
Tyler Hobbs
DataStax http://datastax.com/
, and
(probably) PHP drivers are also available. I believe there are some decent
options for node.js already, and various members of the community have also
put together drivers for Clojure, Scala, and Go.
--
Tyler Hobbs
DataStax http://datastax.com/
column family in Pycassa.
This[1] does not help.
Appreciate if someone can help me.
Thanks
1.
http://pycassa.github.io/pycassa/api/pycassa/system_manager.html#pycassa.system_manager.SystemManager.create_column_family
--
Tyler Hobbs
DataStax http://datastax.com/
= {'default_validation_class':COUNTER_COLUMN_TYPE}
sys.create_column_family('my_ks', 'vote_count',
column_validation_classes=cf_kwargs) #1
But this works:
sys.create_column_family('my_ks', 'vote_count', **cf_kwargs) #2
I thought #1 should work.
On Thu, Aug 15, 2013 at 9:15 PM, Tyler Hobbs ty
days (from the time when the snapshot was created)? if not can I
specify TTL when getting data from the snapshot?
If I use Priam will it make this process any easier?
Thanks.
-Rashmi
--
Tyler Hobbs
DataStax http://datastax.com/
to find
abstract-type class 'org.apache.cassandra.db.marshal.MyListType').
What I'm doing wrong? How to do it properly?
Thanks.
--
Vladimir Prudnikov
--
Tyler Hobbs
DataStax http://datastax.com/
questions, suggestions, or bug reports, I would love to
hear them!
--
Tyler Hobbs
DataStax http://datastax.com/
...@incubator.apache.org mailing list archive
at Nabble.com.
--
Tyler Hobbs
DataStax http://datastax.com/
of the nodes; any suggestion for a good profiling tool?
On Thu, Jul 18, 2013 at 5:50 PM, Tyler Hobbs ty...@datastax.com wrote:
The default limit is 16mb, but realistically you should try to keep
writes under 10mb, breaking up large values into multiple columns/rows if
necessary.
On Thu
. That will cause cql rows to be stored in sorted
order by the ts column (for a given value of counter) and allow you to do
the kind of query you're looking for.
--
Tyler Hobbs
DataStax http://datastax.com/
about doing something similar with the Thrift API, but
they will probably still be helpful:
- http://rubyscale.com/2011/basic-time-series-with-cassandra/
- http://www.datastax.com/dev/blog/advanced-time-series-with-cassandra
--
Tyler Hobbs
DataStax http://datastax.com/
=searchIndex[indexCF]**.xget(key)
for name, value in indexData:
print name
does not correctly print column name as parsed into a tuple of two parts.
Am I doing something wrong here ?
--
Regards,
Oleg Dulin
http://www.olegdulin.com
--
Tyler Hobbs
DataStax http
of the
data on that node to all other nodes that need it.
--
Tyler Hobbs
DataStax http://datastax.com/
(partially to help prevent data
loss in cases like this). The original node will still have the full set
of data unless you have run a cleanup operation (nodetool cleanup) on it.
--
Tyler Hobbs
DataStax http://datastax.com/
to load them directly. It will
stream the correct portions of the data to all of the appropriate nodes.
--
Tyler Hobbs
DataStax http://datastax.com/
On Thu, Jun 6, 2013 at 1:28 PM, Daning Wang dan...@netseer.com wrote:
could we set replication factor to 0 on other data center? what is the
best to way for not syncing some data in a cluster?
Yes, you can set it to 0, and that's the recommended way to handle this.
--
Tyler Hobbs
DataStax
-end machine I'm considering.
Any info or help anyone could provide would be most appreciated.
Regards,
Daniel Morton
--
Tyler Hobbs
DataStax http://datastax.com/
at the top of the
screen when it completes.
--
Tyler Hobbs
DataStax http://datastax.com/
Subject: Replica info
Is there a way in Cassandra that we can know which node has the replica
for the data ? if we have 4 nodes and RF = 2, is there a way we can find
which 2 nodes have the same data ?
Thanks,
Kanwar
--
Tyler Hobbs
DataStax http://datastax.com/
at
Nabble.com.
--
Tyler Hobbs
DataStax http://datastax.com/
, timestamp corresponds to DateType.
Use ALTER TABLE to add columns to a table:
http://www.datastax.com/docs/1.2/cql_cli/cql/ALTER_TABLE#cql-alter-columnfamily
--
Tyler Hobbs
DataStax http://datastax.com/
it.
Question: Will the node #6 have the data now to serve subsequent request
without going to the other nodes?
Question: Is it possible to do a local delete of the data without
replicating this delete?
--
Thank you,
Ostap
--
Tyler Hobbs
DataStax http://datastax.com/
+919540965199
--
Tyler Hobbs
DataStax http://datastax.com/
STORAGE:
http://www.datastax.com/docs/1.2/cql_cli/cql/CREATE_TABLE#using-compact-storage
--
Tyler Hobbs
DataStax http://datastax.com/
6 CF,
RF=3 and all operations are at quorum. Also at the end of the run nodetool
ring reports the same data size.
Thanks
Anand
--
Tyler Hobbs
DataStax http://datastax.com/
Samuelsson
--
Tyler Hobbs
DataStax http://datastax.com/
--
Tyler Hobbs
DataStax http://datastax.com/
exactly). So, either
using an offset for the second DC or evenly spacing all nodes is acceptable.
--
Tyler Hobbs
DataStax http://datastax.com/
and you successfully read, then quorum will
give you the latest data.
That's what I thought, but that's not what I'm seeing all the time. I have
no errors reading or writing.
André
--
Tyler Hobbs
DataStax http://datastax.com/
://wiki.apache.org/cassandra/DistributedDeletes
--
Tyler Hobbs
DataStax http://datastax.com/
://docs.python.org/2/library/datetime.html#datetime.datetime.strptime
Make sure your datetime objects have a UTC timezone, though.
--
Tyler Hobbs
DataStax http://datastax.com/
the meetup goes well.
--
Tyler Hobbs
DataStax http://datastax.com/
like phpmyAdmin for Cassandra?
There's DataStax OpsCenter, which has a free Community Edition:
http://www.datastax.com/products/opscenter
(Disclosure: I work at DataStax.)
--
Tyler Hobbs
DataStax http://datastax.com/
picks one token from each node and uses that, so some token-related things
are a bit off, but everything else should work normally. We're working on
more complete support for vnodes.
--
Tyler Hobbs
DataStax http://datastax.com/
) in 341,690ms =
1.159088MB/s. 233,761 total rows, 75,637 unique. Row merge counts were
{1:0, 2:15, 3:68757, 4:6865, }
Does anybody know what Row merge counts were {1:0, 2:15, 3:68757, 4:6865,
} means?
--
Thanks
A Jabbar Azam
--
Tyler Hobbs
DataStax http://datastax.com/
RAC1Up Normal 15.73 KB
0.00% 85070591730234615865843651857942052863
10.20.5.85 DC1 RAC1Up Normal 20.24 KB
0.00% 127605887595351923798765477786913079295
Thanks,
Dean
--
Tyler Hobbs
DataStax http://datastax.com/
to all nodes in both datacenters, with a consistency
level of LOCAL_QUORUM.
I'm seeing write performance of around 2500 rows per second.
Is this in the ballpark for this kind of configuration?
Thanks in advance.
Ken
--
Tyler Hobbs
DataStax http://datastax.com/
Yes, C* is short for Cassandra.
On Fri, Feb 8, 2013 at 10:43 AM, Boris Solovyov boris.solov...@gmail.comwrote:
I see people refer to C* and I assume it mean Cassandra, but just wanted
to check for sure. In case it is somethings else and I miss it :) Do I
right understand?
--
Tyler Hobbs
7573657232323132333035343936323937363138343433
cqlsh:usertable
what should I do to get the field through pycassa API.
thanks
pradeep
--
Tyler Hobbs
DataStax http://datastax.com/
:
org.apache.cassandra.io.compress.SnappyCompressor
** **
** **
** **
Any ideas?
--
Tyler Hobbs
DataStax http://datastax.com/
205 Up Normal 84.63 KB
0.00% 9187343239835811839
** **
So both boxes are showing up in the ring.
** **
*Thank you guys SO MUCH for helping me figure this stuff out.*
** **
** **
*From:* Tyler Hobbs [mailto:ty...@datastax.com]
*Sent:* Monday
me know, why I see this huge performance difference
and is there any way I can improve the operations/second using pycassa
client.
thanks
pradeep
--
Tyler Hobbs
DataStax http://datastax.com/
I right ?
StorageProxy read/write counts should equal the number of client requests.
ColumnFamily read/write counts correspond to actual, local data reads, so
the sum of this number across all nodes will be approximately RF * the
StorageProxy counts.
--
Tyler Hobbs
DataStax http://datastax.com/
information
into endpoint and endpoint_details columns, and also the Astyanax client
works properly.
Hope it will avoid others to avoid spending time to figure out how to go
around this issue.
Br,
Gabi
--
Tyler Hobbs
DataStax http://datastax.com/
= 'SimpleStrategy'
AND strategy_options:replication_factor='1';
--
Tyler Hobbs
DataStax http://datastax.com/
seconds
Please have a look at the script attached.. and let me know if I need
to change something.. Please bear with me, if I do something terribly
wrong..
I am running the script on a 8 processor node.
thanks
pradeep
On Thu, Jan 17, 2013 at 4:18 PM, Tyler Hobbs ty...@datastax.com wrote
',
server_list=server_list,pool_size=32,timeout=60)
It seems the performance is still stuck at 521 seconds.. which is 177
seconds for cassandra-cli.
Am I still missing something?
thanks
Pradeep
On Fri, Jan 18, 2013 at 7:12 AM, Tyler Hobbs ty...@datastax.com wrote:
You just need to increase
to interpret this?
Thanks.
Brian Tarbox
--
Tyler Hobbs
DataStax http://datastax.com/
PM, Brian Tarbox tar...@cabotresearch.comwrote:
Hmm, that's sense but then why is the latency for the reads that get the
metric often so high (several thousand uSecs) and why does it so closely
track the latency of my normal reads?
On Wed, Jan 16, 2013 at 12:14 PM, Tyler Hobbs ty
against hunger.
To learn how you can help in your community, please visit:
http://on.fb.me/UAdL4f
--
Tyler Hobbs
DataStax http://datastax.com/
for Cassandra as it allows you to optimize for
reads while only sacrificing extra disk space and a minor amount of write
overhead (writes are very cheap in Cassandra).
--
Tyler Hobbs
DataStax http://datastax.com/
ideas.
On Wed, Jan 2, 2013 at 11:41 AM, James Masson james.mas...@opigram.comwrote:
On 02/01/13 16:18, Tyler Hobbs wrote:
On Wed, Jan 2, 2013 at 5:28 AM, James Masson james.mas...@opigram.com
mailto:james.masson@opigram.**com james.mas...@opigram.com wrote:
1) Hector sends a request
them anywhere, which would be useful for when you're
actively watching the cluster.
Thanks!
--
Tyler Hobbs
DataStax http://datastax.com/
. For example, we're considering Coordinated Read
Request Latency or Client Read Request Latency in place of just Read
Request Latency.
--
Tyler Hobbs
DataStax http://datastax.com/
/indexing-in-cassandra.html
On Thu, Dec 13, 2012 at 11:35 AM, Alain RODRIGUEZ arodr...@gmail.comwrote:
Hi Edward, can you share the link to this blog ?
Alain
2012/12/13 Edward Capriolo edlinuxg...@gmail.com
Ed ENuff s
--
Tyler Hobbs
DataStax http://datastax.com/
that the window of failure for affected ranges would
probably be small but we do Quorum reads of many keys, so we'd likely hit
every virtual range with our queries, even if num_tokens was 256.
Thanks,
Eric
--
Tyler Hobbs
DataStax http://datastax.com/
logs it should solve
my problem. I'm wondering if someone has any experience with this feature?
Thank you,
Andrey
--
Tyler Hobbs
DataStax http://datastax.com/
gets flushed
independently. I have hot CF which gets flushed every several minutes and
regular CF which gets flushed every hour or so. They have references to
each other and data in sstables is definitely inconsistent.
On Fri, Dec 7, 2012 at 9:28 AM, Tyler Hobbs ty...@datastax.com wrote
family. Is there any other way to take backup and restore quick.
/opt/apache-cassandra-1.1.4/bin/nodetool -h localhost snapshot -t
cassandra_bkup
*Snapshot directory:*
/var/log/cassandra/data/KeySpace/subfolder/snapshot/cassandra_bkup
--
Thanks Regards
*Adeel** Akbar*
--
Tyler Hobbs
process with just one thread. Someone knows why?
--
Everton Lima Aleixo
Bacharel em Ciencia da Computação
Universidade Federal de Goiás
--
Tyler Hobbs
DataStax http://datastax.com/
:created'] = 1351728000;
and insert String for description
set user[1]['7:1:100:desc'] = my description;
I don't see a way to define validation_class for composite column. Am I
right?
Thanks.
-Wei
--
Tyler Hobbs
DataStax http://datastax.com/
find that get_range_slice doesn't query rowcache before reading from
Memtable and SSTable. I just want to make sure whether I've overlooked
something. If my observation is correct, what's the consideration here?
--
Tyler Hobbs
DataStax http://datastax.com/
is -2^63 + 1 (leaving -2^63 for special purposes,
similar to -1 in RandomPartitioner)?
--
Tyler Hobbs
DataStax http://datastax.com/
be the coordinator? I would guess the latter is the case, otherwise it
can't explain why the third node is always slower than the other two given
the fact it's in charge of the wider columns than the other two.
Thanks.
-Wei
--
*From:* Tyler Hobbs ty
to the
correct nodes automatically.
--
Tyler Hobbs
DataStax http://datastax.com/
someone please
shed some lights?
Thanks.
-Wei
--
Tyler Hobbs
DataStax http://datastax.com/
/boneill42/
blog: http://brianoneill.blogspot.com/
--
Tyler Hobbs
DataStax http://datastax.com/
using Cassandra 1.1 and CQL 3.0. What could be the problem?
-Thomas
** **
** **
--
Best wishes,
Helping others is to help myself.
--
Tyler Hobbs
DataStax http://datastax.com/
. Will that help?
I would leave your heap at 4G. You really do want key caching enabled in
almost all circumstances; it can save you a lot of disk activity on reads.
If you need to bump your heap up to 4.5G to accommodate key caches, it's
worth it.
--
Tyler Hobbs
DataStax http://datastax.com/
201 - 300 of 552 matches
Mail list logo