Skip to content

"type_mapping" format date time doesn't work??? #983

Open
@YangFangXin

Description

@YangFangXin

Hello
my Configuration like this:

`echo '{
"type" : "jdbc",
"jdbc" : {
"elasticsearch.cluster":"my-application",
"url" : "jdbc:mysql://10.179.38.6:3306/mammon",
"user" : "root",
"password" : "123456",
"sql" : "select * from '${table}'",
"elasticsearch" : {
"host" : "'${esHost}'",
"port" : "'${esTcpPort}'"
},
"index" : "'${esIndex}'",
"type" : "'${table}'",
"type_mapping":{
"'${table}'":{
"properties": {
"to_account_time": {
"type": "date",
"format" : "yyyy-MM-dd HH:mm:ss"
},
"created_at": {
"type": "date",
"format" : "yyyy-MM-dd HH:mm:ss"
},
"updated_at": {
"type": "date",
"format" : "yyyy-MM-dd HH:mm:ss"
}
}
}
}

}

}' | java
-cp "${lib}/*"
-Dlog4j.configurationFile=${bin}/log4j2.xml
org.xbib.tools.Runner
org.xbib.tools.JDBCImporter`

i want to format this three date Type,but it doesn't worked,still
"format" : "strict_date_optional_time||epoch_millis"

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions