[jira] [Commented] (DRILL-7166) Tests doing count(* ) with wildcards in table name are querying metadata cache and returning wrong results

[ASF GitHub Bot (JIRA)]

    [ 
https://issues.apache.org/jira/browse/DRILL-7166?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16815019#comment-16815019
 ] 

ASF GitHub Bot commented on DRILL-7166:
---------------------------------------

amansinha100 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#discussion_r274237088
 
 

 ##########
 File path: 
exec/java-exec/src/test/java/org/apache/drill/exec/planner/logical/TestConvertCountToDirectScan.java
 ##########
 @@ -238,4 +238,40 @@ public void 
testCountsWithMetadataCacheSummaryAndDirPruning() throws Exception {
       test("drop table if exists %s", tableName);
     }
   }
+
+  @Test
+  public void testCountsWithWildCard() throws Exception {
+    test("use dfs.tmp");
+    String tableName = "parquet_table_counts";
+
+    try {
+      for (int i = 0; i < 10; i++) {
+        test(String.format("create table `%s/12/%s` as select * from 
cp.`tpch/orders.parquet`", tableName, i));
 
 Review comment:
   Since the test does not actually need a larger table, could you perhaps use 
a smaller table (like nation) here since there are 13 CTAS statements and doing 
a CTAS on 'orders' adds extra time to the test. 
 
----------------------------------------------------------------
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)