Date Issue in EL

Elastic Stack Logstash
1

While loading data from table in oracle to EL Search, date column in oracle is stored as string EL Search . how do I fix this.
select.sql=SELECT * FROM us_wm_space.planogram_view_log

   input {
      jdbc {
        jdbc_driver_library => "/home/app/oracle_jdbc/ojdbc6-11.2.0.3.0.jar"
        jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
        jdbc_connection_string => "jdbc:oracle:thin:@//88888888:1526/spusxprd_service"
        jdbc_user => "*********"
        jdbc_password => "************"
        # will execute on the 0th minute of every hour every day
        # schedule => "0 * * * *"
        statement_filepath => "select.sql"
        #jdbc_paging_enabled => "true"
        #jdbc_page_size => "1"
      }

}

output {
elasticsearch {
protocol => http
index =>"planogramviews"
document_type => "planogramview"
document_id => "%{planogram_id},%{store_nbr},%{view_ts}"
host => "10.117.144.227"

    }

}

Any help is apprecaited

2

Perhaps you should use a date filter to parse the field into an ISO8601 that ES will recognize as a date? Or modify the query to format the column in a way that ES recognizes as a date?

3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.