n would fit in the good practice by applying the
formulae from this video:
https://academy.datastax.com/courses/ds220-data-modeling/physical-partition-size
Cheers!
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 23 April 2016 at 20:25, Anuj Wadehra wrote:
Hi Jens.
Thanks for your response but my idea is to count different keys, so, if I
understood correctly selecting WHERE key = #{key} won't give me any new
key, right?
Thanks!
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 25 April 2016 at 09:22,
one with highest timestamp (last write wins) if they
don't agree, and running a read repair (repair that particular record) if
the nodes didn't agreed.
Hope this helps.
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 29 April 2016 at 04:33, Anuj Wade
If you're deleting all traces of the index you probably want to look at the
commit log as they are probably being recreated from there.
Hope it helps.
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 5 August 2016 at 23:05, Charlie Moad wrote:
> Run
Are you running the migration to create the flapalarmcache table from more
than one client concurrently?
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 16 August 2016 at 10:51, Kamal C wrote:
> Hi all,
>
> I'm using cassandra-3.7 version,
Ok cool, glad you found the issue.
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 17 August 2016 at 09:48, Kamal C wrote:
> Carlos,
> Yes, I'm running multiple clients simultaneously. Each one of them tries
> to create table if it doesn'
/architectureDataDistributeReplication_c.html
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 18 August 2016 at 12:15, jean paul wrote:
> Hi,
>
>
> The distributed replicas take space. Is there a scenario when a new
> replicas cannot be stored on a node due to
Replies inline
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 18 August 2016 at 11:56, Lu, Boying wrote:
> Hi, All,
>
>
>
> We use Cassandra in our product. I our early release we use Cassandra
> 1.2.10 whose SSTable is ‘ic’ format.
>
as a seed.
Finally run nodetool status to check that they see each other.
Hope it helps
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 25 August 2016 at 10:19, Alexandr Porunov
wrote:
> Hello,
>
> I am little bit confusing about cassandra&
Maybe a good question could be:
Which is your access pattern to this data?
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 31 August 2016 at 11:47, Stone Fang wrote:
> Hi all,
> have some questions on how to define clustering key.
>
> have
e sweet spot for
your use case.
Regards
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 1 September 2016 at 02:58, Stone Fang wrote:
> access pattern is
>
> select *from datacenter where datacentername = '' and publish>$time and
>
By inspecting the contents on your system.hints table, specifically the
host_id column, you can see which is the destination host of those hints
and check if it is one of the alive or dead ones.
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 18 September 2016
Cassandra is a Wide Column Store http://db-engines.com/en/system/Cassandra
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 30 September 2016 at 18:24, Mehdi Bada
wrote:
> Hi all,
>
> I have a theoritical question:
> - Is Apache Cassandra rea
cluster is back to
1 datacenter with 3 nodes and then add them sequentially again making sure
the configuration in the Snitch is the proper one.
Regards.
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 28 October 2016 at 10:06, Robert Sicoie wrote:
> Hi
ggested primary key will work for queries like "Give me the
version(s) of this particular device_name in this particular time range"
Hope it helps.
Regards
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 7 November 2016 at 01:23, sat wrote:
> Hi
ation)
from one node to another and stop the old node and start the new one. As
the configuration is all the same (just the ip will change) it joins the
ring as if it was the old one. And there's no need for any bootstrapping.
BTW, are you using vnodes?
Regards
Carlos Alonso | Software Engine
Bear in mind that LWT will, under certain circumstances fail too. See
amazing Chris Batey's talk about it on Cassandra Summit:
https://www.youtube.com/watch?v=wcxQM3ZN20c
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 7 November 2016 at 22:22, Justin Cam
task (every night maybe?) that deletes the extra rows that are not
needed anymore.
The query pattern for this is quite efficient as something like SELECT *
FROM user_views WHERE user_name = ? LIMIT 10;
Regards
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
Hi Ben, you're right, but in my example the last_time timestamp field is
actually part of the primary key.
Regards
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 10 November 2016 at 11:50, Benjamin Roth wrote:
> I pretty much guess the CQL you pos
Hi Kamesh.
Flushing memtables to disk causes the corresponding commitlog segments to
be deleted. Once the data is flushed into SSTables it can be considered
durable (in case of a node crash, the data won't be lost), and therefore
there's no point in keeping it in the commitlog as well.
Try withou
gt; flushing. Still not able to read the commit logs.
> However, I am able to read the commit logs of *system* and
> *system_schema* key spaces but not able to read the application key space
> (key space created by me).
>
> Thanks & Regards
>
> Kamesh.
>
> On Wed, No
This article from Spotify Labs is a really nice write up of migrating SQL
(Postgres in this case) to Cassandra
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 23 June 2015 at 20:23, Alex Popescu wrote:
>
> On Tue, Jun 23, 2015 at 12:13 PM, Marcos
Hi Moreno,
Which consistency level are you using? If you're using ONE, that may make
sense, as, depending on the partitioning and the cluster coordinating the
query, different values may be received.
Hope it helps.
Regards
Carlos Alonso | Software Engineer | @calonso <https://twi
ic integer,
flexible_allowance float,
PRIMARY KEY(EmpID, month)
)
That way the salaries will be partitioned by EmpID and clustered by month,
which I guess is the natural sorting you want.
Hope it helps,
Cheers!
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
O
estion for getting a salary by employee ID and I'd also have
Peter's one to run the end of the month query.
Does it make sense?
Cheers!
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 7 July 2015 at 09:07, Srinivasa T N wrote:
> Thanks for the
Hi Jerome,
Good point!! Really a nice usage of static columns! BTW, wouldn't the EmpID
be static as well?
Cheers
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 7 July 2015 at 14:42, Jérôme Mainaud wrote:
> Hello,
>
> You can slightly ad
clustering order, the
latest modification will always be first record in the row.
Hope it helps.
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 21 July 2015 at 05:59, Robert Wille wrote:
> Data structures that have a recently-modified access pattern see
IMARY KEY(date, docId), making all
docs modified in same day be together in the same partition, and on the
other hand, two updates on the same date won't generate a two rows as the
primary key would be exactly the same.
Does it make sense?
Carlos Alonso | Software Engineer | @calo
Really interesting question Artur. Have you gone any further?
I think, based on my experience and recalling Cassandra's good practices,
that full denormalisation is the Cassandra way to go.
Cheers
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 11 Sep
Hi guys.
I'm already here and I'll be the whole Summit. I'll be doing a live demo on
Thursday on troubleshooting Cassandra production issues as a developer.
This is me!! https://twitter.com/calonso/status/646352711454097408
Carlos Alonso | Software Engineer | @calonso <h
Hi guys.
I have a very old cassandra cluster 1.2.19 and I'm looking to add a new
datacenter to it for analytics purposes in a newer version, let's say
2.1.8. Will those DC's communicate properly?
Regards
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
Hi guys.
Thanks for your reply.
Is this because the versions are very far from each other (e.g. Different
major versions) Or as a rule of thumb, all nodes in a cluster, even in
different DC's MUST have the same version?
Regards
Carlos Alonso | Software Engineer | @calonso <https://twi
can think of the that header being a reference to the specific record of
that column in the system.schema_columns table and some programming logic
to match data types and fill missing fields before replying to the client.
Is that right?
Cheers!
Carlos Alonso | Software Engineer | @calonso <ht
Here is my particular Summit Recap:
http://mrcalonso.com/notes-on-cassandra-summit-2015/
Thanks to everyone for such a great contents and thanks DataStax as well
for the great organisation.
Cheers!
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
So glad to be one of the awarded and big congratulations to everyone else
in that list!!
http://www.planetcassandra.org/mvps/
Thanks DataStax and let's keep pushing this product/community for more!!
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
Hi Stephen.
The UnknownColumnFamilyException made me thought of a possible schema
disagreement in which any of your nodes has a different version and
therefore you cannot reach quorum?
Can you run nodetool describecluster and see if all nodes have the same
schema versions?
Cheers!
Carlos
And that's a stupid one, I know, but does the column you're trying to
access actually exist?
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 1 October 2015 at 11:09, Walsh, Stephen wrote:
> I did think of that and they are all the same version
Which versions of Cassandra and OpsCenter are you using? Because probably
opscenter and your app are using cql and cqlsh is using thrift or vice
versa and that's why depending on where you access from you see different
things?
Carlos Alonso | Software Engineer | @calonso <https://twi
Well... I wasn't expecting that, as both OpsCenter 5.2.1 and cqlsh in
Cassandra 2.1.x both use native protocol. I was expecting them having
different protocols, so
Have no further ideas :(
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 1 October 20
While decommissioning nodes...Why doesn't OpsCenter show it as an activity
or something in the status of the node?
That would be helpful to monitor the progress, as when upgrading sstables
or compacting for example.
Regards
Carlos Alonso | Software Engineer | @calonso <https://twi
node being decommisioned is in a different version to the
others
Any ideas?
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
:2.1.9.791]
at
org.apache.cassandra.streaming.ConnectionHandler$IncomingMessageHandler.run(ConnectionHandler.java:250)
~[cassandra-all-2.1.9.791.jar:2.1.9.791]
at java.lang.Thread.run(Thread.java:745) [na:1.7.0_75]
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
://issues.apache.org/jira/browse/CASSANDRA-6053
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 8 October 2015 at 19:24, sai krishnam raju potturi
wrote:
> the below solution should work.
>
> For each node in the cluster :
> a : Stop cassandra service
Yeah, I was about to suggest the compaction strategy too. Leveled
compaction sounds like a better fit when records are being updated
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 8 October 2015 at 22:35, Tyler Hobbs wrote:
> Upgrade to 2.2.2. Your sst
Yes Ajay, in your particular scenario, after all hints are delivered, both
CAS11 and CAS12 will have the exact same data.
Cheers!
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 11 October 2015 at 05:21, Ajay Garg wrote:
> Thanks a ton Anuja for
!
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 16 October 2015 at 14:09, wrote:
> Hi,
>
> I'm looking for a tool for management and monitoring of the status of
> nodetool repair.
>
> Currently I am trying to test cassandra-reaper, but if y
Could you send cfhistograms and cfstats relevant to the read column family?
That could help
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 17 October 2015 at 16:15, Brice Figureau <
brice+cassan...@daysofwonder.com> wrote:
> Hi,
>
> I'v
ibly, java stack
traces.
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 19 October 2015 at 14:00, wrote:
> Thx Carlos,
>
>
>
> How can I get information on error during repair ?
>
>
>
> Thx.
>
> *De :* Carlos Alonso [mailto:i...@
atency. Can you check that
command in all nodes?
Regards
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 20 October 2015 at 13:59, Brice Figureau <
brice+cassan...@daysofwonder.com> wrote:
> Hi,
>
> Thanks for your answer. Unfortunately since I
very
wide rows), but very heavy weighting (lots of data).
Does that make sense?
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 21 October 2015 at 08:35, Brice Figureau <
brice+cassan...@daysofwonder.com> wrote:
> Hi,
>
> On 20/10/2015 19:48, C
ience with this?
Regards
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
Well, everything was fine.
The streams finished and after that the node joined the ring nicely and
everyone removed the old one. :)
Thanks!
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 29 October 2015 at 21:45, Robert Coli wrote:
> On Thu, Oct 29,
actions I'd use DTCS or LCS, but given that you will have a big
amount of tombstones due to TTLs I'd never go with STCS.
Hope it helps!
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 30 October 2015 at 10:55, wrote:
> Hi,
>
>
>
> Cou
Any update about this?
@Carlos Rolo, did you tried it? Thoughts?
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 5 November 2015 at 14:07, Carlos Rolo wrote:
> Something to do on a expected rainy weekend. Thanks for the information.
>
> Rega
Maybe schema disagreement?
Run nodetool describecluster to discover
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 13 November 2015 at 11:14, Rajesh Radhakrishnan <
rajesh.radhakrish...@phe.gov.uk> wrote:
>
> Hi,
>
> I am using Cassandra 2
Ok, so by default the CONSISTENCY LEVEL of CQLSH is ONE.
Therefore it could be that the node you're connected to doesn't actually
contain any of this data.
Try improving the CL for that read and see what happens.
Regards.
Carlos Alonso | Software Engineer | @calonso <https:
so use the thrift client to list it and
see how it looks on disk and see if there's something wrong.
If the data is there and looks fine, probably there's a problem managing
varints somewhere in the read path.
Regarfds
Carlos Alonso | Software Engineer | @calonso <https://twit
Are both nodes using the same Cassandra version?
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 20 November 2015 at 23:00, Arun Sandu wrote:
> Hi,
>
> 1. What would be the reason for hints getting timed out? None of the nodes
> went down. usin
Did you tried to observe it using cassandra-cli? (the thrift client)
It shows the 'disk-layout' of the data and may help as well.
Otherwise, if you can reproduce it having a varint as the last part of the
partition key (or at any other location), this may well be a bug.
Carlos Alonso
May it be a SizeTieredCompaction of big SSTables just finished and freed
some space?
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 26 November 2015 at 08:55, Luigi Tagliamonte wrote:
> Hi Everyone,
> I'd like to understand what cleanup does on
Hi Mukil.
As batches aren't isolated, I think write conflicts are effectively
possible unless, somehow, you prevent them with LWT.
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 17 December 2015 at 00:08, Mukil Kesavan
wrote:
> Hello,
>
>
Why is the old node not able to restart?
If you're about to bring a new one to replace the old dead one, it may be
simpler to just replace it
https://docs.datastax.com/en/cassandra/2.0/cassandra/operations/ops_replace_node_t.html
Hope it helps.
Carlos Alonso | Software Engineer | @ca
I have never used Materialized Views so maybe this suggestion is not
possible, but in this case, wouldn't it make sense to define the
materialized view as
is_favourite IS TRUE
instead of
is_favourite IS NOT NULL?
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso
.
Regards
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 12 January 2016 at 07:30, anuja jain wrote:
> 1 more question, what does it mean by "cassandra inherently sorts data"?
> For eg:
> I have a table with schema
>
> CREATE TABLE users
Why can't you have something like this?
CREATE TABLE t (
p INT,
q1 INT,
q2 UUID,
c1 INT,
c2 TEXT,
PRIMARY KEY (p, q1, q2)
)
Sounds the simplest solution.
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 12 January 2016 at 18:27, Bamoqi wrote
I'd have a look also at possible running compactions.
If you have big column families with STCS then large compactions may be
happening.
Check it with nodetool compactionstats
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 13 January 2016 at 05:22, Kev
Hi Robert.
I'm thinking of upgrading hardware in place. Can you please elaborate a bit
more on how to use the auto_bootstrap=false + hibernate repair technique?
Cheers!
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 6 January 2016 at 11:10, Herbert Fis
than write
just once and have expensive reads.
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 15 January 2016 at 05:57, anuja jain wrote:
> @Jonathan
> what do you mean by "you'll need to maintain your own materialized view
> tables"?
&
I ran through those issues a while ago.
It was on Ubuntu rather than OSX but probably the same.
I compiled my steps here:
http://mrcalonso.com/fitting-ipython-notebooks-spark-and-cassandra-all-together/
Cheers!
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
Before closing this.
Would the reason possibly be that with SimpleStrategy and RF=1 the data is
only on one node on a single DC, and when the driver was connecting to the
other DC, LOCAL_ONE could not be achieved?
Regards.
Carlos Alonso | Software Engineer | @calonso <https://twitter.
Hi Ahmed,
I think modelling them as a map where you can 'label' your emails or
addresses sounds like a good option.
More info here:
https://docs.datastax.com/en/cql/3.1/cql/cql_using/use_map_t.html
Regards
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/ca
Hi Oleg.
The drivers have builtin the timeout configurable functionality.
Hope it helps.
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 28 January 2016 at 22:18, oleg yusim wrote:
> Greetings,
>
> Does Cassandra support session timeout? If so, w
I personally don't use the Java but the Ruby driver, but I'm pretty sure
you'll be able to find it in the docs:
https://github.com/datastax/java-driver
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 29 January 2016 at 13:15, oleg yusim
Oh, I thought you meant read/write timeout, not session timeout due to
inactivity...
Not sure there's such option. Sorry
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 29 January 2016 at 13:35, oleg yusim wrote:
> Carlos,
>
> I went thr
t has quite a
lot of activity and its easy sometimes to miss emails.
About this session timeout thing, could you please reply to this thread if
you find a solution? I'm curious about it.
Cheers!
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 29 January 2
Hi,
The coordinator will send mutations to all required replicas and wait for
required acknowledgements to fulfil consistency level.
Regards
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 4 February 2016 at 11:56, wrote:
> Hello,
>
>
&g
ired wherever there are
writes/updates.
Regards
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 9 February 2016 at 11:10, Anuj Wadehra wrote:
> Hi,
>
> Can someone take this?
>
>
> Thanks
> Anuj
>
>
>
> On Mon, 8 Feb, 2016 at 11:
Here we use the Cassanity gem: https://github.com/jnunemaker/cassanity
This one suggests using schema migration files that are then registered in
a column family to keep track of the version.
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 10 February 2016 at
way, you avoid client side joins.
Hope this helps!
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 12 February 2016 at 09:25, Harikrishnan A wrote:
> Hello,
> I have a scenario where I need to create a customer master table in
> cassandra which
Hi Jason
Try this:
https://docs.datastax.com/en/cassandra/2.1/cassandra/tools/toolsRefresh.html
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 24 February 2016 at 07:07, Jason Kania wrote:
> Hi,
>
> I encountered an error in Cassandra or the la
vided for that
(you probably saw a warning note at the last line of nodetool status'
output.
Hope this helps.
Regards
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 26 February 2016 at 03:53, Jason Kania wrote:
> Hi,
>
> I am wondering if ther
retrieved range) is too big is
why the nodes get overloaded and end up dropping the read requests.
If you see GC pressure that would point towards my hypothesis too.
Hope this helps.
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 25 February 2016 at 16:34,
reading was taken. This works for a
>> number of queries but for scanning all the readings against a particular
>> sensorUnitId and sensorId combination, we seem to be stuck.
>>
>> We won't know the range of valid values of the timeShardId for a given
>> sensorUnitId and sensorId combination so would have to write to an
>> additional table to track the valid timeShardId. We suspect this would
>> create tombstone accumulation problems given the number of updates required
>> to the same row so haven't tried this option.
>>
>> Alternatively, we hit a different bottleneck in the form of SELECT
>> DISTINCT in trying to directly access the partition keys. Since SELECT
>> DISTINCT does not allow for a where clause to filter on the partition key
>> values, we have to filter several hundred thousand partition keys just to
>> find those related to the relevant sensorUnitId and sensorId. This problem
>> will only grow worse for us.
>>
>> Are there any other approaches that can be suggested? We have been
>> looking around, but haven't found any references beyond the initial
>> suggestion to add some sort of shard id to the partition key to handle wide
>> rows.
>>
>> Thanks,
>>
>> Jason
>>
>>
>>
>>
>>
>>
>>
>>
>
--
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
pdate the 'last partition' entry for a
sensor if we're really one week after the latest saved. That will generate
one single tombstone per sensor and that doesn't sound scary I think.
On the other hand. Did you considered offloading the historical data to a
better data warehouse
They'll be duplicated. The only way of having one single value per
partition is to declare it as static.
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 8 March 2016 at 11:49, X. F. Li wrote:
> Hi,
>
> If a cluster column has the same value ov
You're inserting just a set {'f...@baggins.com', 'bagg...@gmail.com'} under
the key 'emails' and another set {'a...@baggins.com', 'c...@gmail.com'} for the
key 'unverifiedEmails' for your loginIds hash instead of the UDT.
Carlos A
ion = 2 where ... IF
version = 1 (version number previously read, of course)
Hope this helps.
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 17 March 2016 at 07:22, Max C wrote:
> Hello,
>
> What are your best practices for avoiding collisions when
Yes, they could.
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 17 March 2016 at 16:10, Thouraya TH wrote:
> Hi all;
>
> Please, i have a question about the architecure behind SELECT command.
> Given this table:
>
> c1 c2 c3
vely using disk space.
Hope this helps.
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 22 March 2016 at 07:57, Anishek Agarwal wrote:
> Hello,
>
> Using cassandra 2.0.17 on one of the 7 nodes i see that the "Load" column
> from nodetool
Try surrounding it with quotes.
Didn't know about the reserved keyword full though.
Regards
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 30 March 2016 at 10:36, Jean Carlo wrote:
> Hi!
>
> I am creating my new tables on cassandra 2.1.12
Well...
I guess that if full is a reserved word there's nothing you can do to
change that but then, checking which are the keywords for that version it
turns out that full is not there!!
https://docs.datastax.com/en/cql/3.1/cql/cql_reference/keywords_r.html
Maybe a bug?
Regards
Carlos A
This is probably due to corrupt data or a cassandra upgrade where you
didn't ran upgradesstables
I'd then suggest scrubbing the column family (or upgrading it).
Hope it helps.
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 31 March 2016 at 12:1
/cassandra-instantaneous-in-place-node-replacement/
We've been using it for a while and works nicely and avoids the time,
resources and baby-sitting consumption of streaming data across nodes.
Regards
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 31 March
Mmm ok, then I think you may need follow the standard dead node replacement
procedure:
https://docs.datastax.com/en/cassandra/2.2/cassandra/operations/opsReplaceNode.html
Cheers!
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 31 March 2016 at 16:34, Peddi, P
Hi Lokesh,
This may sounds a bit silly but... What about starting Cassandra process in
that box?
Regards,
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 11 April 2016 at 19:16, Lokesh Ceeba - Vendor
wrote:
> Team,
>
> Can you
It will be possible after the tokens reassignment has finished.
Actually Cassandra itself will tell you. If you try the remove command and
is not possible it will fail with an error indicating that the operation is
not possible while there are nodes in Joining status.
Regards
Carlos Alonso
OM tbl WHERE
token(key) = #{token}")
else
results = connection.execute("SELECT token(key), key FROM tbl WHERE
token(key) >= #{token} LIMIT 1")
end
last_token = token
end
puts keys.keys.count
What am I missing?
Thanks!
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
er log or saved to a
particular column family to analyse them later. I've googled about this and
the only 'easy' solution available out there seems to be DataStax
Enterprise.
What are you guys using?
Thanks,
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
the driver otherwise (hopefully is not very hard).
Regards
Carlos Alonso | Software Engineer | @calonso <https://twitter.com/calonso>
On 18 June 2015 at 12:21, DE VITO Dominique <
dominique.dev...@thalesgroup.com> wrote:
> Hi Carlos,
>
>
>
> Different possibi
99 matches
Mail list logo
