No handler found for uri [/_sql?sql=select%20*%20from%20distribution%20limit%2010] and method [GET] about elasticsearch-sql HOT 19 CLOSED

what your es version ? i used it in 1.3.2 , and make sure it installed ,, in this result . the plugin not workd

from elasticsearch-sql.

I am using 1.3.2.

from elasticsearch-sql.

1. see your plugin dir is empyt?
   .if empty down http://maven.nlpcn.org/org/nlpcn/elasticsearch-sql/0.1/elasticsearch-sql-0.1.jar to plugin/sql dir

from elasticsearch-sql.

Put it there:

ls -l /usr/share/elasticsearch/plugins/sql/
total 52
-rw-r--r--. 1 root root 45009 Sep 16 12:48 elasticsearch-sql-0.1.jar
drwxr-xr-x. 3 root root 4096 Sep 18 12:29 META-INF
drwxr-xr-x. 3 root root 4096 Sep 18 12:29 org

Makes nodifference.

from elasticsearch-sql.

hello i am very very very sorry .. i package jar is bad , now i fix it ..

now you shoud

1. remove plug/sql
   2../bin/plugin -u http://maven.nlpcn.org/org/nlpcn/elasticsearch-sql/0.1/elasticsearch-sql-0.1.jar --install sql

you see the plug/sql like this

total 8
drwxr-xr-x 7 ansj staff 238 Sep 19 12:22 ./
drwxr-xr-x 4 ansj staff 136 Sep 19 12:22 ../
drwxr-xr-x 8 ansj staff 272 Sep 19 12:22 META-INF/
drwxr-xr-x 4 ansj staff 136 Sep 19 12:22 com/
-rw-r--r-- 1 ansj staff 45 Sep 19 12:22 es-plugin.properties
drwxr-xr-x 6 ansj staff 204 Sep 19 12:22 org/
drwxr-xr-x 3 ansj staff 102 Sep 19 12:22 support/

good luck

from elasticsearch-sql.

No luck :-(
[root~]# /usr/share/elasticsearch/bin/plugin -r sql
-> Removing sql...
Removed sql
[root~]# /usr/share/elasticsearch/bin/plugin -DproxyHost=localhost -DproxyPort=18081 -u http://maven.nlpcn.org/org/nlpcn/elasticsearch-sql/0.1/elasticsearch-sql-0.1.jar --install sql
-> Installing sql...
Trying http://maven.nlpcn.org/org/nlpcn/elasticsearch-sql/0.1/elasticsearch-sql-0.1.jar...
Downloading ...........DONE

[root@nlvora213 ~]# ls -l /usr/share/elasticsearch/plugins/sql
total 8
drwxr-xr-x. 3 root root 4096 Sep 19 11:09 META-INF
drwxr-xr-x. 3 root root 4096 Sep 19 11:09 org

[root@nlvora213 ~]# find /usr/share/elasticsearch/plugins/sql

/usr/share/elasticsearch/plugins/sql
/usr/share/elasticsearch/plugins/sql/META-INF
/usr/share/elasticsearch/plugins/sql/META-INF/maven
/usr/share/elasticsearch/plugins/sql/META-INF/maven/org.nlpcn
/usr/share/elasticsearch/plugins/sql/META-INF/maven/org.nlpcn/elasticsearch-sql
/usr/share/elasticsearch/plugins/sql/META-INF/maven/org.nlpcn/elasticsearch-sql/pom.properties
/usr/share/elasticsearch/plugins/sql/META-INF/maven/org.nlpcn/elasticsearch-sql/pom.xml
/usr/share/elasticsearch/plugins/sql/META-INF/MANIFEST.MF
/usr/share/elasticsearch/plugins/sql/org
/usr/share/elasticsearch/plugins/sql/org/nlpcn
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/exception
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/exception/SqlParseException.class
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/domain
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/domain/Where$CONN.class
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/domain/Paramer.class
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/domain/Condition.class
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/domain/Where.class
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/domain/KVValue.class
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/domain/Field.class
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/domain/SearchResult.class
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/domain/Order.class
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/domain/Condition$OPEAR.class
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/domain/MethodField.class
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/domain/Index.class
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/domain/Select.class
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/Util.class
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/SearchDao.class
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/query
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/query/AggregationQuery.class
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/query/DefaultQuery.class
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/query/Query.class
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/query/maker
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/query/maker/Maker$1.class
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/query/maker/Maker.class
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/query/maker/FilterMaker.class
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/query/maker/QueryMaker.class
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/query/maker/AggMaker.class
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/parse
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/parse/SqlParser.class
/usr/share/elasticsearch/plugins/sql/org/nlpcn/es4sql/parse/FieldMaker.class

from elasticsearch-sql.

it log lose some config file

you try this

1.down http://maven.nlpcn.org/org/nlpcn/elasticsearch-sql/0.1/elasticsearch-sql-0.1.jar

1. mkdir plugin/sql
   cp elasticsearch-sql-0.1.jar plugin/sql

if now it not work ..

use jar xvf elasticsearch-sql-0.1.jar to plugin/sql

make sure you dir like this

[ansj@sunmatoMacBook-Air-4 sql]$ll
total 8
drwxr-xr-x 7 ansj staff 238 Sep 19 12:22 ./
drwxr-xr-x 4 ansj staff 136 Sep 19 12:22 ../
drwxr-xr-x 8 ansj staff 272 Sep 19 12:22 META-INF/
drwxr-xr-x 4 ansj staff 136 Sep 19 12:22 com/
-rw-r--r-- 1 ansj staff 45 Sep 19 12:22 es-plugin.properties
drwxr-xr-x 6 ansj staff 204 Sep 19 12:22 org/
drwxr-xr-x 3 ansj staff 102 Sep 19 12:22 support/

from elasticsearch-sql.

That was what I just was doing :-)
It is at least not saying that no handler is found for _sql ..

Now I get : {
"error": "ClassCastException[com.alibaba.druid.sql.ast.expr.SQLCharExpr cannot be cast to com.alibaba.druid.sql.ast.expr.SQLQueryExpr]",
"status": 500
}

from elasticsearch-sql.

your sql is err i think ..

chould you give me you sql ?

from elasticsearch-sql.

http://161.89.52.214:9200/_sql?sql='select * from * limit 10'

from elasticsearch-sql.

没有'号吧' 还有不能这么select 最新的

应该

select * from 你索引的名称 limit 10 ;

from elasticsearch-sql.

you try

select * from [your index name] limit 10 ;

from elasticsearch-sql.

This returns 10 documents:
curl -XGET 'http://192.168.1.213:9200/contributions/_search?pretty'

This:
curl -XGET 'http://192.168.1.213:9200/_sql/_explain?sql="select * from contributions limit 10"'
This seems to be like an error connecting to http://161.89.52.213:9200/_sql?sql='select * from contributions limit 10'. The response status was 0.
Check out the W3C XMLHttpRequest Level 2 spec for more details about when this happens.

I just noticed that the elasticsearch logfile show a java stack dump:
2014-09-22 18:53:43,115][WARN ][http.netty ] [Stanley] Caught exception while handling client http traffic, closing connection [id: 0x26f51725, /192.168.1.213:31493 :> /192.168.1.213:9200]
java.lang.IllegalArgumentException: invalid version format: (X86_64-UNKNOWN-LINUX-GNU) LIBCURL/7.19.7 NSS/3.13.1.0 ZLIB/1.2.3 LIBIDN/1.18 LIBSSH2/1.2.2
at org.elasticsearch.common.netty.handler.codec.http.HttpVersion.(HttpVersion.java:102)
at org.elasticsearch.common.netty.handler.codec.http.HttpVersion.valueOf(HttpVersion.java:62)
at org.elasticsearch.common.netty.handler.codec.http.HttpRequestDecoder.createMessage(HttpRequestDecoder.java:75)
at org.elasticsearch.common.netty.handler.codec.http.HttpMessageDecoder.decode(HttpMessageDecoder.java:189)
at org.elasticsearch.common.netty.handler.codec.http.HttpMessageDecoder.decode(HttpMessageDecoder.java:101)
at org.elasticsearch.common.netty.handler.codec.replay.ReplayingDecoder.callDecode(ReplayingDecoder.java:500)
at org.elasticsearch.common.netty.handler.codec.replay.ReplayingDecoder.cleanup(ReplayingDecoder.java:554)
at org.elasticsearch.common.netty.handler.codec.frame.FrameDecoder.channelDisconnected(FrameDecoder.java:365)
at org.elasticsearch.common.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:102)
at org.elasticsearch.common.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
at org.elasticsearch.common.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791)
at org.elasticsearch.common.netty.OpenChannelsHandler.handleUpstream(OpenChannelsHandler.java:74)
at org.elasticsearch.common.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
at org.elasticsearch.common.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559)
at org.elasticsearch.common.netty.channel.Channels.fireChannelDisconnected(Channels.java:396)
at org.elasticsearch.common.netty.channel.socket.nio.AbstractNioWorker.close(AbstractNioWorker.java:360)
at org.elasticsearch.common.netty.channel.socket.nio.NioServerSocketPipelineSink.handleAcceptedSocket(NioServerSocketPipelineSink.java:81)
at org.elasticsearch.common.netty.channel.socket.nio.NioServerSocketPipelineSink.eventSunk(NioServerSocketPipelineSink.java:36)
at org.elasticsearch.common.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendDownstream(DefaultChannelPipeline.java:779)
at org.elasticsearch.common.netty.handler.codec.oneone.OneToOneEncoder.handleDownstream(OneToOneEncoder.java:54)
at org.elasticsearch.common.netty.channel.DefaultChannelPipeline.sendDownstream(DefaultChannelPipeline.java:591)
at org.elasticsearch.common.netty.channel.DefaultChannelPipeline.sendDownstream(DefaultChannelPipeline.java:582)
at org.elasticsearch.common.netty.channel.Channels.close(Channels.java:812)
at org.elasticsearch.common.netty.channel.AbstractChannel.close(AbstractChannel.java:197)
at org.elasticsearch.http.netty.NettyHttpServerTransport.exceptionCaught(NettyHttpServerTransport.java:310)
at org.elasticsearch.http.netty.HttpRequestHandler.exceptionCaught(HttpRequestHandler.java:50)
at org.elasticsearch.common.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:112)
at org.elasticsearch.common.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
at org.elasticsearch.common.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791)
at org.elasticsearch.common.netty.channel.SimpleChannelUpstreamHandler.exceptionCaught(SimpleChannelUpstreamHandler.java:153)
at org.elasticsearch.common.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:112)
at org.elasticsearch.common.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
at org.elasticsearch.common.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791)
at org.elasticsearch.common.netty.handler.codec.frame.FrameDecoder.exceptionCaught(FrameDecoder.java:377)
at org.elasticsearch.common.netty.channel.SimpleChannelUpstreamHandler.handleUpstream(SimpleChannelUpstreamHandler.java:112)
at org.elasticsearch.common.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
at org.elasticsearch.common.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791)
at org.elasticsearch.common.netty.OpenChannelsHandler.handleUpstream(OpenChannelsHandler.java:74)
at org.elasticsearch.common.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
at org.elasticsearch.common.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559)
at org.elasticsearch.common.netty.channel.Channels.fireExceptionCaught(Channels.java:525)
at org.elasticsearch.common.netty.channel.AbstractChannelSink.exceptionCaught(AbstractChannelSink.java:48)
at org.elasticsearch.common.netty.channel.DefaultChannelPipeline.notifyHandlerException(DefaultChannelPipeline.java:658)
at org.elasticsearch.common.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:566)
at org.elasticsearch.common.netty.channel.DefaultChannelPipeline$DefaultChannelHandlerContext.sendUpstream(DefaultChannelPipeline.java:791)
at org.elasticsearch.common.netty.OpenChannelsHandler.handleUpstream(OpenChannelsHandler.java:74)
at org.elasticsearch.common.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:564)
at org.elasticsearch.common.netty.channel.DefaultChannelPipeline.sendUpstream(DefaultChannelPipeline.java:559)
at org.elasticsearch.common.netty.channel.Channels.fireMessageReceived(Channels.java:268)
at org.elasticsearch.common.netty.channel.Channels.fireMessageReceived(Channels.java:255)
at org.elasticsearch.common.netty.channel.socket.nio.NioWorker.read(NioWorker.java:88)
at org.elasticsearch.common.netty.channel.socket.nio.AbstractNioWorker.process(AbstractNioWorker.java:108)
at org.elasticsearch.common.netty.channel.socket.nio.AbstractNioSelector.run(AbstractNioSelector.java:318)
at org.elasticsearch.common.netty.channel.socket.nio.AbstractNioWorker.run(AbstractNioWorker.java:89)
at org.elasticsearch.common.netty.channel.socket.nio.NioWorker.run(NioWorker.java:178)
at org.elasticsearch.common.netty.util.ThreadRenamingRunnable.run(ThreadRenamingRunnable.java:108)
at org.elasticsearch.common.netty.util.internal.DeadLockProofWorker$1.run(DeadLockProofWorker.java:42)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:603)
at java.lang.Thread.run(Thread.java:722)

from elasticsearch-sql.

open your chrome or iE

visit

http://192.168.1.213:9200/_sql?sql=select%20*%20from%20contributions%20limit%2010

what you see ?

from elasticsearch-sql.

{
"error": "CreationException[Guice creation errors:\n\n1) No implementation for org.elasticsearch.cluster.ClusterService was bound.\n while locating org.elasticsearch.cluster.ClusterService\n for parameter 1 at org.xbib.elasticsearch.action.river.jdbc.state.RiverStateService.(Unknown Source)\n at unknown\n\n1 error]",
"status": 500
}

from elasticsearch-sql.

i am sorry ..in my elasticsearch it work ok !

i did not know this error !

and i did not know why action is "org.xbib.elasticsearch.action"

from elasticsearch-sql.

It seems to conflict with the river-csv plugin

from elasticsearch-sql.

I removed plugins : jdbc lang-python repository-hdfs
Now it is working
So somehow your plugin interferes with the others or the other way around.

from elasticsearch-sql.

. i am sorry to that

my plugin is only coven sql to elasticsearch query ...so you can use /_sql/_explain?sql=...　to get Elasticsearch query .　and use it to query ...

or in you project add elasticsearch-sql.jar to query ..you see my example ...

https://github.com/NLPchina/elasticsearch-sql/tree/master/src/test/java/org/nlpcn/es4sql

good luck

from elasticsearch-sql.