You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Abhishek Girish (JIRA)" <ji...@apache.org> on 2019/04/10 19:18:00 UTC
[jira] [Commented] (DRILL-7166) Tests doing count(* ) with
wildcards in table name are querying metadata cache and returning wrong
results
[ 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)