You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Often, we know that a CSV file has a header, but we do not want to specify the number of rows to be imported. However, the COPY INTO command currently does only allow OFFSET 2 (to skip the header) to be specified when n RECORDS is also present. This makes little sense and should be fixed.
So,
COPY [ int_val [ OFFSET int_val ] RECORDS ] INTO table_name
FROM ( file_name ',' ... | STDIN )
[ [USING] DELIMITERS field_separator [',' record_separator [ ',' string_quote ]]] [ NULL AS null_string ] [LOCKED]
should be
COPY [ int_val RECORDS ] [ OFFSET int_val ] INTO table_name
FROM ( file_name ',' ... | STDIN )
[ [USING] DELIMITERS field_separator [',' record_separator [ ',' string_quote ]]] [ NULL AS null_string ] [LOCKED]
Date: 2014-06-25 16:16:56 +0200
From: @hannesmuehleisen
To: SQL devs <>
Version: -- development
CC: @njnes
Last updated: 2014-10-31 14:14:51 +0100
Comment 19856
Date: 2014-06-25 16:16:56 +0200
From: @hannesmuehleisen
Often, we know that a CSV file has a header, but we do not want to specify the number of rows to be imported. However, the COPY INTO command currently does only allow OFFSET 2 (to skip the header) to be specified when n RECORDS is also present. This makes little sense and should be fixed.
So,
COPY [ int_val [ OFFSET int_val ] RECORDS ] INTO table_name
FROM ( file_name ',' ... | STDIN )
[ [USING] DELIMITERS field_separator [',' record_separator [ ',' string_quote ]]] [ NULL AS null_string ] [LOCKED]
should be
COPY [ int_val RECORDS ] [ OFFSET int_val ] INTO table_name
FROM ( file_name ',' ... | STDIN )
[ [USING] DELIMITERS field_separator [',' record_separator [ ',' string_quote ]]] [ NULL AS null_string ] [LOCKED]
Comment 19893
Date: 2014-07-09 15:46:27 +0200
From: MonetDB Mercurial Repository <>
Changeset 08f2048691fb made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.
For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=08f2048691fb
Changeset description:
Comment 19983
Date: 2014-08-06 19:08:28 +0200
From: @njnes
fixed
Comment 20393
Date: 2014-10-31 14:14:51 +0100
From: @sjoerdmullender
Oct2014 has been released.
The text was updated successfully, but these errors were encountered: