[
https://issues.apache.org/jira/browse/DRILL-7166?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16814962#comment-16814962
]
ASF GitHub Bot commented on DRILL-7166:
---------------------------------------
dvjyothsna commented on pull request #1745: DRILL-7166: Count query with
wildcard should skip reading of metadata summary file
URL: https://github.com/apache/drill/pull/1745
Count(*) or Count(column) queries use the aggregated row count and null
count from the metadata summary file without reading the large file metadata.
When the directory filter has a wildcard, count cannot be fetched from the
metadata summary file since the summary file contains count of all the children
underneath that and there is no way to filter using wild card. The
ConvertCountToDirectScan physical rule will be applied to these cases.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
> Tests doing count(* ) with wildcards in table name are querying metadata
> cache and returning wrong results
> ----------------------------------------------------------------------------------------------------------
>
> Key: DRILL-7166
> URL: https://issues.apache.org/jira/browse/DRILL-7166
> Project: Apache Drill
> Issue Type: Bug
> Components: Metadata
> Affects Versions: 1.16.0
> Reporter: Abhishek Girish
> Assignee: Venkata Jyothsna Donapati
> Priority: Blocker
> Fix For: 1.16.0
>
>
> Tests:
> {code}
> Functional/metadata_caching/data/drill4376_1.q
> Functional/metadata_caching/data/drill4376_2.q
> Functional/metadata_caching/data/drill4376_3.q
> Functional/metadata_caching/data/drill4376_4.q
> Functional/metadata_caching/data/drill4376_5.q
> Functional/metadata_caching/data/drill4376_6.q
> Functional/metadata_caching/data/drill4376_8.q
> {code}
> Example pattern of queries:
> {code}
> select count(*) from `lineitem_hierarchical_intint/*8*/3*`;
> {code}
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
