You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Abhishek Girish (JIRA)" <ji...@apache.org> on 2014/12/01 19:48:12 UTC
[jira] [Commented] (DRILL-1794) Can not make files with extension
"log" to be recognized as json format?
[ https://issues.apache.org/jira/browse/DRILL-1794?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14230224#comment-14230224 ]
Abhishek Girish commented on DRILL-1794:
----------------------------------------
Can you try also specifying the extension once? When I've used custom formats, I've always done so by specifying both type and extension.
"log": {
"type": "json",
"extensions": [
"log"
],
}
> Can not make files with extension "log" to be recognized as json format?
> ------------------------------------------------------------------------
>
> Key: DRILL-1794
> URL: https://issues.apache.org/jira/browse/DRILL-1794
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Data Types
> Affects Versions: 0.6.0
> Environment: 0.6R3
> Reporter: Hao Zhu
>
> If we want to use ".log" as the file extension, and also want it to be recognized as json format, I tried to use below storage engine , but failed to read the .log file..
> {code}
> "formats": {
> "log": {
> "type": "json"
> },
> "csv": {
> "type": "text",
> "extensions": [
> "csv"
> ],
> "delimiter": ","
> }
> }
> {code}
> {code}
> 0: jdbc:drill:zk=n1a:5181,n2a:5181,n3a:5181> select * from logtest.`test.json`;
> +------------+------------+------------+------------+
> | field1 | field2 | field3 | field4 |
> +------------+------------+------------+------------+
> | data1 | 100.0 | more data1 | 123.001 |
> +------------+------------+------------+------------+
> 1 row selected (0.159 seconds)
> 0: jdbc:drill:zk=n1a:5181,n2a:5181,n3a:5181> select * from logtest.`test.log`;
> Query failed: Failure while validating sql : org.eigenbase.util.EigenbaseContextException: From line 1, column 16 to line 1, column 22: Table 'logtest.test.log' not found
> Error: exception while executing query: Failure while executing query. (state=,code=0)
> {code}
> Do we support above requirement?
> If so, what is the storage plugin text?
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)