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 Bulk Export of Cassandra column family to CSV

Thread Rating:
  • 458 Vote(s) - 3.6 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Options
Bulk Export of Cassandra column family to CSV

Offline breedlove988


Member
*
Member
Posts: 1
Threads: 1
Joined: Dec 2018
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
How does one export a 50 GB column family from Cassandra to a CSV file? I have explored:

1.) Copy ... To - this results in an rpc_timeout

2.) Have cassandra output the results of a query directly to a text a file - results in rpc_timeout

I have manipulated the read and write request timeout values (restarting dse everytime) in the cassandra.yaml file with no success. How do you export this data to CSV?
Reply

Offline lamonicalamont550


Valued member
***
Valued member
Posts: 0
Threads: 0
Joined: Feb 2018
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:34 PM
Try Brian Hess's cassandra unloader. Its probably the most user friendly and performant tool out there.

[To see links please register here]


It might become part of the core project.

[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