phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James Taylor <>
Subject Re: How to specify the point lookup chunks number(parallelism) at query
Date Tue, 29 Aug 2017 14:43:28 GMT
The finest granularity we have available is to specify a guidepost width at
the table level with the GUIDEPOSTS_WIDTH=## property. This will take
effect for that table next time stats are collected (on a major compaction
or when collected manually through the UPDATE STATISTICS command).

On Tue, Aug 29, 2017 at 7:23 AM 孙文隆 <> wrote:

> Hi there,
> I am optimizing an sql that is compiled to point lookups. Since sometimes
> there could be many thousands of "in" conditions in the sql, I would like
> to increase the parallelism number for better performance. I know that I
> can increase the salted bucket number or decrease the guide post width to
> increase the parallelism number. But is there any way to specify the
> parallelism at the runtime of JDBC so that I can change it according to the
> number of "in" conditions?
> Best regards,
> Ryan

View raw message