Strings as Dimensions


#1

Taking the olympic_data example, i seem to be having trouble in the whole strings / dimensions area sorry guys (early apology expecting it is a basic error on my part)

All good up to and including. SELECT * FROM analyze(winnersFlat); (at the AQL prompt)

But get an error message focused (hat under) on the opening bracket for the re-dimension; CREATE ARRAY winners <person:string, time:double>
[year=1996:2008,1000,0, event(string)=3,1000,0];
(at the AQL prompt)

UserQueryException in file: src/query/parser/Driver.cpp function: fail line: 133
Error id: scidb::SCIDB_SE_PARSER::SCIDB_LE_QUERY_PARSING_ERROR
Error description: Error during query parsing. Query parser failed with error ‘syntax error’.
CREATE ARRAY winners <person:string, time:double> [year=1996:2008,1000,0, event(string)=3,1000,0]
^

Many thanks in advance for an help

G


#2

Hi.
This is an old feature we used to call “Non-Integer Dimensions” or “NIDs”.
They had that kind of syntax but there were also a lot of bugs and problems. So, a decision was made to remove that feature and, instead add two new operators: uniq and index_lookup.
For example usage, take a look at this post: viewtopic.php?f=18&t=1280