1.4.1版本,使用报错

[bigbo]

Error: {"error":"RemoteTransportException[[Novs][inet[localhost:9300]][indices/create]]; nested: InvalidIndexNameException[[_sql] Invalid index name [sql], must not start with '']; ","status":400}

另外一个es节点上报:
{"error":"NoClassDefFoundError[org/durid/sql/ast/statement/SQLSelectQuery]; nested: ClassNotFoundException[org.durid.sql.ast.statement.SQLSelectQuery]; ","status":500}

es版本为:1.3.6

页面上我填写的是本机的9200啊,不知道为什么网络请求是9300.语句就是readme上的示例.

[ansjsun]

1.3.6 尝试使用1.3.2的版本

[bigbo]

@ansjsun 请问,以后这个插件有更新嘛?能支持到最新的ES版本不?

[ansjsun]

插件版本。。。是和es版本一致。

[bigbo]

@ansjsun ,我尝试了用1.3.2版本的插件,结果还是报错啊:
Error: {"error":"NoClassDefFoundError[org/durid/sql/ast/statement/SQLSelectQuery]; nested: ClassNotFoundException[org.durid.sql.ast.statement.SQLSelectQuery]; ","status":500}
能指点下什么原因嘛?

[ansjsun]

把你的sql语句发出来。。。。

[bigbo]

SELECT * FROM kibana-init limit 10 ;

[ansjsun]

好像表名称不能有减号。 sql解析会认为是运算符

[bigbo]

那表名有-号的话这种情况怎么写sql语句?

[ansjsun]

不知道饿。。。加个
SELECT * FROM "kibana-init" limit 10 试试

[dpj2010]

Elasticsearch 2.3.1

./bin/plugin install https://github.com/NLPchina/elasticsearch-sql/releases/download/2.3.1.0/elasticsearch-sql-2.3.1.0.zip
After doing this, you need to restart the Elasticsearch server. Otherwise you may get errors like Invalid index name [sql], must not start with '']; ","status":400}.

需要重启