phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ankit Singhal <ankitsingha...@gmail.com>
Subject Re: Can set default value for column in phoenix ?
Date Fri, 14 Jul 2017 14:22:00 GMT
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, 曾柏棠 <zengbaitang@qq.com> wrote:

> Oh ,thanks!
>
>
> ------------------ 原始邮件 ------------------
> *发件人:* "Juvenn Woo";<machese@gmail.com>;
> *发送时间:* 2017年7月14日(星期五) 下午3:39
> *收件人:* "user"<user@phoenix.apache.org>;
> *主题:* 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 !
>
>
>

Mime
View raw message