Re: Setting a TTL in an upsert

2015-09-23 Thread James Taylor
gt; > -Alex. > > > > *From:* James Taylor [mailto:jamestay...@apache.org] > *Sent:* September 23, 2015 10:59 > *To:* James Taylor > *Cc:* user > > *Subject:* Re: Setting a TTL in an upsert > > > > Also, for more information on (2), see > https://phoenix.a

RE: Setting a TTL in an upsert

2015-09-23 Thread Alex Loffler
Alex. From: James Taylor [mailto:jamestay...@apache.org] Sent: September 23, 2015 10:59 To: James Taylor Cc: user Subject: Re: Setting a TTL in an upsert Also, for more information on (2), see https://phoenix.apache.org/faq.

Re: Setting a TTL in an upsert

2015-09-23 Thread James Taylor
e them on the next major compaction. >> >> From the documentation, Phoenix supports TTL on secondary indexes as long >> as they are created with the same value as the base table, which would be >> perfect! >> >> Thanks, >> >> -Alex. >> >> *F

Re: Setting a TTL in an upsert

2015-09-23 Thread James Taylor
ocumentation, Phoenix supports TTL on secondary indexes as long > as they are created with the same value as the base table, which would be > perfect! > > Thanks, > > -Alex. > > *From:* Yuhao Bi [mailto:byh0...@gmail.com ] > *Sent:* September 23, 2015 00:31 > *To:* user

RE: Setting a TTL in an upsert

2015-09-23 Thread Alex Loffler
t;they are created with the same value as the base table, which would be perfect! Thanks, -Alex. From: Yuhao Bi [mailto:byh0...@gmail.com] Sent: September 23, 2015 00:31 To: user Subject: Re: Setting a TTL in an upsert Hi, As I know, we can only set a ttl in create table stage corresponding to

Re: Setting a TTL in an upsert

2015-09-23 Thread Yuhao Bi
Hi, As I know, we can only set a ttl in create table stage corresponding to HBase table ttl. CREATE TABLE IF NOT EXISTS my_schema.my_table ( org_id CHAR(15), entity_id CHAR(15), payload binary(1000), CONSTRAINT pk PRIMARY KEY (org_id, entity_id) ) TTL=86400 See http://phoenix.apache.o