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

Stefan Manegold Stefan.Manegold at cwi.nl
Wed Jul 17 11:12:53 CEST 2013


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 <Stefan.Manegold at cwi.nl>
> 
> > 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 <Stefan.Manegold at cwi.nl>
> > >
> > > > Indeed. Thanks! Fixed.
> > > >
> > > > ----- Original Message -----
> > > > >
> > > > > On 17.07.2013, at 08:04, Stefan Manegold
> > > > > <Stefan.Manegold at cwi.nl>
> > > > > 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 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) |
> > > >
> > > > _______________________________________________
> > > > users-list mailing list
> > > > users-list at monetdb.org
> > > > http://mail.monetdb.org/mailman/listinfo/users-list
> > > >
> > >
> > > _______________________________________________
> > > 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) |
> >
> > _______________________________________________
> > users-list mailing list
> > users-list at monetdb.org
> > http://mail.monetdb.org/mailman/listinfo/users-list
> >
> 
> _______________________________________________
> 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