Re: failed to open file when 'copy binary into table from binaryformfile'

from http://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/BinaryBulkLoad " Each attachment file is produced by a program that writes the binary image of the BAT directly, i.e. a binary dump of an C-array. For the SQL types char (1 byte), tinyint (8-bits), smallint (16-bits), int/integer (32 bits), and bigint (64 bits) correspond with the C types directly; real and double are mapped onto type float and double in C, respectively. " i.e., your data source write a respective C array to a file. Stefan ----- Original Message -----

then when i want to COPY BINARY INTO table, how to write to float into a file in the binary form first?

2013/7/17 Stefan Manegold

...

No, MonetDB currently does not support binary copy into file. You might want to file a feature request for this via http://bugs.monetdb.org/

Stefan

----- Original Message -----

...

Thanks very much, it works!

Still i want to know can i use COPY INTO FILE like "copy select * from sys.testtable into '/home/data1/file2'; " to copy into file in a binary form? because i want to use COPY BINARY INTO tablename, but i dont know how to write the result set of float and double binary into a file first.

Meng

2013/7/17 Stefan Manegold

...

Indeed. Thanks! Fixed.

----- Original Message -----

...

On 17.07.2013, at 08:04, Stefan Manegold wrote:

...

They should reside on the same file system as the database farm" This one is actually a "must".

Best

Hannes

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org http://mail.monetdb.org/mailman/listinfo/users-list

-- | Stefan.Manegold@CWI.nl | DB Architectures (DA) | | www.CWI.nl/~manegold/ | Science Park 123 (L321) | | +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |