Import Data Failure using COPY CLI

[tyuengithub]

Hi,
I’m using CLI “copy” to import data, but getting the below error

Command
cqlsh ybyte-server01 -e "copy matchingstage.strongkeyNewTestV2 FROM ‘matchingstage.strongkey.20220907.csv’ with delimiter=‘|’ and header=true and NUMPROCESSES=2 AND INGESTRATE=25000 "

Error Message:
:1:Failed to import 20 rows: ServerError - Transaction expired or aborted by a conflict: 40001 (pgsql error 40001) (transaction error 1), will retry later, attempt 1 of 5
:1:Failed to import 20 rows: ServerError - Transaction expired or aborted by a conflict: 40001 (pgsql error 40001) (transaction error 1), will retry later, attempt 1 of 5

[dorian_yugabyte]

@tyuengithub can you try with our fork ycqlsh ycqlsh - YCQL shell for YugabyteDB | YugabyteDB Docs ?

[tyuengithub]

Hi Dorian,

I don’t have access to server and my laptop’s OS is Window. Hence, I don’t have the yugabyte install where I can fork ycqlsh.

Regards,
Tommy

[dorian_yugabyte]

@tyuengithub

I don’t have access to server and my laptop’s OS is Window. Hence, I don’t have the yugabyte install where I can fork ycqlsh.

Please install yugabyte and try it with ycqlsh.