Yes, the datetime column is part of my primary key, but primary key also
consists other strings.


On Tue, Feb 13, 2018 at 11:05 PM, James Taylor <>

> The standard way of doing this is to add a TTL for your table [1]. You can
> do this through the ALTER TABLE call [2]. Is the date/time column part of
> your primary key? If so, you can improve performance by declaring this
> column as a ROW_TIMESTAMP [3].
> A view is not going to help you - it's not materialized.
> Thanks,
> James
> [1]
> [2]
> [3]
> On Tue, Feb 13, 2018 at 2:42 AM, Vaghawan Ojha <>
> wrote:
>> Hi,
>> I'm using phoenix 4.12 with hbase 1.2.0, I've a table with few millions
>> of rows, but I don't need much of the old data, Let's say the frequent data
>> I need is data from 2 month back.
>> the query become slow when I read the table using timestamp. So query
>> would be like where date>some date and <some date.
>> I was thinking of creating a veiw table where I could put the latest two
>> months data, but the data there should consist only the latest two months.
>> The parent table is updated daily with the new data, so in my case whenever
>> new day's data comes in, the last one day's data should be removed from the
>> view, making sure that the view consists two month's data. (e.g it would
>> always hold last 60 days data)
>> I don't know if that is possible using create view. If it is how can I do
>> it?
>> Any suggestion would be appreciated.
>> Thanks
>> Vaghawan

Reply via email to