You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Kristine Hahn (JIRA)" <ji...@apache.org> on 2015/05/29 20:00:17 UTC
[jira] [Closed] (DRILL-3169) gz files cannot be accessed without gz
formats extension definition
[ https://issues.apache.org/jira/browse/DRILL-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kristine Hahn closed DRILL-3169.
--------------------------------
Resolution: Invalid
> gz files cannot be accessed without gz formats extension definition
> -------------------------------------------------------------------
>
> Key: DRILL-3169
> URL: https://issues.apache.org/jira/browse/DRILL-3169
> Project: Apache Drill
> Issue Type: Bug
> Affects Versions: 1.0.0
> Environment: Mac OS X
> Reporter: Kristine Hahn
>
> To reproduce the problem:
> 1. Put a gz file on the file system.
> 2. Define a plugin with and without a gz extension. For example:
> {noformat}
> {
> "type": "file",
> "enabled": true,
> "connection": "file:///",
> "workspaces": {
> "ngram": {
> "location": "/Users/khahn/drill/apache-drill-1.0.0",
> "writable": false,
> "defaultInputFormat": null
> }
> },
> "formats": {
> "tsv": {
> "type": "text",
> "extensions": [
> "tsv",
> "gz"
> ],
> "delimiter": "\t"
> }
> }
> }
> {noformat}
> 3. Try to query the gz file.
> Expected results: success with and without the gz extension
> Actual results: error without the gz extension defined in formats.
> *Output--no gz extension in formats*
> {noformat}
> 0: jdbc:drill:zk=local> SELECT * FROM ngram.`/googlebooks.gz`;
> May 22, 2015 6:06:51 AM org.apache.calcite.sql.validate.SqlValidatorException <init>
> SEVERE: org.apache.calcite.sql.validate.SqlValidatorException: Table 'ngram./googlebooks.gz' not found
> May 22, 2015 6:06:51 AM org.apache.calcite.runtime.CalciteException <init>
> SEVERE: org.apache.calcite.runtime.CalciteContextException: From line 1, column 16 to line 1, column 20: Table 'ngram./googlebooks.gz' not found
> Error: PARSE ERROR: From line 1, column 16 to line 1, column 20: Table 'ngram./googlebooks.gz' not found
> [Error Id: 28f38441-81a0-4167-afad-86a8169d383b on 172.30.1.90:31010] (state=,code=0)
> {noformat}
> *Output with gz extension defined in formats*
> {noformat}
> 0: jdbc:drill:zk=local> SELECT * FROM ngram.`/googlebooks.gz`;
> +-----------------------------------------------------------------------+
> | columns |
> +-----------------------------------------------------------------------+
> | ["ZOCOR should be taken with","2002","7","5"] |
> | ["ZOCOR should be taken with","2003","12","12"] |
> . . .
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)