Create an account

Very important

  • To access the important data of the forums, you must be active in each forum and especially in the leaks and database leaks section, send data and after sending the data and activity, data and important content will be opened and visible for you.
  • You will only see chat messages from people who are at or below your level.
  • More than 500,000 database leaks and millions of account leaks are waiting for you, so access and view with more activity.
  • Many important data are inactive and inaccessible for you, so open them with activity. (This will be done automatically)

0Day Forums Coding Database Cassandra Cassandra querying on a part of a key

Thread Rating:
  • 383 Vote(s) - 3.53 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Options
Cassandra querying on a part of a key

Offline phonotypic810944


Valued member
***
Valued member
Posts: 1
Threads: 1
Joined: Feb 2023
Reputation: 0
Level: 1 [Level]
Total Points: 0
Rank 0 / 1
99% to upload Level
Rank
Activity 0 / 1
99% to upload your Rank
Activity
Experience 1
99% to upload Experience
Experience

Points: 50
#1
07-30-2023, 02:14 PM
I have a cassandra column family which has a row key like
2012-09-30-05-42-00:30:5856869

I need to query some thing like

select * from cf where key like %5856869%

Currently I am using Astyanax , is same possible in astyanax. If not, which implementation would support it.
Reply

Offline conceive746462


Member
*
Member
Posts: 0
Threads: 0
Joined: May 2020
Reputation: 0
Level: inf [Level]
Total Points: inf
Rank nan / 1
100% to upload Level
Rank
Activity inf / 1
99% to upload your Rank
Activity
Experience nan
100% to upload Experience
Experience

Points: 50
#2
07-30-2023, 02:22 PM
LIKE queries are not supported in Cassandra. If you want to query based on part of a key, you'll want to use composite keys. But in this specific case, the 5856869 portion of the key would have to be the first part for you to do what you want. Remember that with Cassandra, you must write your data the way you expect to read it.
Reply

Offline samualwrex


Member
*
Member
Posts: 0
Threads: 0
Joined: May 2020
Reputation: 0
Level: inf [Level]
Total Points: inf
Rank nan / 1
100% to upload Level
Rank
Activity inf / 1
99% to upload your Rank
Activity
Experience nan
100% to upload Experience
Experience

Points: 50
#3
07-30-2023, 02:22 PM
None.... you need to write index manually - this is how you handle such things in Cassandra, or you might try full text search:

[To see links please register here]

Reply

« Next Oldest
Next Newest »


Forum Jump:


Users browsing this thread:
1 Guest(s)

©0Day  2016 - 2023 | All Rights Reserved.  Made with    for the community. Connected through