You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@phoenix.apache.org by Adi Kadimetla <ka...@gmail.com> on 2018/03/27 21:23:50 UTC

v2 field - index type is decimal but table has bigint type.

Hi group,

CREATE TABLE my_table (k VARCHAR PRIMARY KEY, v1 VARCHAR, v2 BIGINT);

v2 - BIGINT

CREATE INDEX my_index ON my_table (v2) INCLUDE (v1);

MY_INDEX    | 0:V2         | 3          | DECIMAL

In my_index v2 type is decimal. I wanted to know data type change from
bigint in the  table to decimal in  the index this is expected.


phoenix-4.7.0

HDP - 2.6.3

Thanks