Re: setting up db with storagemodel.sql

7 Nov 2015


      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"  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"
 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
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list

Re: setting up db with storagemodel.sql

Roberto Cornacchia