search

NLPchina / elasticsearch-sql

Use SQL to query Elasticsearch
Apache License 2.0
6.99k stars 1.54k forks source link

connect to remote elasticsearch server #58

Open sim1st opened 9 years ago

sim1st commented 9 years ago

this program is worked well as a plugin in ES 1.4.x

but I want to this program to local to remote server.

so I opened it in Eclipse, and setting host to remote server, but doesn't work. with "None of the configured nodes are available: []" error(exception)

Is it not possible to connect to remote server with this program?

Or possible by doing some customizing

Please tell me,

Thanks

omershelef commented 9 years ago

Currently there is no way to use this plugin as a local library easily. For now you can use this as a library by creating TransportClient, pass it to SearchDao constructor and call explain method. You can look at the tests code to see example of how to do it. The SearchDao created in MainTestSuite and you can look at how to use it in QueryTest. The tests run in the travis CI locally without Elasticsearch-sql plugin installed, so this should work.

Maybe a more easy local API will be developed.

And just from curiosity, why you prefer not to install the plugin?

sim1st commented 9 years ago

Long time no see.

I want to handle result data.

but as a plugin, I just can see result as table.

Could you explain where the code that printing data set in plugin web page is?

omershelef commented 9 years ago

The code is in query.js The results is parsed in two different ways, DefaultQueryResultHandler parsed standard queries. and AggregationQueryResultHandler is parsing aggregations result and will be used when the query contains 'GROUP BY' clause.

Good luck!