[jira] [Created] (DRILL-2784) handle filenames with slashes ("/")

["Will Ochandarena (JIRA)" <ji...@apache.org>]

Will Ochandarena created DRILL-2784:
---------------------------------------

             Summary: handle filenames with slashes ("/")
                 Key: DRILL-2784
                 URL: https://issues.apache.org/jira/browse/DRILL-2784
             Project: Apache Drill
          Issue Type: Bug
          Components: Client - CLI
    Affects Versions: 0.8.0
            Reporter: Will Ochandarena
            Assignee: Daniel Barclay (Drill)


Google App Engine writes JSON logs in the following directory/filename format -
YY/MM/DD/HH/MM/SS_HH/MM/SS_S0.json

Sadly, some of these forward slashes indicate new path (directory for year, month, day) -
YY/MM/DD

Others are embedded in the filename ( file per start_hour, end_hour) -
HH/MM/SS_HH/MM/SS_S0.json

Example string (spaces added to illustrate where filename starts) -
2015/04/14/  17/00/00_17/59/59_S0.json

Drill throws this error -
0: jdbc:drill:zk=local> select * from dfs.`/.../2015/04/14/17/00/00_17/59/59_S0.json` LIMIT 5;
Apr 14, 2015 11:39:05 AM org.eigenbase.sql.validate.SqlValidatorException <init>
SEVERE: org.eigenbase.sql.validate.SqlValidatorException: Table 'dfs./.../2015/04/14/17/00/00_17/59/59_S0.json' not found
Apr 14, 2015 11:39:05 AM org.eigenbase.util.EigenbaseException <init>
SEVERE: org.eigenbase.util.EigenbaseContextException: From line 1, column 15 to line 1, column 17: Table 'dfs./Users/wochandarena/installerdialhomelogs/2015/04/14/17/00/00_17/59/59_S0.json' not found
Query failed: SqlValidatorException: Table 'dfs./Users/wochandarena/installerdialhomelogs/2015/04/14/17/00/00_17/59/59_S0.json' not found

If the file is renamed to not have slashes the query is successful.





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)