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"
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