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