Phoenix service query timed out.

[Problem Description]

 The Phoenix query times out.

[Analysis Procedure]

The error message "Failed to get result within timeout" is recorded in service logs.

The service query statement is select p_day,count (1) from CDR_DWH_PK where p_day >= to_date ('2024-06-01') and p_day >= to date ('2024-06-30') group by p_day.
[Root Cause]

The entire table is scanned during service query. As the table data volume increases, the service query duration increases.

[Workaround]

1.  Increase the timeout parameter value in the hbase-site.xml file invoked by the service side.

    hbase.rpc.timeout=600000

    hbase.client.operation.timeout=1200000

    hbase.query.timeoutMs=1200000

    hbase.client.scanner.timeout.period=1200000

2.  For tables whose data cannot be deleted permanently, data needs to be written to the tables by time. Tables can be created by month or year to ensure that the data in the tables does not increase continuously.