Nick Venenga created DRILL-7853:
-----------------------------------
Summary: java.lang.NoSuchMethodException:
org.apache.drill.exec.physical.impl.scan.convert.ConvertStringToTimeStamp.<init>(org.apache.drill.exec.vector.accessor.ScalarWriter)
Key: DRILL-7853
URL: https://issues.apache.org/jira/browse/DRILL-7853
Project: Apache Drill
Issue Type: Bug
Affects Versions: 1.18.0
Reporter: Nick Venenga
Attachments: sample.log.gz
Exception when attempting to parse strings to timestamp using logRegex
{noformat}
$ tree data
data
└── 2021
└── 01
└── 20
└── sample.log.gz
{noformat}
{code:java}
{
"type": "file",
"connection": "file:///",
"config": {},
"workspaces": {
"tmp": {
"location": "/tmp",
"writable": true,
"defaultInputFormat": null,
"allowAccessOutsideWorkspace": false
},
"root": {
"location": "/data",
"writable": false,
"defaultInputFormat": null,
"allowAccessOutsideWorkspace": false
}
},
"formats": {
"log": {
"type": "logRegex",
"regex": "([^ ]*) ([^ ]*) ([^ ]*) ([^ ]*):([0-9]*) ([^ ]*)[:-]([0-9]*)
([-.0-9]*) ([-.0-9]*) ([-.0-9]*) (|[-0-9]*) (-|[-0-9]*) ([-0-9]*) ([-0-9]*)
\"([^ ]*) ([^ ]*) (- |[^ ]*)\" \"([^\"]*)\" ([A-Z0-9-]+) ([A-Za-z0-9.-]*) ([^
]*) \"([^\"]*)\" \"([^\"]*)\" \"([^\"]*)\" ([-.0-9]*) ([^ ]*) \"([^\"]*)\"($|
\"[^ ]*\")(.*)",
"extension": "gz",
"maxErrors": 10,
"schema": [
{
"fieldName": "type"
},
{
"fieldName": "time",
"fieldType": "TIMESTAMP",
"format": "yyyy-MM-dd''T''HH:mm:ssZ"
},
{
"fieldName": "elb"
},
{
"fieldName": "client_ip"
},
{
"fieldName": "client_port",
"fieldType": "INT"
},
{
"fieldName": "target_ip"
},
{
"fieldName": "target_port",
"fieldType": "INT"
},
{
"fieldName": "request_processing_time",
"fieldType": "FLOAT8"
},
{
"fieldName": "target_processing_time",
"fieldType": "FLOAT8"
},
{
"fieldName": "response_processing_time",
"fieldType": "FLOAT8"
},
{
"fieldName": "elb_status_code"
},
{
"fieldName": "target_status_code"
},
{
"fieldName": "received_bytes",
"fieldType": "BIGINT"
},
{
"fieldName": "sent_bytes",
"fieldType": "BIGINT"
},
{
"fieldName": "request_verb"
},
{
"fieldName": "request_url"
},
{
"fieldName": "request_proto"
},
{
"fieldName": "user_agent"
},
{
"fieldName": "ssl_cipher"
},
{
"fieldName": "ssl_protocol"
},
{
"fieldName": "target_group_arn"
},
{
"fieldName": "trace_id"
},
{
"fieldName": "domain_name"
},
{
"fieldName": "chosen_cert_arn"
},
{
"fieldName": "matched_rule_priority"
},
{
"fieldName": "request_creation_time"
},
{
"fieldName": "actions_executed"
},
{
"fieldName": "redirect_url"
},
{
"fieldName": "new_field"
}
]
}
},
"enabled": true
}
{code}
{noformat}
apache drill> select * from dfs.root.`2021` limit 5;
{noformat}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
