Re: Must the file be deleted after "copy binary into table from file"?

Ying Zhang Y.Zhang at cwi.nl
Fri Jul 19 14:04:19 CEST 2013


To not forget this info.

> 1) The actual behavior (move) is actually different than the copy that the documentation at http://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/BinaryBulkLoad suggests. We need to fix the latter.

Added a bug report for documentaion:
Bug 3325 - BinaryBulkLoad documentation mismatches implementation
http://bugs.monetdb.org/show_bug.cgi?id=3325

> 
> 
> 2) The actual behavior currently differs between data types; for numerical types, the user-provided files are moved as explained above; for stings, the files are read and processed, i.e., the used-provided file remains in place as-is. We need to consider unifying this behavior, e.g., by deleting also the user provided files for strings once they have been processed/loaded.

Added a feature request:
Bug 3326 - consistent behaviour of BinaryBulkLoad
http://bugs.monetdb.org/show_bug.cgi?id=3326

> 
> 3) In case the copy into file, e.g., due to a failing sanity check after the file is moved, that data is factually lost, i.e., the files are gone, but no data is loaded into the database; we need to either document this clearly, or make the implementation behave like a transaction.

Added a feature request:
Bug 3327 - Transactional behaviour of BinaryBulkLoad 
http://bugs.monetdb.org/show_bug.cgi?id=3327

Jennie

> 
> 
> 
> ----- Original Message -----
>> can i have the file reserved?
>> 
>> 
>> 
>> Thanks
>> Meng
>> _______________________________________________
>> users-list mailing list
>> users-list at monetdb.org
>> http://mail.monetdb.org/mailman/listinfo/users-list
>> 
> 
> -- 
> | Stefan.Manegold at CWI.nl | DB Architectures   (DA) |
> | www.CWI.nl/~manegold/  | Science Park 123 (L321) |
> | +31 (0)20 592-4212     | 1098 XG Amsterdam  (NL) |
> 




More information about the users-list mailing list