phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Samarth Jain <samarth.j...@gmail.com>
Subject Re: blog describing new time-series data optimization
Date Sun, 08 Nov 2015 19:21:44 GMT
Glad you find it useful, Juan and thanks for reporting the typo. The column
name should be EVENT_DATE. We will get it changed.

On Sun, Nov 8, 2015 at 11:18 AM, Juan Rodríguez Hortalá <
juan.rodriguez.hortala@gmail.com> wrote:

> 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