October 2014 - users-list

MonetDB and clout-backup
by Thomas Yokota 07 Oct '14

07 Oct '14

Hi, I am interested in using MonetDB in my workflow. Currently, I am using SQLite. One reason is that I can store the db one a separate file in my dropbox dir, which allows me to work from multiple computers rather than relying on a VMware-type solution. Can MonetDB give me the same flexibility? If so, is it simply saving the DB into a dir nested within Dropbox dir? Thank you, Thomas

1 0

Can not drop the view
by Radovan Bičiště 06 Oct '14

06 Oct '14

Hello, I'm wondering if there is some hard core way to drop a view. Somehow I have three views that I'm not able to drop. I can issue drop statement several times and it returns success. Here is log from mclient: ceos@lux-drmax-ana:/u01/ceosdata/database/monetdb/drmax/crm$ mclient -d zkdev1 -u drmaxtst password: Welcome to mclient, the MonetDB/SQL interactive terminal (Jan2014-SP2) Database: MonetDB v11.17.17 (Jan2014-SP2), 'mapi:monetdb://lux-drmax-ana:50000/zkdev1' Type \q to quit, \? for a list of available commands auto commit mode: on sql>\dv VIEW drmaxtst.all_constraints VIEW drmaxtst.all_tab_columns VIEW drmaxtst.mmtest_v VIEW drmaxtst.pohyby_prodeje_v VIEW drmaxtst.prijmy_2012_v_mr_tmp VIEW drmaxtst.prijmy_v VIEW drmaxtst.prodeje_2011_v VIEW drmaxtst.prodeje_2012_v VIEW drmaxtst.prodeje_2012_v_mr_tmp VIEW drmaxtst.prodeje_2013_v VIEW drmaxtst.prodeje_2014_v VIEW drmaxtst.prodeje_v VIEW drmaxtst.stav_skladu_historie sql>drop view drmaxtst.prodeje_v; operation successful (3.168ms) sql>drop view drmaxtst.prodeje_v; operation successful (3.004ms) sql>drop view drmaxtst.prodeje_v; operation successful (7.501ms) sql>drop view drmaxtst.prodeje_v; operation successful (4.154ms) sql>drop view drmaxtst.prodeje_v; operation successful (2.351ms) sql>drop view drmaxtst.prodeje_v; operation successful (2.410ms) sql>drop view drmaxtst.prodeje_v; operation successful (2.355ms) sql>drop view drmaxtst.prodeje_v; operation successful (2.685ms) sql>drop view drmaxtst.prodeje_v; operation successful (2.646ms) sql>drop view drmaxtst.prodeje_v; operation successful (2.695ms) sql>drop view drmaxtst.prodeje_v; operation successful (2.390ms) sql>drop view drmaxtst.prodeje_v; operation successful (2.399ms) sql>drop view drmaxtst.prodeje_v; DROP VIEW: unknown view 'prodeje_v' sql>drop view drmaxtst.prodeje_v; DROP VIEW: unknown view 'prodeje_v' sql>\dv VIEW drmaxtst.all_constraints VIEW drmaxtst.all_tab_columns VIEW drmaxtst.mmtest_v VIEW drmaxtst.pohyby_prodeje_v VIEW drmaxtst.prijmy_2012_v_mr_tmp VIEW drmaxtst.prijmy_v VIEW drmaxtst.prodeje_2011_v VIEW drmaxtst.prodeje_2012_v VIEW drmaxtst.prodeje_2012_v_mr_tmp VIEW drmaxtst.prodeje_2013_v VIEW drmaxtst.prodeje_2014_v VIEW drmaxtst.prodeje_v VIEW drmaxtst.stav_skladu_historie sql> I guess my only option is to dump a reload the database. :( Radovan

5 11

any tips to COPY INTO from a csv with whitespace around some DOUBLE fields?
by Anthony Damico 03 Oct '14

03 Oct '14

here's the problem-- Unable to execute statement 'COPY 2626675 OFFSET 2 RECORDS INTO OPPR_ALL_DTL_GNRL_09302014 FROM 'C:\Users\anthonyd\AppData\Local\...'. Server says '!value '1 ' from line 1 field 51 not inserted, expecting type double'. i could import it as VARCHAR and then CAST it back into a DOUBLE type, but i'm wondering if anyone has an easier/more clever way to import this? handling it manually would mean that i cannot use the monet.read.csv() function, so it's a bit more work. thanks!

2 2

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