Searching data


(Tim Hidalgo) #1

Trying out Elasticsearch for possible use in our projects.

I got through the installation and went down the route of using the jdbc river so that I can just quickly create some indexes to see how things will work.

I created the river with the following:

{

"type":"jdbc",

"schedule" : "0 0-59 0-23 ? * *",

"jdbc": {

"driver":"com.microsoft.sqlserver.jdbc.SQLServerDriver",

"url":"jdbc:sqlserver://127.0.0.1;databaseName=mydatabase",

"user":"myusername","password":"mypassword",

"sql":"select * from dbo.mytableorview",

"index":"myindexname",

"type":"mytypename"

}

That seemed to go ok. I then sent

http://localhost:9200/_count?pretty' -d '

and the results are:

{
"count": 57164,
"_shards": {
"total": 8,
"successful": 8,
"failed": 0
}
}

OK, so it seems like some documents were imported via the river.

Now I'm trying to search anything using Sense and the following command:

GET myindexname/mytypename/_search

and I receive:

{
"took": 1,
"timed_out": false,
"_shards": {
"total": 5,
"successful": 5,
"failed": 0
},
"hits": {
"total": 0,
"max_score": null,
"hits": []
}
}

can anyone shed some light on where I'm going wrong?

Thanks


(system) #2