[ https://issues.apache.org/jira/browse/DRILL-7166?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16814809#comment-16814809 ]
Abhishek Girish commented on DRILL-7166: ---------------------------------------- {code} Query: Functional/metadata_caching/data/drill4376_6.q select count(*) from `lineitem_hierarchical_intint/*/1*` Expected number of rows: 1 Actual number of rows from Drill: 1 Number of matching rows: 0 Number of rows missing: 1 Number of rows unexpected: 1 These rows are not expected (first 10): 70175 These rows are missing (first 10): 19775 (1 occurence(s)) Query: Functional/metadata_caching/data/drill4376_8.q select count(*) from `lineitem_hierarchical_intint/*8*/3*` Expected number of rows: 1 Actual number of rows from Drill: 1 Number of matching rows: 0 Number of rows missing: 1 Number of rows unexpected: 1 These rows are not expected (first 10): 70175 These rows are missing (first 10): 3600 (1 occurence(s)) Query: Functional/metadata_caching/data/drill4376_3.q select count(*) from `lineitem_hierarchical_intint/1**2` Expected number of rows: 1 Actual number of rows from Drill: 1 Number of matching rows: 0 Number of rows missing: 1 Number of rows unexpected: 1 These rows are not expected (first 10): 70175 These rows are missing (first 10): 20175 (1 occurence(s)) Query: Functional/metadata_caching/data/drill4376_2.q select count(*) from `lineitem_hierarchical_intint/19*4` Expected number of rows: 1 Actual number of rows from Drill: 1 Number of matching rows: 0 Number of rows missing: 1 Number of rows unexpected: 1 These rows are not expected (first 10): 70175 These rows are missing (first 10): 20000 (1 occurence(s)) Query: Functional/metadata_caching/data/drill4376_1.q select count(*) from `lineitem_hierarchical_intint/199*` Expected number of rows: 1 Actual number of rows from Drill: 1 Number of matching rows: 0 Number of rows missing: 1 Number of rows unexpected: 1 These rows are not expected (first 10): 70175 These rows are missing (first 10): 30000 (1 occurence(s)) Query: Functional/metadata_caching/data/drill4376_5.q select count(*) from `lineitem_hierarchical_intint/*/1` Expected number of rows: 1 Actual number of rows from Drill: 1 Number of matching rows: 0 Number of rows missing: 1 Number of rows unexpected: 1 These rows are not expected (first 10): 70175 These rows are missing (first 10): 6300 (1 occurence(s)) Query: Functional/metadata_caching/data/drill4376_4.q select count(*) from `lineitem_hierarchical_intint/*8*` Expected number of rows: 1 Actual number of rows from Drill: 1 Number of matching rows: 0 Number of rows missing: 1 Number of rows unexpected: 1 These rows are not expected (first 10): 70175 These rows are missing (first 10): 40175 (1 occurence(s)) {code} > 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: Pritesh Maker > Priority: Critical > 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)