phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Juan Rodríguez Hortalá <juan.rodriguez.hort...@gmail.com>
Subject Re: blog describing new time-series data optimization
Date Sun, 08 Nov 2015 19:18:42 GMT
Hi,

Very interesting post and very useful feature. Just a minor remark, I think
there is a typo in the post, in the CREATE TABLE EVENTS_RTS statement

CREATE TABLE *EVENTS_RTS* (
    EVENT_ID CHAR(15) NOT NULL,
    EVENT_TYPE CHAR(3) NOT NULL,
    EVENT_TIME DATE NOT NULL,
    APPLICATION_TYPE VARCHAR,
    SOURCE_IP VARCHAR
    CONSTRAINT PK PRIMARY KEY (
        EVENT_ID,
        EVENT_TYPE,
        EVENT_DATE *ROW_TIMESTAMP*))

I think the column EVENT_TIME should be EVENT_DATE. Or maybe I'm not
understanding this correctly.

Greetings,

Juan



On Sat, Nov 7, 2015 at 6:53 PM, James Taylor <jamestaylor@apache.org> wrote:

> If you have time-series data for which you'd like to improve query
> performance, take a look at this[1] blog written by Samarth Jain on a new
> feature in our 4.6 release:
>
> https://blogs.apache.org/phoenix/entry/new_optimization_for_time_series
>
> Enjoy!
>
>     James
>

Mime
View raw message