Using COPY .. TO you can export using the DELIMITER option, does that help?
> On Aug 15, 2017, at 9:01 PM, Harikrishnan A wrote:
>
> Thank you all
>
> Regards,
> Hari
>
>
> On Tuesday, August 15, 2017 12:55 AM, Erick Ramirez
> wrote:
>
>
> +1 to Jim and Tobin. cqlsh wasn't designed for w
Thank you all
Regards,Hari
On Tuesday, August 15, 2017 12:55 AM, Erick Ramirez
wrote:
+1 to Jim and Tobin. cqlsh wasn't designed for what you're trying to achieve.
Cheers!
On Tue, Aug 15, 2017 at 1:34 AM, Tobin Landricombe wrote:
Can't change the delimiter (I'm on cqlsh 5.0.1). Best
+1 to Jim and Tobin. cqlsh wasn't designed for what you're trying to
achieve. Cheers!
On Tue, Aug 15, 2017 at 1:34 AM, Tobin Landricombe
wrote:
> Can't change the delimiter (I'm on cqlsh 5.0.1). Best I can offer is
> https://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlshExpand.html
>
> > O
Can't change the delimiter (I'm on cqlsh 5.0.1). Best I can offer is
https://docs.datastax.com/en/cql/3.3/cql/cql_reference/cqlshExpand.html
> On 14 Aug 2017, at 16:17, Jim Witschey wrote:
>
> Not knowing the problem you're trying to solve, I'm going to guess
> cqlsh is a bad tool for this job.
Not knowing the problem you're trying to solve, I'm going to guess
cqlsh is a bad tool for this job. If you want to put the results of
CQL queries into a shell pipeline, a small custom script using a
driver is probably a better fit, and should be possible to write
without much effort.
I have column values with Pipe separator, hence unable to replace this default
delimiter from the output.
Thanks Hari
On Monday, August 14, 2017 12:12 AM, algermissen1971
wrote:
On 14.08.2017, at 07:49, Harikrishnan A wrote:
Hello,
When I execute cqlsh -e "SELECT statement .." ,
> On 14.08.2017, at 07:49, Harikrishnan A wrote:
>
> Hello,
>
> When I execute cqlsh -e "SELECT statement .." , it gives the output with a
> pipe ('|') separator. Is there anyway I can change this default delimiter in
> the output of cqlsh -e " SELECT statement ..".
What about sed?
Jan
Hello,
When I execute cqlsh -e "SELECT statement .." , it gives the output with a
pipe ('|') separator. Is there anyway I can change this default delimiter in
the output of cqlsh -e " SELECT statement ..".
Thanks & Regards,Hari
