October 2014 - users-list

error documentation ALTER USER
by Pierre-Adrien Coustillas 03 Oct '14

03 Oct '14

Hello, There is an error on this page : https://www.monetdb.org/Documentation/SQLreference/Authorisation It's not UNENCRYPYED but UNENCRYPTED sql>ALTER USER SET UNENCRYPYED PASSWORD 'azerty' USING OLD PASSWORD 'monetdb'; syntax error, unexpected IDENT, expecting PASSWORD in: "alter user set unencrypyed" sql>ALTER USER SET UNENCRYPTED PASSWORD 'azerty' USING OLD PASSWORD 'monetdb'; operation successful (19.015ms) Pierre -- 1G6 52 route de bischwiller 67300 Schiltigheim Société de Services et de Formations en Logiciels Libres http://1g6.biz Tél : 06 64 63 70 35

2 1

MonetDB bulk load error
by Frik Lubbe 02 Oct '14

02 Oct '14

Hi all, I'm new to MonetDB and ran into a bulk load error. I have a delimited file to be loaded. Column Delimiter : '~' Quote Char : ' " ' (double quote) Row Delimiter: '\n' My load script is this: sql>COPY 1000 RECORDS INTO voc.dim_anonymous_wallets FROM '/tmp/monetdb/201409_BA_ANON_WALLETS.SML' USING DELIMITERS '\~','\\n','\"' NULL AS ''; Error: Incomplete record at end of file. failed to import table This file loads OK in other db engines. Any ideas will help please. Regards, Frik

2 1

Bulk Load error
by Frik Lubbe 02 Oct '14

02 Oct '14

Hi all, I'm new to MonetDB and ran into a bulk load error. I have a delimited file to be loaded. Column Delimiter : '~' Quote Char : ' " ' (double quote) Row Delimiter: '\n' My load script is this: sql>COPY 1000 RECORDS INTO voc.dim_anonymous_wallets FROM '/tmp/monetdb/201409_BA_ANON_WALLETS.SML' USING DELIMITERS '\~','\\n','\"' NULL AS ''; Error: Incomplete record at end of file. failed to import table This file loads OK in other db engines. Any ideas will help please. Regards, Frik

2 1