Error during schema inferring


#1

I have the following error with insert operation:

AFL% show(upd1);
[(“upd1val:int64 [dev=0:,1000,100,param=0:,1000,100,ts=0:*,1000,100]”)]

AFL% show(data);
[(“dataval:int64 [dev=0:,1000,100,param=0:,1000,100,ts=0:*,1000,100]”)]

AFL% insert( upd1, data);
UserException in file: src/query/ops/insert/LogicalInsert.cpp function: inferSchema line: 170
Error id: scidb::SCIDB_SE_INFER_SCHEMA::SCIDB_LE_DIMENSIONS_DONT_MATCH
Error description: Error during schema inferring. Dimensions ‘dev’ and ‘dev’ do not match.
Failed query id: 1100888995451

Is it ok, and how to handle this.


#2

I had a similar problem once, but there my versions of ‘dev’ were almost, but not quite entirely unlike each other:

One array’s dev was [0:*, …] bu the other array had [0:3212,…] (some large number, and it is unimportant…) therefore it was not open ended any more.
But this is not the case for you… So I am very curious too.

I had to create another array with open ended dimension and merge into it…

George


#3

I’ve recently had the exact same problem as morgovy. My dimensions are not open-ended and the only difference between the 2 arrays is that the chunk overlaps of the corresponding dimension are different. This happens in 13.6, and I don’t think the dimensions are incompatible because of the chunk sizes.

Another note is that if the 2 arrays are of the exact same bounded dimensions, it is ok as I’ve tried it before.

Can anyone know what the problem is?

Thanks.