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] http://hbase.apache.org/0.94/book/ttl.html [2] https://phoenix.apache.org/language/index.html#alter [3] https://phoenix.apache.org/rowtimestamp.html On Tue, Feb 13, 2018 at 2:42 AM, Vaghawan Ojha <vaghawan...@gmail.com> 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 >