Thanks Sergey. I forgot to mention that the data is loaded via MapReduce. If I
load data with HFile, will Phoenix generate the stats automatically? This is
what I didn’t understand. I find this on official page "Statistics are also
automatically collected during major compactions and region
The general answer is no. In some cases, row timestamp feature
https://phoenix.apache.org/rowtimestamp.html may be useful. But still, you
should have timestamp column in your table DDL in that case.
Thanks,
Sergey
On Thu, Mar 29, 2018 at 1:14 AM, alexander.scherba...@yandex.com <
Usually such kind of problems may happen when something wrong with the
statistic. You may try to clean SYSTEM.STATS, restart the client and check
whether it fixes the problem. If not, you may try to turn on DEBUG log
level on the client and check whether generated scans are covering all
regions
Hi, recently I encounter a strange issue about missing data. For instance,
column A, B and C is the primary keys in Phoenix and I can get all the relevant
records via the condition A=‘aaa'. But some time later(maybe one hour or more),
I get the less records than before with the same condition.
Hi Yun,
You mean, we need to increase the connections in connection pool ?. We dint
have any changes to our code before upgrade. Same code is working on 4.7
version.
Note : We are using APACHE_PHOENIX-4.11.0-cdh5.11.2.p0.1.
Thanks,
Anil
On 24 March 2018 at 20:57, zhang yun
Hello,
Link [1] describes how to set a timestamp during connection creation in Phoenix.
Is it possible to use SQL query to get the timestamp value or made some
filtering?
Thanks,
Alexander.
[1]