[
https://issues.apache.org/jira/browse/DRILL-1794?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14230454#comment-14230454
]
Abhishek Girish commented on DRILL-1794:
----------------------------------------
The linked issue is marked as unresolved. And although there is a patch
available, it does not look to be merged into master. So the build you are
trying may not have this fix. Also, the custom formats I've tried were for text
and not for json.
> 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)
