[DRILL-3123] Dir0 has issues when we have a '/' at the beginning of the path

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 1.0.0
• Fix Version/s: Future
• Component/s: Execution - Relational Operators
• Assignee: Paul Rogers
• Reporter: Rahul Kumar Challapalli
• Created: 17/May/15 23:46
• Updated: 19/Jun/17 00:48

Description

Follow the below steps :

hadoop fs -mkdir /drill/testdata/repro1/20150120
hadoop fs -mkdir /drill/testdata/repro1/20150121

1. Add the below workspace :
"repro1": {
      "location": "/drill/testdata/repro1",
      "writable": true,
      "defaultInputFormat": "parquet"
    }

2. Now copy a sample json file into both the above directories

The below query returns incorrect results :

select * from dfs.repro1.`/*/sample.json` limit 1;
+-----------+---------+-----------+-----+------+
|   dir0    |  dir1   |   dir2    | id  | val  |
+-----------+---------+-----------+-----+------+
| testdata  | repro1  | 20150121  | 1   | 1    |
+-----------+---------+-----------+-----+------+

The same query worked from an older build (commit # d10769f478900ff1868d206086874bdd67a45e7d)

select * from dfs.repro1.`/*/sample.json` limit 1;
+------------+------------+------------+
|    dir0    |     id     |    val     |
+------------+------------+------------+
| 20150121   | 1          | 1          |
+------------+------------+------------+