>> latency queries (on known access patterns), high volume/low latency writes,
>>> easy scalability, etc. then you are going to have to rethink how you model
>>> the data.
>>>
>>>
>>>
>>>
>>>
>>> Sean Durity
>>
then you are going to have to rethink how you model the
>> data.
>>
>>
>>
>>
>>
>> Sean Durity
>>
>>
>>
>> *From:* Kenneth Brotman
>> *Sent:* Thursday, February 07, 2019 7:01 AM
>> *To:* user@cassandra.apache.org
&
, easy
> scalability, etc. then you are going to have to rethink how you model the
> data.
>
>
>
>
>
> Sean Durity
>
>
>
> *From:* Kenneth Brotman
> *Sent:* Thursday, February 07, 2019 7:01 AM
> *To:* user@cassandra.apache.org
> *Subject:* [EXTERNAL] R
] RE: SASI queries- cqlsh vs java driver
Peter,
Sounds like you may need to use a different architecture. Perhaps you need
something like Presto or Kafka as a part of the solution. If the data from the
legacy system is wrong for Cassandra it’s an ETL problem? You’d have to
transform the data
that a proper data model
for Cassandra can be used.
From: Peter Heitman [mailto:pe...@heitman.us]
Sent: Wednesday, February 06, 2019 10:05 PM
To: user@cassandra.apache.org
Subject: Re: SASI queries- cqlsh vs java driver
Yes, I have read the material. The problem is that the application has
20carpenter%20chapter%205=false>
> .
>
>
>
> Kenneth Brotman
>
>
>
> *From:* Peter Heitman [mailto:pe...@heitman.us]
> *Sent:* Wednesday, February 06, 2019 6:33 PM
>
>
> *To:* user@cassandra.apache.org
> *Subject:* Re: SASI queries- cqlsh vs java driver
>
ubject: Re: SASI queries- cqlsh vs java driver
Yes, I "know" that allow filtering is a sign of a (possibly fatal) inefficient
data model. I haven't figured out how to do it correctly yet
On Thu, Feb 7, 2019, 7:59 AM Kenneth Brotman
wrote:
Exactly. When you design your data mod
ALLOW FILTERING in the queries. That is not recommended.
>
>
>
> Kenneth Brotman
>
>
>
> *From:* Peter Heitman [mailto:pe...@heitman.us]
> *Sent:* Wednesday, February 06, 2019 6:09 PM
> *To:* user@cassandra.apache.org
> *Subject:* Re: SASI queries- cqlsh vs java dr
like a lot.
Kenneth Brotman
From: Peter Heitman [mailto:pe...@heitman.us]
Sent: Tuesday, February 05, 2019 6:59 PM
To: user@cassandra.apache.org
Subject: Re: SASI queries- cqlsh vs java driver
The table and secondary indexes look generally like this. Note that I have
changed the names
> Kenneth Brotman
>
>
>
> *From:* Peter Heitman [mailto:pe...@heitman.us]
> *Sent:* Tuesday, February 05, 2019 6:59 PM
> *To:* user@cassandra.apache.org
> *Subject:* Re: SASI queries- cqlsh vs java driver
>
>
>
> The table and secondary indexes look generally l
PM
To: user@cassandra.apache.org
Subject: Re: SASI queries- cqlsh vs java driver
The table and secondary indexes look generally like this. Note that I have
changed the names of many of the columns to be generic since they aren't
important to the question as far as I know. I left the actual
the same as IN query, but I don’t if it makes a difference
>> for performance.
>>
>>
>>
>> *From: *Peter Heitman
>> *Reply-To: *"user@cassandra.apache.org"
>> *Date: *Monday 4 February 2019 at 07:17
>> *To: *"user@cassandra.apache.org"
;user@cassandra.apache.org"
> *Date: *Monday 4 February 2019 at 07:17
> *To: *"user@cassandra.apache.org"
> *Subject: *SASI queries- cqlsh vs java driver
>
>
>
> When I create a SASI index on a secondary column, from cqlsh I can execute
> a query
>
>
-To: "user@cassandra.apache.org"
Date: Monday 4 February 2019 at 07:17
To: "user@cassandra.apache.org"
Subject: SASI queries- cqlsh vs java driver
When I create a SASI index on a secondary column, from cqlsh I can execute a
query
SELECT blah FROM foo WHERE IN ('mytext') ALLOW FILT
When I create a SASI index on a secondary column, from cqlsh I can execute
a query
SELECT blah FROM foo WHERE IN ('mytext') ALLOW FILTERING;
but not from the java driver:
SELECT blah FROM foo WHERE IN :val ALLOW FILTERING
Here I get an exception
15 matches
Mail list logo
