[jira] [Resolved] (DRILL-1794) Can not make files with extension "log" to be recognized as json format?

["Jason Altekruse (JIRA)" <ji...@apache.org>]

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

Jason Altekruse resolved DRILL-1794.
------------------------------------
    Resolution: Duplicate

> 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)