[MonetDB-users] Can't create a csv vault?
Hi all, I'm very interested in the vault feature of monetdb, both for csv and for creating my own formats. Trouble is I can't make a simple example work. I've flattended the voc sample data into a csv file, and then try to load it so: create table test (type varchar(255), number integer, number_sup varchar(255), trip integer, trip_sup varchar(255), onboard_at_departure integer, death_at_cap integer, left_at_cape integer, onboard_at_cape integer, death_during_voyage integer, onboard_at_arrival integer) external csv '/tmp/all.csv'; But I get an error: syntax error, unexpected EXTERNAL, expecting SCOLON in: ... Do I need to enable vaults at configure time or create time or something? I didn't see an option for it. I built from the "Latest" tarball on OSX Lion. Cheers, Mark.
Hi Mark, thanks for you interest in MonetDB and it's data vault features. However, the data vault feature are still under development and far from production-ready. They are not yet included in the Aug2011 release, and it is not yet clear, whether and if so to which extend they will be included in the upcoming Dec2011 release. Assuming this "recipe" on the MonetDB website tough you about the CSV vault feature, I'm afraid this recipe has been published prematurely. Sorry! We will hide it, again, until the CSV- and other vault feature are indeed included in the release. For now, please use the standard bulk load via copy into, cf., http://www.monetdb.org/Documentation/Manuals/SQLreference/CopyInto Stefan On Thu, Dec 08, 2011 at 04:48:01PM +1100, Mark Aufflick wrote:
Hi all,
I'm very interested in the vault feature of monetdb, both for csv and for creating my own formats. Trouble is I can't make a simple example work. I've flattended the voc sample data into a csv file, and then try to load it so:
create table test (type varchar(255), number integer, number_sup varchar(255), trip integer, trip_sup varchar(255), onboard_at_departure integer, death_at_cap integer, left_at_cape integer, onboard_at_cape integer, death_during_voyage integer, onboard_at_arrival integer) external csv '/tmp/all.csv';
But I get an error:
syntax error, unexpected EXTERNAL, expecting SCOLON in: ...
Do I need to enable vaults at configure time or create time or something? I didn't see an option for it. I built from the "Latest" tarball on OSX Lion.
Cheers,
Mark.
------------------------------------------------------------------------------ Cloud Services Checklist: Pricing and Packaging Optimization This white paper is intended to serve as a reference, checklist and point of discussion for anyone considering optimizing the pricing and packaging model of a cloud services business. Read Now! http://www.accelacomm.com/jaw/sfnl/114/51491232/
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
Hi Stefan,
Thanks for the clarification. I'm doing research which wouldn't go
production for some time, so I'd like to play with it. Is there a
repository I can check out?
Mark.
On Thu, Dec 8, 2011 at 6:43 PM, Stefan Manegold
Hi Mark,
thanks for you interest in MonetDB and it's data vault features.
However, the data vault feature are still under development and far from production-ready. They are not yet included in the Aug2011 release, and it is not yet clear, whether and if so to which extend they will be included in the upcoming Dec2011 release.
Assuming this "recipe" on the MonetDB website tough you about the CSV vault feature, I'm afraid this recipe has been published prematurely. Sorry! We will hide it, again, until the CSV- and other vault feature are indeed included in the release.
For now, please use the standard bulk load via copy into, cf.,
http://www.monetdb.org/Documentation/Manuals/SQLreference/CopyInto
Stefan
On Thu, Dec 08, 2011 at 04:48:01PM +1100, Mark Aufflick wrote:
Hi all,
I'm very interested in the vault feature of monetdb, both for csv and for creating my own formats. Trouble is I can't make a simple example work. I've flattended the voc sample data into a csv file, and then try to load it so:
create table test (type varchar(255), number integer, number_sup varchar(255), trip integer, trip_sup varchar(255), onboard_at_departure integer, death_at_cap integer, left_at_cape integer, onboard_at_cape integer, death_during_voyage integer, onboard_at_arrival integer) external csv '/tmp/all.csv';
But I get an error:
syntax error, unexpected EXTERNAL, expecting SCOLON in: ...
Do I need to enable vaults at configure time or create time or something? I didn't see an option for it. I built from the "Latest" tarball on OSX Lion.
Cheers,
Mark.
Cloud Services Checklist: Pricing and Packaging Optimization This white paper is intended to serve as a reference, checklist and
------------------------------------------------------------------------------ point of
discussion for anyone considering optimizing the pricing and packaging model of a cloud services business. Read Now! http://www.accelacomm.com/jaw/sfnl/114/51491232/
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
------------------------------------------------------------------------------ Cloud Services Checklist: Pricing and Packaging Optimization This white paper is intended to serve as a reference, checklist and point of discussion for anyone considering optimizing the pricing and packaging model of a cloud services business. Read Now! http://www.accelacomm.com/jaw/sfnl/114/51491232/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
Hi Mark, yes, as mentioned on the MonetDB web side, MonetDB source are available from the MonetDB Mercurial (HG) repository; the "HG web" link in the naviation menu on the left gets you to http://dev.monetdb.org/hg/MonetDB/graph/ I must confess, though, that I am not up-to-date with the current status of the vault implementation, let alone it's documentation. Maybe the involved developers can shed some light on this... Stefan On Thu, Dec 08, 2011 at 08:55:53PM +1100, Mark Aufflick wrote:
Hi Stefan,
Thanks for the clarification. I'm doing research which wouldn't go production for some time, so I'd like to play with it. Is there a repository I can check out?
Mark.
On Thu, Dec 8, 2011 at 6:43 PM, Stefan Manegold
wrote: Hi Mark,
thanks for you interest in MonetDB and it's data vault features.
However, the data vault feature are still under development and far from production-ready. They are not yet included in the Aug2011 release, and it is not yet clear, whether and if so to which extend they will be included in the upcoming Dec2011 release.
Assuming this "recipe" on the MonetDB website tough you about the CSV vault feature, I'm afraid this recipe has been published prematurely. Sorry! We will hide it, again, until the CSV- and other vault feature are indeed included in the release.
For now, please use the standard bulk load via copy into, cf.,
http://www.monetdb.org/Documentation/Manuals/SQLreference/CopyInto
Stefan
On Thu, Dec 08, 2011 at 04:48:01PM +1100, Mark Aufflick wrote:
Hi all,
I'm very interested in the vault feature of monetdb, both for csv and for creating my own formats. Trouble is I can't make a simple example work. I've flattended the voc sample data into a csv file, and then try to load it so:
create table test (type varchar(255), number integer, number_sup varchar(255), trip integer, trip_sup varchar(255), onboard_at_departure integer, death_at_cap integer, left_at_cape integer, onboard_at_cape integer, death_during_voyage integer, onboard_at_arrival integer) external csv '/tmp/all.csv';
But I get an error:
syntax error, unexpected EXTERNAL, expecting SCOLON in: ...
Do I need to enable vaults at configure time or create time or something? I didn't see an option for it. I built from the "Latest" tarball on OSX Lion.
Cheers,
Mark.
Cloud Services Checklist: Pricing and Packaging Optimization This white paper is intended to serve as a reference, checklist and
------------------------------------------------------------------------------ point of
discussion for anyone considering optimizing the pricing and packaging model of a cloud services business. Read Now! http://www.accelacomm.com/jaw/sfnl/114/51491232/
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
------------------------------------------------------------------------------ Cloud Services Checklist: Pricing and Packaging Optimization This white paper is intended to serve as a reference, checklist and point of discussion for anyone considering optimizing the pricing and packaging model of a cloud services business. Read Now! http://www.accelacomm.com/jaw/sfnl/114/51491232/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------ Cloud Services Checklist: Pricing and Packaging Optimization This white paper is intended to serve as a reference, checklist and point of discussion for anyone considering optimizing the pricing and packaging model of a cloud services business. Read Now! http://www.accelacomm.com/jaw/sfnl/114/51491232/
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |
participants (2)
-
Mark Aufflick
-
Stefan Manegold