Did you install the latest version, July2015-SP1 ? Is the database created by an earlier version of MonetDB? On 06/11/15 21:12, Lynn Carol Johnson wrote:

I installed the July2015 version from MonetDB-11.21.5-x86_64-Darwin-14-bin.tar.bz2

I run these commands with this output:

rs-btlcj34lt:machineLearningDB lcj34$ monetdbd start /Users/lcj34/development/mydbfarm rs-btlcj34lt:machineLearningDB lcj34$ mclient -u monetdb -d test1 password: Welcome to mclient, the MonetDB/SQL interactive terminal (Jul2015) Database: MonetDB v11.21.5 (Jul2015), 'mapi:monetdb://rs-btlcj34lt.maize.cornell.edu:50000/test1' Type \q to quit, \? for a list of available commands auto commit mode: on sql>set SCHEMA test1; auto commit mode: on sql>\d TABLE test1.annosites TABLE test1.fhundredvarchar TABLE test1.monetdbfhundredvarchar sql>call storagemodelinit(); SELECT: no such operator 'storagemodelinit' sql> sql> sql>call storagemodelinit(); SELECT: no such operator 'storagemodelinit' sql>

Was there something to do on startup that I missed?

Thanks - Lynn

On 11/6/15, 2:51 PM, "users-list on behalf of Martin Kersten" wrote:

...

Hi Lynn

What version of MonetDB are you using? Did you create database with an older version?

All operations are automatically included in the system catalog upon database creation or server update.

Running against the latest Jul2015-SP1 gives the following: sql>call storagemodelinit(); sql>update storagemodelinput set count = 1000000 where "table"='lineitem'; 19 affected rows (17.648ms) sql>update storagemodelinput set "distinct" = 1000 where "table"='lineitem' and "type"='varchar'; 1 affected row (17.512ms) sql>update storagemodelinput set "distinct" = 330000 where "table"='lineitem' and "column"='l_comment'; 1 affected row (22.412ms) sql>select * from storagemodel() where "table" = 'lineitem'; +--------+----------+---------------------------------------+---------+--- ------+------------+----------+---------+----------+--------+ | schema | table | column | type | count | columnsize | heapsize | hashes | imprints | sorted | +========+==========+=======================================+=========+=== ======+============+==========+=========+==========+========+ | sys | lineitem | l_orderkey | int | 1000000 | 4000000 | 0 | 8000000 | 120000 | true | | sys | lineitem | l_partkey | int | 1000000 | 4000000 | 0 | 8000000 | 120000 | false | | sys | lineitem | l_suppkey | int | 1000000 | 4000000 | 0 | 8000000 | 120000 | false | | sys | lineitem | l_linenumber | int | 1000000 | 4000000 | 0 | 0 | 120000 | false | | sys | lineitem | l_quantity | decimal | 1000000 | 8000000 | 0 | 0 | 120000 | false | | sys | lineitem | l_extendedprice | decimal | 1000000 | 8000000 | 0 | 0 | 120000 | false | | sys | lineitem | l_discount | decimal | 1000000 | 8000000 | 0 | 0 | 120000 | false | | sys | lineitem | l_tax | decimal | 1000000 | 8000000 | 0 | 0 | 120000 | false | | sys | lineitem | l_returnflag | char | 1000000 | 2000000 | 0 | 0 | 0 | false | | sys | lineitem | l_linestatus | char | 1000000 | 2000000 | 0 | 0 | 0 | false | | sys | lineitem | l_shipdate | date | 1000000 | 8000000 | 0 | 0 | 120000 | false | | sys | lineitem | l_commitdate | date | 1000000 | 8000000 | 0 | 0 | 120000 | false | | sys | lineitem | l_receiptdate | date | 1000000 | 8000000 | 0 | 0 | 120000 | false | | sys | lineitem | l_shipinstruct | char | 1000000 | 2000000 | 0 | 0 | 0 | false | | sys | lineitem | l_shipmode | char | 1000000 | 2000000 | 0 | 0 | 0 | false | | sys | lineitem | l_comment | varchar | 1000000 | 1000000 | 8920240 | 0 | 0 | false | | sys | lineitem | lineitem_l_orderkey_l_linenumber_pkey | oid | 1000000 | 8000000 | 0 | 0 | 0 | false | | sys | lineitem | lineitem_fk1 | oid | 1000000 | 8000000 | 0 | 0 | 0 | false | | sys | lineitem | lineitem_fk2 | oid | 1000000 | 8000000 | 0 | 0 | 0 | false | +--------+----------+---------------------------------------+---------+--- ------+------------+----------+---------+----------+--------+ 19 tuples (39.980ms)

On 06/11/15 19:09, Lynn Carol Johnson wrote:

...

Hi all -

I am new to monetdb. I am running on a MAC (OS X 10.9.5) I have installed monetdb, I have setup a dbfarm, created a couple of databases, and loaded tables. I would like to run some analysis on the amount of storage used for some of my tables. I have seen the description of autoloading scripts here: https://www.monetdb.org/book/export/html/242

And examples of running the storage() command here: https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/storage-model

But I get ³no such operator Œstoragemodlinit¹ when I try to execute ³call storagemodelinit()² . What command must be run to include the .sql extensions with the database? Is something run when we create the dbfarm? When we create the individual databases?

I can see the .sql extensions in my /usr/local/monetdb/lib/monetdb5/createdb folder on my MAC.

I¹d appreciate any pointers on how to set this up. Googling has not provided me with any answers.

Thanks - Lynn

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

I loaded the July 2015 SP1, then created a new db, and tried the command again (you can see from the “welcome to client” message that it is Jul2015-SP1). Still getting the same error: RS-BTLCJ34LT-2:development lcj34$ monetdb create testJuly15SP1 created database in maintenance mode: testJuly15SP1 RS-BTLCJ34LT-2:development lcj34$ monetdb release testJuly15SP1 taken database out of maintenance mode: testJuly15SP1 RS-BTLCJ34LT-2:development lcj34$ mclient -u monetdb -d testJuly15SP1 password: Welcome to mclient, the MonetDB/SQL interactive terminal (Jul2015-SP1) Database: MonetDB v11.21.11 (Jul2015-SP1), 'mapi:monetdb://RS-BTLCJ34LT-2.local:50000/testJuly15SP1' Type \q to quit, \? for a list of available commands auto commit mode: on sql>create SCHEMA sp1Test; operation successful (1.760ms) sql>set SCHEMA sp1Test; auto commit mode: on sql>CREATE TABLE tenFeatures (chrom int, pos int, f1 varchar(20), f2 varchar(20), f3 varchar(20), f4 varchar(20), f5 varchar(20), f6 varchar(20), f7 varchar(20), f8 varchar(20), f9 varchar(20), f10 varchar(20)); operation successful (2.229ms) sql>\d TABLE sp1test.tenfeatures sql>call storagemodelinit(); SELECT: no such operator 'storagemodelinit' sql> Lynn On 11/7/15, 7:23 AM, "users-list on behalf of Lynn Carol Johnson" wrote:

The data base was newly created with the July 2015 installation of Monetdb.

I’ll install SP1 - not sure that I have that - and try again.

On 11/6/15, 3:19 PM, "users-list on behalf of Martin Kersten" wrote:

...

Did you install the latest version, July2015-SP1 ? Is the database created by an earlier version of MonetDB?

On 06/11/15 21:12, Lynn Carol Johnson wrote:

...

I installed the July2015 version from MonetDB-11.21.5-x86_64-Darwin-14-bin.tar.bz2

I run these commands with this output:

rs-btlcj34lt:machineLearningDB lcj34$ monetdbd start /Users/lcj34/development/mydbfarm rs-btlcj34lt:machineLearningDB lcj34$ mclient -u monetdb -d test1 password: Welcome to mclient, the MonetDB/SQL interactive terminal (Jul2015) Database: MonetDB v11.21.5 (Jul2015), 'mapi:monetdb://rs-btlcj34lt.maize.cornell.edu:50000/test1' Type \q to quit, \? for a list of available commands auto commit mode: on sql>set SCHEMA test1; auto commit mode: on sql>\d TABLE test1.annosites TABLE test1.fhundredvarchar TABLE test1.monetdbfhundredvarchar sql>call storagemodelinit(); SELECT: no such operator 'storagemodelinit' sql> sql> sql>call storagemodelinit(); SELECT: no such operator 'storagemodelinit' sql>

Was there something to do on startup that I missed?

Thanks - Lynn

On 11/6/15, 2:51 PM, "users-list on behalf of Martin Kersten" wrote:

...

Hi Lynn

What version of MonetDB are you using? Did you create database with an older version?

All operations are automatically included in the system catalog upon database creation or server update.

Running against the latest Jul2015-SP1 gives the following: sql>call storagemodelinit(); sql>update storagemodelinput set count = 1000000 where "table"='lineitem'; 19 affected rows (17.648ms) sql>update storagemodelinput set "distinct" = 1000 where "table"='lineitem' and "type"='varchar'; 1 affected row (17.512ms) sql>update storagemodelinput set "distinct" = 330000 where "table"='lineitem' and "column"='l_comment'; 1 affected row (22.412ms) sql>select * from storagemodel() where "table" = 'lineitem';

+--------+----------+---------------------------------------+---------+ - -- ------+------------+----------+---------+----------+--------+ | schema | table | column | type | count | columnsize | heapsize | hashes | imprints | sorted |

+========+==========+=======================================+=========+ = == ======+============+==========+=========+==========+========+ | sys | lineitem | l_orderkey | int | 1000000 | 4000000 | 0 | 8000000 | 120000 | true | | sys | lineitem | l_partkey | int | 1000000 | 4000000 | 0 | 8000000 | 120000 | false | | sys | lineitem | l_suppkey | int | 1000000 | 4000000 | 0 | 8000000 | 120000 | false | | sys | lineitem | l_linenumber | int | 1000000 | 4000000 | 0 | 0 | 120000 | false | | sys | lineitem | l_quantity | decimal | 1000000 | 8000000 | 0 | 0 | 120000 | false | | sys | lineitem | l_extendedprice | decimal | 1000000 | 8000000 | 0 | 0 | 120000 | false | | sys | lineitem | l_discount | decimal | 1000000 | 8000000 | 0 | 0 | 120000 | false | | sys | lineitem | l_tax | decimal | 1000000 | 8000000 | 0 | 0 | 120000 | false | | sys | lineitem | l_returnflag | char | 1000000 | 2000000 | 0 | 0 | 0 | false | | sys | lineitem | l_linestatus | char | 1000000 | 2000000 | 0 | 0 | 0 | false | | sys | lineitem | l_shipdate | date | 1000000 | 8000000 | 0 | 0 | 120000 | false | | sys | lineitem | l_commitdate | date | 1000000 | 8000000 | 0 | 0 | 120000 | false | | sys | lineitem | l_receiptdate | date | 1000000 | 8000000 | 0 | 0 | 120000 | false | | sys | lineitem | l_shipinstruct | char | 1000000 | 2000000 | 0 | 0 | 0 | false | | sys | lineitem | l_shipmode | char | 1000000 | 2000000 | 0 | 0 | 0 | false | | sys | lineitem | l_comment | varchar | 1000000 | 1000000 | 8920240 | 0 | 0 | false | | sys | lineitem | lineitem_l_orderkey_l_linenumber_pkey | oid | 1000000 | 8000000 | 0 | 0 | 0 | false | | sys | lineitem | lineitem_fk1 | oid | 1000000 | 8000000 | 0 | 0 | 0 | false | | sys | lineitem | lineitem_fk2 | oid | 1000000 | 8000000 | 0 | 0 | 0 | false |

+--------+----------+---------------------------------------+---------+ - -- ------+------------+----------+---------+----------+--------+ 19 tuples (39.980ms)

On 06/11/15 19:09, Lynn Carol Johnson wrote:

...

Hi all -

I am new to monetdb. I am running on a MAC (OS X 10.9.5) I have installed monetdb, I have setup a dbfarm, created a couple of databases, and loaded tables. I would like to run some analysis on the amount of storage used for some of my tables. I have seen the description of autoloading scripts here: https://www.monetdb.org/book/export/html/242

And examples of running the storage() command here:

https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/storage-mod e l

But I get ³no such operator Œstoragemodlinit¹ when I try to execute ³call storagemodelinit()² . What command must be run to include the .sql extensions with the database? Is something run when we create the dbfarm? When we create the individual databases?

I can see the .sql extensions in my /usr/local/monetdb/lib/monetdb5/createdb folder on my MAC.

I¹d appreciate any pointers on how to set this up. Googling has not provided me with any answers.

Thanks - Lynn

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

Perfect !! That’s exactly what was missing (sys.storagemodelinit()) - thank! Lynn From: users-list mailto:users-list-bounces+lcj34=cornell.edu@monetdb.org> on behalf of Roberto Cornacchia mailto:roberto.cornacchia@gmail.com> Reply-To: Communication channel for MonetDB users mailto:users-list@monetdb.org> Date: Saturday, November 7, 2015 at 10:01 AM To: Communication channel for MonetDB users mailto:users-list@monetdb.org> Subject: Re: setting up db with storagemodel.sql Because you are in a user schema, and storagemodelinit is defined in the 'sys' schema, it's likely that you have to use call sys.storagemodelinit(); On 7 Nov 2015 14:02, "Lynn Carol Johnson" mailto:lcj34@cornell.edu> wrote: I loaded the July 2015 SP1, then created a new db, and tried the command again (you can see from the “welcome to client” message that it is Jul2015-SP1). Still getting the same error: RS-BTLCJ34LT-2:development lcj34$ monetdb create testJuly15SP1 created database in maintenance mode: testJuly15SP1 RS-BTLCJ34LT-2:development lcj34$ monetdb release testJuly15SP1 taken database out of maintenance mode: testJuly15SP1 RS-BTLCJ34LT-2:development lcj34$ mclient -u monetdb -d testJuly15SP1 password: Welcome to mclient, the MonetDB/SQL interactive terminal (Jul2015-SP1) Database: MonetDB v11.21.11 (Jul2015-SP1), 'mapi:monetdb://RS-BTLCJ34LT-2.local:50000/testJuly15SP1' Type \q to quit, \? for a list of available commands auto commit mode: on sql>create SCHEMA sp1Test; operation successful (1.760ms) sql>set SCHEMA sp1Test; auto commit mode: on sql>CREATE TABLE tenFeatures (chrom int, pos int, f1 varchar(20), f2 varchar(20), f3 varchar(20), f4 varchar(20), f5 varchar(20), f6 varchar(20), f7 varchar(20), f8 varchar(20), f9 varchar(20), f10 varchar(20)); operation successful (2.229ms) sql>\d TABLE sp1test.tenfeatures sql>call storagemodelinit(); SELECT: no such operator 'storagemodelinit' sql> Lynn On 11/7/15, 7:23 AM, "users-list on behalf of Lynn Carol Johnson" mailto:cornell.edu@monetdb.org on behalf of lcj34@cornell.edumailto:lcj34@cornell.edu> wrote:

The data base was newly created with the July 2015 installation of Monetdb.

I’ll install SP1 - not sure that I have that - and try again.

On 11/6/15, 3:19 PM, "users-list on behalf of Martin Kersten" mailto:cornell.edu@monetdb.org on behalf of martin.kersten@cwi.nlmailto:martin.kersten@cwi.nl> wrote:

...

Did you install the latest version, July2015-SP1 ? Is the database created by an earlier version of MonetDB?

On 06/11/15 21:12, Lynn Carol Johnson wrote:

...

I installed the July2015 version from MonetDB-11.21.5-x86_64-Darwin-14-bin.tar.bz2

I run these commands with this output:

rs-btlcj34lt:machineLearningDB lcj34$ monetdbd start /Users/lcj34/development/mydbfarm rs-btlcj34lt:machineLearningDB lcj34$ mclient -u monetdb -d test1 password: Welcome to mclient, the MonetDB/SQL interactive terminal (Jul2015) Database: MonetDB v11.21.5 (Jul2015), 'mapi:monetdb://rs-btlcj34lt.maize.cornell.edu:50000/test1http://rs-btlcj34lt.maize.cornell.edu:50000/test1' Type \q to quit, \? for a list of available commands auto commit mode: on sql>set SCHEMA test1; auto commit mode: on sql>\d TABLE test1.annosites TABLE test1.fhundredvarchar TABLE test1.monetdbfhundredvarchar sql>call storagemodelinit(); SELECT: no such operator 'storagemodelinit' sql> sql> sql>call storagemodelinit(); SELECT: no such operator 'storagemodelinit' sql>

Was there something to do on startup that I missed?

Thanks - Lynn

On 11/6/15, 2:51 PM, "users-list on behalf of Martin Kersten" mailto:cornell.edu@monetdb.org on behalf of martin.kersten@cwi.nlmailto:martin.kersten@cwi.nl> wrote:

...

Hi Lynn

What version of MonetDB are you using? Did you create database with an older version?

All operations are automatically included in the system catalog upon database creation or server update.

Running against the latest Jul2015-SP1 gives the following: sql>call storagemodelinit(); sql>update storagemodelinput set count = 1000000 where "table"='lineitem'; 19 affected rows (17.648ms) sql>update storagemodelinput set "distinct" = 1000 where "table"='lineitem' and "type"='varchar'; 1 affected row (17.512ms) sql>update storagemodelinput set "distinct" = 330000 where "table"='lineitem' and "column"='l_comment'; 1 affected row (22.412ms) sql>select * from storagemodel() where "table" = 'lineitem';

+--------+----------+---------------------------------------+---------+ - -- ------+------------+----------+---------+----------+--------+ | schema | table | column | type | count | columnsize | heapsize | hashes | imprints | sorted |

+========+==========+=======================================+=========+ = == ======+============+==========+=========+==========+========+ | sys | lineitem | l_orderkey | int | 1000000 | 4000000 | 0 | 8000000 | 120000 | true | | sys | lineitem | l_partkey | int | 1000000 | 4000000 | 0 | 8000000 | 120000 | false | | sys | lineitem | l_suppkey | int | 1000000 | 4000000 | 0 | 8000000 | 120000 | false | | sys | lineitem | l_linenumber | int | 1000000 | 4000000 | 0 | 0 | 120000 | false | | sys | lineitem | l_quantity | decimal | 1000000 | 8000000 | 0 | 0 | 120000 | false | | sys | lineitem | l_extendedprice | decimal | 1000000 | 8000000 | 0 | 0 | 120000 | false | | sys | lineitem | l_discount | decimal | 1000000 | 8000000 | 0 | 0 | 120000 | false | | sys | lineitem | l_tax | decimal | 1000000 | 8000000 | 0 | 0 | 120000 | false | | sys | lineitem | l_returnflag | char | 1000000 | 2000000 | 0 | 0 | 0 | false | | sys | lineitem | l_linestatus | char | 1000000 | 2000000 | 0 | 0 | 0 | false | | sys | lineitem | l_shipdate | date | 1000000 | 8000000 | 0 | 0 | 120000 | false | | sys | lineitem | l_commitdate | date | 1000000 | 8000000 | 0 | 0 | 120000 | false | | sys | lineitem | l_receiptdate | date | 1000000 | 8000000 | 0 | 0 | 120000 | false | | sys | lineitem | l_shipinstruct | char | 1000000 | 2000000 | 0 | 0 | 0 | false | | sys | lineitem | l_shipmode | char | 1000000 | 2000000 | 0 | 0 | 0 | false | | sys | lineitem | l_comment | varchar | 1000000 | 1000000 | 8920240 | 0 | 0 | false | | sys | lineitem | lineitem_l_orderkey_l_linenumber_pkey | oid | 1000000 | 8000000 | 0 | 0 | 0 | false | | sys | lineitem | lineitem_fk1 | oid | 1000000 | 8000000 | 0 | 0 | 0 | false | | sys | lineitem | lineitem_fk2 | oid | 1000000 | 8000000 | 0 | 0 | 0 | false |

+--------+----------+---------------------------------------+---------+ - -- ------+------------+----------+---------+----------+--------+ 19 tuples (39.980ms)

On 06/11/15 19:09, Lynn Carol Johnson wrote:

...

Hi all -

I am new to monetdb. I am running on a MAC (OS X 10.9.5) I have installed monetdb, I have setup a dbfarm, created a couple of databases, and loaded tables. I would like to run some analysis on the amount of storage used for some of my tables. I have seen the description of autoloading scripts here: https://www.monetdb.org/book/export/html/242

And examples of running the storage() command here:

https://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/storage-mod e l

But I get ³no such operator Œstoragemodlinit¹ when I try to execute ³call storagemodelinit()² . What command must be run to include the .sql extensions with the database? Is something run when we create the dbfarm? When we create the individual databases?

I can see the .sql extensions in my /usr/local/monetdb/lib/monetdb5/createdb folder on my MAC.

I¹d appreciate any pointers on how to set this up. Googling has not provided me with any answers.

Thanks - Lynn

_______________________________________________ users-list mailing list users-list@monetdb.orgmailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.orgmailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.orgmailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.orgmailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.orgmailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list

_______________________________________________ users-list mailing list users-list@monetdb.orgmailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list