Because you are in a user schema, and storagemodelinit is defined in the 'sys' schema, it's likely that you have to use

On 7 Nov 2015 14:02, "Lynn Carol Johnson" <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"
<users-list-bounces+lcj34=cornell.edu@monetdb.org on behalf of
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"
><users-list-bounces+lcj34=cornell.edu@monetdb.org on behalf of
>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/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"
>>> <users-list-bounces+lcj34=cornell.edu@monetdb.org on behalf of
>>> 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.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

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