drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Will Ochandarena (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DRILL-2784) handle filenames with colons (":")
Date Tue, 14 Apr 2015 22:30:58 GMT

     [ https://issues.apache.org/jira/browse/DRILL-2784?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Will Ochandarena updated DRILL-2784:
------------------------------------
    Summary: handle filenames with colons (":")  (was: handle filenames with slashes ("/"))

> handle filenames with colons (":")
> ----------------------------------
>
>                 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./.../2015/04/14/17/00/00_17/59/59_S0.json' not found
> Query failed: SqlValidatorException: Table 'dfs./.../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)

Mime
View raw message