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
Any suggestion would be appreciated.