[
https://issues.apache.org/jira/browse/DRILL-2784?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Will Ochandarena updated DRILL-2784:
------------------------------------
Description:
Google App Engine writes JSON logs in the following directory/filename format -
YY/MM/DD/HH:MM:SS_HH:MM:SS_S0.json
Example path) -
2015/04/14/17:00:00_17:59:59_S0.json
If the file is renamed to not have colons the query is successful. Errors below
Drill throws this error -
0: jdbc:drill:zk=local> select * from dfs.`/.../2015/04/14/` LIMIT 1;
Query failed: URISyntaxException: Relative path in absolute URI:
00:00:00_00:59:59_S0.json
Error: exception while executing query: Failure while executing query.
(state=,code=0)
was:
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.
> 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
> Example path) -
> 2015/04/14/17:00:00_17:59:59_S0.json
> If the file is renamed to not have colons the query is successful. Errors
> below
> Drill throws this error -
> 0: jdbc:drill:zk=local> select * from dfs.`/.../2015/04/14/` LIMIT 1;
> Query failed: URISyntaxException: Relative path in absolute URI:
> 00:00:00_00:59:59_S0.json
> Error: exception while executing query: Failure while executing query.
> (state=,code=0)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
