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

["Hao Zhu (JIRA)" <ji...@apache.org>]

Hao Zhu created DRILL-1794:
------------------------------

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