Hm...
https://phoenix.apache.org/dynamic_columns.html
says opposite.
I removed "VARCHAR" for "crossId" because this field is not dynamic. Looks
like it start to work. Exception is not thrown at least...
2015-08-30 22:58 GMT+02:00 Matjaž Trtnik <m...@salviol.com>:
> You have to skip VARCHAR in your upsert statement:
>
> upsert into cross_id_attributes (crossId, id1, id2) values
> ('crossIdvalue','id1Value','id2Value')
>
>
> Sent from my iPhone
>
> On 30 Aug 2015, at 22:38, Serega Sheypak <serega.shey...@gmail.com> wrote:
>
> Hi, Getting error which confuses me.
> Here is DDL:
> CREATE TABLE IF NOT EXISTS cross_id_attributes
> (
> crossId VARCHAR NOT NULL
> CONSTRAINT cross_id_reference_pk PRIMARY KEY (crossId)
> )
>
> Here is upsert query:
> upsert into cross_id_attributes(crossId VARCHAR, id1 VARCHAR, ,id2
> VARCHAR)values('crossIdvalue','id1Value','id2Value')
>
> And exception is:
> Number of columns upserting must match number of values. Numbers of
> columns: 4. Number of values: 3
>
> What does it mean? I have three cols and 3 values
>
>
