input {
  jdbc {
    jdbc_driver_library => "D:\elastic\logstash\mysql-connector-j-9.0.0.jar"
    jdbc_driver_class => "com.mysql.cj.jdbc.Driver"
    jdbc_connection_string => "jdbc:mysql://esghosts.com:3306/esgsadmin_eturk"
    jdbc_user => "esgsadmin_eturk"
    jdbc_password => "p4kc7bzcnxsz"
    schedule => "* * * * *"
    statement => "select taxonomy_term_campaigns.id as taxonomy_term_campaigns_id,taxonomy_term_campaigns.image as taxonomy_term_campaigns_image,taxonomy_term_campaigns.link as taxonomy_term_campaigns_link,taxonomy_term_campaigns.start_at as taxonomy_term_campaigns_start_at,taxonomy_term_campaigns.end_at as taxonomy_term_campaigns_end_at,taxonomy_term_campaigns.created_at as taxonomy_term_campaigns_created_at,taxonomy_term_campaigns.updated_at as taxonomy_term_campaigns_updated_at,taxonomy_terms.id as taxonomy_terms_id,taxonomy_terms.name as taxonomy_terms_name,taxonomy_terms.slider_image as taxonomy_terms_slider_image,taxonomy_terms.slug as taxonomy_terms_slug,taxonomy_terms.column as taxonomy_terms_column,taxonomy_terms.status as taxonomy_terms_status,taxonomy_terms.parent_term as taxonomy_terms_parent_term,taxonomy_terms.sort as taxonomy_terms_sort,taxonomy_terms.created_at as taxonomy_terms_created_at,taxonomy_terms.updated_at as taxonomy_terms_updated_at from taxonomy_term_campaigns  left join taxonomy_terms on taxonomy_terms.id=taxonomy_term_campaigns.taxonomy_term_id"
    use_column_value => true
    tracking_column => "select taxonomy_term_campaigns.id as taxonomy_term_campaigns_id,taxonomy_term_campaigns.image as taxonomy_term_campaigns_image,taxonomy_term_campaigns.link as taxonomy_term_campaigns_link,taxonomy_term_campaigns.start_at as taxonomy_term_campaigns_start_at,taxonomy_term_campaigns.end_at as taxonomy_term_campaigns_end_at,taxonomy_term_campaigns.created_at as taxonomy_term_campaigns_created_at,taxonomy_term_campaigns.updated_at as taxonomy_term_campaigns_updated_at,taxonomy_terms.id as taxonomy_terms_id,taxonomy_terms.name as taxonomy_terms_name,taxonomy_terms.slider_image as taxonomy_terms_slider_image,taxonomy_terms.slug as taxonomy_terms_slug,taxonomy_terms.column as taxonomy_terms_column,taxonomy_terms.status as taxonomy_terms_status,taxonomy_terms.parent_term as taxonomy_terms_parent_term,taxonomy_terms.sort as taxonomy_terms_sort,taxonomy_terms.created_at as taxonomy_terms_created_at,taxonomy_terms.updated_at as taxonomy_terms_updated_at from taxonomy_term_campaigns  left join taxonomy_terms on taxonomy_terms.id=taxonomy_term_campaigns.taxonomy_term_id_id"
    jdbc_paging_enabled => "true"
    jdbc_page_size => 10000
  }
}
 filter {
 

    mutate  {
          
          rename=>  {
          
            }
    }
}

output {
  elasticsearch {
     hosts => "localhost:9200"
     index => "taxonomy_term_campaigns"
     user => "elastic"
     password => "123456"
     document_id => "%{taxonomy_term_campaigns_id}"
     ssl_enabled => true
     ssl_verification_mode => "none"
  }

}