You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@phoenix.apache.org by "Chinmay Kulkarni (Jira)" <ji...@apache.org> on 2019/12/17 06:17:00 UTC
[jira] [Updated] (PHOENIX-5633) Add table name info to scan logging
[ https://issues.apache.org/jira/browse/PHOENIX-5633?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chinmay Kulkarni updated PHOENIX-5633:
--------------------------------------
Description:
We log the scans at the debug level at various places such as inside BaseQueryPlan, BaseResultIterators, Parallelterators, etc. To help with debugging, we should also print the table name that the scan will be scanning. An example of a log line for a scan currently, is:
{code:java}
19/12/16 22:10:38 DEBUG execute.BaseQueryPlan: Scan ready for iteration: {"loadColumnFamiliesOnDemand":true,"startRow":"","stopRow":"","batch":-1,"cacheBlocks":true,"totalColumns":1,"maxResultSize":-1,"families":{"0":["ALL"]},"caching":2147483647,"maxVersions":1,"timeRange":[0,9223372036854775807]}
{code}
OR
{code:java}
19/12/16 22:10:38 DEBUG iterate.BaseResultIterators: Getting iterators for ResultIterators [name=PARALLEL,id=1de62127-8ce9-b8d0-4881-6eaec8835ea5,scans=[[{"loadColumnFamiliesOnDemand":true,"startRow":"","stopRow":"","batch":-1,"cacheBlocks":true,"totalColumns":1,"maxResultSize":-1,"families":{"0":["ALL"]},"caching":2147483647,"maxVersions":1,"timeRange":[0,9223372036854775807]}]]]
19/12/16 22:10:38 DEBUG iterate.ParallelIterators: Id: 1de62127-8ce9-b8d0-4881-6eaec8835ea5, Time: 0ms, Scan: {"loadColumnFamiliesOnDemand":true,"startRow":"","stopRow":"","batch":-1,"cacheBlocks":true,"totalColumns":1,"maxResultSize":-1,"families":{"0":["ALL"]},"caching":2147483647,"maxVersions":1,"timeRange":[0,9223372036854775807]}
{code}
was:
We log the scans at the debug level at various places such as inside BaseQueryPlan, BaseResultIterators, Parallelterators, etc. To help with debugging, we should also print the table name that the scan will be scanning. An example of a log line for a scan currently, is:
{code:java}
19/12/16 22:10:38 DEBUG execute.BaseQueryPlan: Scan ready for iteration: {"loadColumnFamiliesOnDemand":true,"startRow":"","stopRow":"","batch":-1,"cacheBlocks":true,"totalColumns":1,"maxResultSize":-1,"families":{"0":["ALL"]},"caching":2147483647,"maxVersions":1,"timeRange":[0,9223372036854775807]}
{code}
OR
{code:java}
19/12/16 22:10:38 DEBUG iterate.BaseResultIterators: Getting iterators for ResultIterators [name=PARALLEL,id=1de62127-8ce9-b8d0-4881-6eaec8835ea5,scans=[[{"loadColumnFamiliesOnDemand":true,"startRow":"","stopRow":"","batch":-1,"cacheBlocks":true,"totalColumns":1,"maxResultSize":-1,"families":{"0":["ALL"]},"caching":2147483647,"maxVersions":1,"timeRange":[0,9223372036854775807]}]]]
19/12/16 22:10:38 DEBUG iterate.ParallelIterators: Id: 1de62127-8ce9-b8d0-4881-6eaec8835ea5, Time: 0ms, Scan: {"loadColumnFamiliesOnDemand":true,"startRow":"","stopRow":"","batch":-1,"cacheBlocks":true,"totalColumns":1,"maxResultSize":-1,"families":{"0":["ALL"]},"caching":2147483647,"maxVersions":1,"timeRange":[0,9223372036854775807]}
{code}
> Add table name info to scan logging
> -----------------------------------
>
> Key: PHOENIX-5633
> URL: https://issues.apache.org/jira/browse/PHOENIX-5633
> Project: Phoenix
> Issue Type: Improvement
> Affects Versions: 4.15.0
> Reporter: Chinmay Kulkarni
> Priority: Major
> Fix For: 4.15.1
>
>
> We log the scans at the debug level at various places such as inside BaseQueryPlan, BaseResultIterators, Parallelterators, etc. To help with debugging, we should also print the table name that the scan will be scanning. An example of a log line for a scan currently, is:
> {code:java}
> 19/12/16 22:10:38 DEBUG execute.BaseQueryPlan: Scan ready for iteration: {"loadColumnFamiliesOnDemand":true,"startRow":"","stopRow":"","batch":-1,"cacheBlocks":true,"totalColumns":1,"maxResultSize":-1,"families":{"0":["ALL"]},"caching":2147483647,"maxVersions":1,"timeRange":[0,9223372036854775807]}
> {code}
> OR
> {code:java}
> 19/12/16 22:10:38 DEBUG iterate.BaseResultIterators: Getting iterators for ResultIterators [name=PARALLEL,id=1de62127-8ce9-b8d0-4881-6eaec8835ea5,scans=[[{"loadColumnFamiliesOnDemand":true,"startRow":"","stopRow":"","batch":-1,"cacheBlocks":true,"totalColumns":1,"maxResultSize":-1,"families":{"0":["ALL"]},"caching":2147483647,"maxVersions":1,"timeRange":[0,9223372036854775807]}]]]
> 19/12/16 22:10:38 DEBUG iterate.ParallelIterators: Id: 1de62127-8ce9-b8d0-4881-6eaec8835ea5, Time: 0ms, Scan: {"loadColumnFamiliesOnDemand":true,"startRow":"","stopRow":"","batch":-1,"cacheBlocks":true,"totalColumns":1,"maxResultSize":-1,"families":{"0":["ALL"]},"caching":2147483647,"maxVersions":1,"timeRange":[0,9223372036854775807]}
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)