You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@cassandra.apache.org by Arvinder Dhillon <dh...@gmail.com> on 2022/07/21 17:51:22 UTC

Export as csv

What tool do I use to dump a columns of a table having 40K partitions into
a csv file?
I tried caqsh with CAPTURE, it stuck after 100 rows and needs "enter" to
dump next 100, even with allow filtering.

Thanks,
Arvi

Re: Export as csv

Posted by Arvinder Dhillon <dh...@gmail.com>.

Yup, copy worked. Thanks.

On Thu, Jul 21, 2022 at 10:55 AM Nitan Kainth <ni...@gmail.com> wrote:

> Use copy command or dsbulk
>
>
>
>
>
> Regards,
>
> Nitan K.
>
> 510-449-9629
>
>
>
>
>
> *From: *Arvinder Dhillon <dh...@gmail.com>
> *Date: *Thursday, July 21, 2022 at 12:52 PM
> *To: *user@cassandra.apache.org <us...@cassandra.apache.org>
> *Subject: *Export as csv
>
> What tool do I use to dump a columns of a table having 40K partitions into
> a csv file?
>
> I tried caqsh with CAPTURE, it stuck after 100 rows and needs "enter" to
> dump next 100, even with allow filtering.
>
>
>
> Thanks,
>
> Arvi
>

Re: Export as csv

Posted by Nitan Kainth <ni...@gmail.com>.

Use copy command or dsbulk

Regards,
Nitan K.
510-449-9629

From: Arvinder Dhillon <dh...@gmail.com>
Date: Thursday, July 21, 2022 at 12:52 PM
To: user@cassandra.apache.org <us...@cassandra.apache.org>
Subject: Export as csv
What tool do I use to dump a columns of a table having 40K partitions into a csv file?
I tried caqsh with CAPTURE, it stuck after 100 rows and needs "enter" to dump next 100, even with allow filtering.

Thanks,
Arvi