Re: Probably issue of DEFAULT column value when creating table

2018-11-14 Thread gengxin
Hi Francis, It worked, thanks! > 在 2018年11月15日,13:59,Francis Chuang 写道: > > Can you try enclosing the string with single quotes (haven't tried this > myself as I currently don't have access to my Phoenix test cluster): > > CREATE TABLE TEST ( > a BIGINT NOT NULL DEFAULT 0, > b CHAR(10) DEFAUL

Re: Probably issue of DEFAULT column value when creating table

2018-11-14 Thread Francis Chuang
Can you try enclosing the string with single quotes (haven't tried this myself as I currently don't have access to my Phoenix test cluster): CREATE TABLE TEST ( a BIGINT NOT NULL DEFAULT 0, b CHAR(10) DEFAULT 'abc', cf.c INTEGER DEFAULT 1 CONSTRAINT pk PRIMARY KEY (a ASC, b ASC) ); On 15/11/201

Probably issue of DEFAULT column value when creating table

2018-11-14 Thread xin geng
Hi, all I'm learning phoenix, when trying to create table with the sql below, I met a ColumnNotFoundException, which probably be a issue of phoenix. Please correct me if I'm wrong. :) SQL: CREATE TABLE TEST ( a BIGINT NOT NULL DEFAULT 0, b CHAR(10) DEFAULT "abc", cf.c INTEGER DEFAULT 1 CONSTRA