Re: question about arrays in SciQL

3 May 2013

      Hi Jennie,

Thanks for the apt response! Is it the same with altering a _bounded_
array? So e.g. the query

alter table "my_bounded_array" alter column X integer dimension[1:1:10]

is not supposed to increase X's cardinality if it originally was defined as
dimension[1:1:5], isn't it?

Thanks again!

Best regards,
    Gabor

On 2 May 2013 13:31, Ying Zhang  wrote:
...
Hello Gabor,
First of all, thank you very much for you interest in MonetDB/SciQL.
Since the implementation of the SciQL language is still an ongoing work,
compile the "sciql" branch from the Mercurial repository is the only way to
get SciQL support.
The incorrect results you got from inserting into unbounded array is
because it's not supported yet.
Except creation, operations on unbounded arrays are generally not
supported yet.
I have tried to give an error message for unsupported features, but there
are too many to cover them all.
My apologies for the confusion!
With kind regards,
Jennie
On May 02, 2013, at 09:22, Gabor Urbanics wrote:
...
Hi All,
I have a question about MonetDB/SciQL, in particular regards to the
unbounded arrays and their updates.
I've created two arrays (one bounded and an unbounded) essentially with
the same schemata in my database as follows:
"""
sql>\d
ARRAY  sys.facts
ARRAY  sys.facts_bounded
sql>\d sys.source
CREATE TABLE "sys"."source" (
      "x" INTEGER,
      "y" INTEGER,
      "v"  VARCHAR(32)
);
sql>\d sys.facts
CREATE ARRAY "sys"."facts" (
      "x" INTEGER       DIMENSION [0:1:1],
      "y" INTEGER       DIMENSION [0:1:*],
      "v"  VARCHAR(32)
);
"""
My goal at the moment is to use the unbounded array as it would fit very
well the domain of my application: several coordinates-like columns and a
couple of attributes, but the ranges of the coordinates are not known
beforehand.
Unfortunately, I am facing some problems when I try to insert values
into the unbounded array:
"""
  sql>insert into sys.facts values (0,0,'42');
  0 affected rows (0.938ms)
"""
On the other hand, the same insert operation works just fine with the
bounded array:
"""
  sql>insert into sys.facts_bounded values (0,0,'42');
  1 affected row (20.594ms)
  sql>select * from sys.facts_bounded;
  +------+------+------+
  |  x   |  y   | v    |
  +======+======+======+
  |    0 |    0 | 42   |
  |    0 |    1 | null |
  ... (5 lines omitted for brevity)
  |    1 |    3 | null |
  +------+------+------+
  8 tuples (0.612ms)
"""
I would like to know if this is the supposed way one can insert values
into unbounded arrays or I am doing something wrong.
I compiled the source from the branch "sciql" from the mercurial
repository 2 days ago, as my understanding was that the built versions do
not support SciQL. Is there any other way I can get a MonetDB with SciQL
support?
If it helps anything, the beginning of the welcome message of the
mserver5 is as follows:
"""
  # MonetDB 5 server v11.16.0
  # This is an unreleased version
  # Serving database 'monetdb5', using 4 threads
  # Compiled for x86_64-unknown-linux-gnu/64bit with 64bit OIDs
dynamically linked
"""
Any help or suggestion is appreciated!
Best regards,
    Gabor
_______________________________________________
users-list mailing list
users-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list
_______________________________________________
users-list mailing list
users-list@monetdb.org
http://mail.monetdb.org/mailman/listinfo/users-list