No Rows Are Imported When Using COPY FROM gzip File

CrateDB SQL
1

Hi

I’m trying to load data from a gzip file using the COPY FROM command.

My file has 1 header row and is in gzip format.

When I run the command I get no errors, it says it has imported 1276 records, but when I query the table there are no records imported?

Any ideas ?

The command I used is attached.

Regards

Mark

COPY FROM gzip Issue
COPY FROM gzip Issue1358×253 9.91 KB

2

Hi Mark,

Are you using the latest version?
Would you be willing to share the schema (SHOW CREATE table mm.bm0000002) and an example .csv so that I could test it locally? (If you don’t want to share it here, you can send it by mail to georg@crate.io)

best regards
Georg

3

refresh_interval was set 0 (i.e. the table isn’t refreshed automatically).

To enable automatic table refresh use:

ALTER TABLE mm.bm0000002 SET (refresh_interval = 1000);