Re: Copy into with DEFAULT values

24 Jul 2017

      Hai Ariel,

Allowing omitted columns in CSV files was added later, so the documentation for that is not yet published.
The syntax is:

COPY … INTO table_name (dest_col1, dest_col2, dest_col3, …) FROM <file> (src_col3, src_col1, src_col2) …

Note from the above syntax that the columns in the CSV file don’t have to be in the same order of the columns in the table.

I tried the following example (using Jul2017):

$ cat cars.csv 
Ford,E350
Mercury,Cougar

$ mclient 
…
sql>create table cars (y string, make string, model string);
operation successful (4.622ms)
sql>copy into cars(model, make) from '/Users/jennie/cars.csv' (make, model)  delimiters ',','\n';
2 affected rows (49.872ms)
sql>select * from cars;
+------+---------+--------+
| y    | make    | model  |
+======+=========+========+
| null | Ford    | E350   |
| null | Mercury | Cougar |
+------+---------+--------+
2 tuples (2.523ms)
sql>copy into cars(model, make) from '/Users/jennie/cars.csv' (model, make)  delimiters ',','\n';
2 affected rows (49.438ms)
sql>select * from cars;
+------+---------+---------+
| y    | make    | model   |
+======+=========+=========+
| null | Ford    | E350    |
| null | Mercury | Cougar  |
| null | E350    | Ford    |
| null | Cougar  | Mercury |
+------+---------+---------+
4 tuples (4.323ms)

Hope it works for you

Regards,
Jennie
...
On 21 Jul 2017, at 19:20, Ariel Abadi  wrote:
Hi
Im trying to upload a FILE into one table. The FILE has all the fields of the table, except for the last field which is the updated time.
For that reason I have created the table with the field:
"nrm_now"     TIMESTAMP(0)  DEFAULT current_timestamp()
BUT when im trying to insert the FILE (COY INTO test_20170711 from FILE .... ), there is an error:
Failed to import table 'test_20170711', Column value 143 missing
Does anybody can help me? Am I doing something wrong?  Which should be the best way to implement this?
Thnks in advance
Ariel
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list

Re: Copy into with DEFAULT values

Ying Zhang