Hi all
I am getting case Insensitive Data in Hits(SearchResponse ) even I am having Case Sensitive Data in Elasticsearch index
like
index contains {
customerName :"David",
departmentName:"IT",
applicantName:"Raju"}
but I am getting Hits as
customername :"David",
departmentname:"IT",
applicantname:"Raju"}
Could you provide a full recreation script as described in About the Elasticsearch category. It will help to better understand what you are doing. Please, try to keep the example as simple as possible.
A full reproduction script is something anyone can copy and paste in Kibana dev console, click on the run button to reproduce your use case. It will help readers to understand, reproduce and if needed fix your problem. It will also most likely help to get a faster answer.
Hi ,
I am using 7.3.2 version of ES and I am indexing data using Logstash 7.3.2 with lowercase_column_names => false as property
and the data in index is like eg: "companyName" : "CA"
but in search response I am getting "companyname" : "CA" in hits
**Did you repeat my experiment? Did you get the same results? This helps set a baseline.**
no as I am indexing data using logstash .so I went this approach.
**Can you please provide the mapping? of your index... please provide that.**
I am not using any mapping file while indexing ,want to index DB data directly to ES
Here is my sample config file .
input {
jdbc {
jdbc_connection_string => "jdbc:mysql://localhost:3306/testdb"
# The user we wish to execute our statement as
jdbc_user => "root"
jdbc_password => "123456"
# The path to our downloaded jdbc driver
jdbc_driver_library => "/home/comp/Downloads/mysql-connector-java-5.1.38.jar"
jdbc_driver_class => "com.mysql.jdbc.Driver"
# our query
lowercase_column_names => false
statement => "SELECT * FROM testtable"
}
}
output {
stdout { codec => json_lines }
elasticsearch {
"hosts" => "localhost:9200"
"index" => "test-migrate"
}
}
my table table looks like this
id companyname applicantName accNumberCode
21 CA DAVID DA887
22 CA Kevin KE888
I am getting like this in response
{
"_index": "test-migrate",
"_type": "_doc",
"_id": "21",
"_score": 1,
"_source": {
"companyname" : "CA",
"applicantname" : "David",
"accnumbercode" : "DA(887"
"@version": "1",
"@timestamp": "2016-07-10T10:36:43.685Z"
}
}
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.