Retrieve rows using multiple clustering columns in cassandra java IN query failing
I need to do similer query from spring-java application in Cassandra.
See the query below
SELECT * FROM cycling.calendar WHERE race_id IN (100, 101, 102) AND (race_start_date, race_end_date) IN (('2015-05-09','2015-05-31'),('2015-05-06', '2015-05-31'));
See here
Retrieve rows using multiple clustering columns
I am using spring-data-cassandra repository abstruction(@Repositiry, @Query etc)
race_start_date, race_end_date is part of clustering key, and I can not use it as used defined type.
I tried to pass list of (race_start_date, race_end_date) but it failed.
List
Error shows as Arraylist does not corrospond to any CQL3 data type.
Help appreciated
java cassandra spring-data-cassandra
asked Nov 21 '18 at 1:11
barunbarun
186114
add a comment |
I need to do similer query from spring-java application in Cassandra.
See the query below
SELECT * FROM cycling.calendar WHERE race_id IN (100, 101, 102) AND (race_start_date, race_end_date) IN (('2015-05-09','2015-05-31'),('2015-05-06', '2015-05-31'));
See here
Retrieve rows using multiple clustering columns
I am using spring-data-cassandra repository abstruction(@Repositiry, @Query etc)
race_start_date, race_end_date is part of clustering key, and I can not use it as used defined type.
I tried to pass list of (race_start_date, race_end_date) but it failed.
List
Error shows as Arraylist does not corrospond to any CQL3 data type.
Help appreciated
java cassandra spring-data-cassandra
asked Nov 21 '18 at 1:11
barunbarun
186114
It works in cqlshell for me. BTW, What version of Cassandra do you have.
– Praneeth Gudumasu
Nov 22 '18 at 4:42
add a comment |
I need to do similer query from spring-java application in Cassandra.
See the query below
SELECT * FROM cycling.calendar WHERE race_id IN (100, 101, 102) AND (race_start_date, race_end_date) IN (('2015-05-09','2015-05-31'),('2015-05-06', '2015-05-31'));
See here
Retrieve rows using multiple clustering columns
I am using spring-data-cassandra repository abstruction(@Repositiry, @Query etc)
race_start_date, race_end_date is part of clustering key, and I can not use it as used defined type.
I tried to pass list of (race_start_date, race_end_date) but it failed.
List
Error shows as Arraylist does not corrospond to any CQL3 data type.
Help appreciated
java cassandra spring-data-cassandra
asked Nov 21 '18 at 1:11
barunbarun
186114
I need to do similer query from spring-java application in Cassandra.
See the query below
SELECT * FROM cycling.calendar WHERE race_id IN (100, 101, 102) AND (race_start_date, race_end_date) IN (('2015-05-09','2015-05-31'),('2015-05-06', '2015-05-31'));
See here
Retrieve rows using multiple clustering columns
I am using spring-data-cassandra repository abstruction(@Repositiry, @Query etc)
race_start_date, race_end_date is part of clustering key, and I can not use it as used defined type.
I tried to pass list of (race_start_date, race_end_date) but it failed.
List
Error shows as Arraylist does not corrospond to any CQL3 data type.
Help appreciated
java cassandra spring-data-cassandra
java cassandra spring-data-cassandra
asked Nov 21 '18 at 1:11
barunbarun
186114
asked Nov 21 '18 at 1:11
barunbarun
186114
asked Nov 21 '18 at 1:11
barunbarun
186114
asked Nov 21 '18 at 1:11
barunbarun
186114
asked Nov 21 '18 at 1:11
barunbarun
186114
186114
It works in cqlshell for me. BTW, What version of Cassandra do you have.
– Praneeth Gudumasu
Nov 22 '18 at 4:42
add a comment |
It works in cqlshell for me. BTW, What version of Cassandra do you have.
– Praneeth Gudumasu
Nov 22 '18 at 4:42
It works in cqlshell for me. BTW, What version of Cassandra do you have.
– Praneeth Gudumasu
Nov 22 '18 at 4:42
It works in cqlshell for me. BTW, What version of Cassandra do you have.
– Praneeth Gudumasu
Nov 22 '18 at 4:42
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53403934%2fretrieve-rows-using-multiple-clustering-columns-in-cassandra-java-in-query-faili%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53403934%2fretrieve-rows-using-multiple-clustering-columns-in-cassandra-java-in-query-faili%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
It works in cqlshell for me. BTW, What version of Cassandra do you have.
– Praneeth Gudumasu
Nov 22 '18 at 4:42