Only constant expressions are allowed for default value currently (as mentioned by Juvenn). PHOENIX-3425 is for supporting expressions such as CURRENT_DATE and NEXT VALUE FOR.
On Fri, Jul 14, 2017 at 7:22 AM Ankit Singhal <[email protected]> wrote: > Phoenix 4.9 onwards you can specify any expression for default column. > (I'm not sure if there is any limitation called out). > For syntax:- > https://phoenix.apache.org/language/index.html#column_def > > For examples- > > https://github.com/apache/phoenix/blob/2d40241b5c5c0287dca3dd2e2476db328bb7e7de/phoenix-core/src/it/java/org/apache/phoenix/end2end/DefaultColumnValueIT.java > > On Fri, Jul 14, 2017 at 1:38 PM, 曾柏棠 <[email protected]> wrote: > >> Oh ，thanks！ >> >> >> ------------------ 原始邮件 ------------------ >> *发件人:* "Juvenn Woo";<[email protected]>; >> *发送时间:* 2017年7月14日(星期五) 下午3:39 >> *收件人:* "user"<[email protected]>; >> *主题:* Re: Can set default value for column in phoenix ? >> >> Hi Baitang, >> >> Yes, you can, but only constant value at the moment. So literal value >> such as ‘string’, 0, 0.0 would work well, but CURRENT_TIME will not. (As >> far as I know.) >> >> Best, >> -- >> Juvenn Woo >> Sent with Sparrow <http://www.sparrowmailapp.com/?sig> >> >> On Friday, 14 July 2017 at 3:29 PM, 曾柏棠 wrote: >> >> hi all, >> Can set default value for column in phoenix ? >> for example : >> >> CREATE TABLE api.hahah( >> subscribe_time bigint not null , >> *hahha varchar default 'aaa',* >> CONSTRAINT pk PRIMARY KEY (subscribe_time) >> ) >> >> Thanks ! >> >> >> >
