My conf file code as follows
for removing records i written below code as follows
input {
jdbc {
jdbc_driver_library => "D:\mysql-connector-java-5.1.44\mysql-connector-java-5.1.44\mysql-connector-java-5.1.44-bin.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
jdbc_connection_string => "jdbc:mysql://localhost:3306/sample"
jdbc_user => "root"
jdbc_password => "root"
jdbc_fetch_size => 10000
schedule => "* * * * *"
statement => "SELECT * from sample"
#codec => "json"
}
}
filter {
fingerprint {
source => "RRH_MR_NUM"
target => "[@metadata][fingerprint]"
method => "MURMUR3"
}
}
output {
elasticsearch {
hosts => ["localhost:9200"]
index => "clinical"
document_id => "%{[@metadata][fingerprint]}"
}
stdout { codec => rubydebug }
}
when i see the output in kibana as follows
mcs_crt_uid:1104448 cpa_addr_1:SECTOR - III/E rrh_mr_num:3442011 cpa_pin_code:827003 rrh_pat_sex:Male mcs_crt_dt:2015-04-11T10:40:00.000Z @timestamp:2017-12-20T04:03:30.420Z cpa_country_cd:INDIA cpa_state_cd:JHARK @version:1 rrh_regn_dt:2015-04-09T18:30:00.000Z rrh_first_name:BISHNU LAL MAHTO r rh_pat_dob:1959-04-09T18:30:00.000Z mcs_case_summary:Medical Record No. : 3442011Patient Name : MR. BISHNU LAL MAHTO Age : 56 Year(s)Sex : maleAddress : SECTOR - III/E, A. NO. - 032, BOKARO STEEL CITY, , BOKARO STEEL CITY,JHARKHAND, INDIA - 827003.Report Date : 2015-04-11 Optometrist : Start Time : Consultant : Dr.DURGA PRIYADARSHINI S_score:1
when i click the refresh button in top right side of kibana discover record refresh in the above record but count (hits) shows 1 only.
when i click refresh button count shows one only. but when i click refresh button records changing.
what is the mistake in my above CONF file code above.
please let me know