[
https://issues.apache.org/jira/browse/CALCITE-1994?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16209142#comment-16209142
]
Christian Beikov commented on CALCITE-1994:
-------------------------------------------
That's because you need at least an empty user config like
{noformat}
"userConfig": "{}"
{noformat}
When trying to reproduce this, I went through a lot of trouble regarding
classpath problems. The problems unfortunately won't stop if you specify the
user config correctly.
The next problem will be regarding some missing netty methods because of
mutliple netty versions being on the classpath.
All in all, I'm not sure it is so easy to get sqlline to work correctly for
elasticsearch. The sqlline scripts require a major overhaul to make this work.
What do you say [~julianhyde]?
> Elasticsearch5 not working using sqlline
> ----------------------------------------
>
> Key: CALCITE-1994
> URL: https://issues.apache.org/jira/browse/CALCITE-1994
> Project: Calcite
> Issue Type: Bug
> Components: elasticsearch-adapter
> Affects Versions: 1.13.0
> Reporter: Kunwar Deep Singh
> Assignee: Julian Hyde
> Priority: Critical
> Original Estimate: 24h
> Remaining Estimate: 24h
>
> I have been trying to connect to elasticsearch 5.1.1 server using sqlline.
> The following error is generated.
> The following is the error:
> {noformat}
> java.lang.NoSuchMethodError:
> org.elasticsearch.transport.client.PreBuiltTransportClient.addPlugins(Ljava/util/Collectio
> n;Ljava/util/Collection;)Ljava/util/Collection;
> at
> org.elasticsearch.transport.client.PreBuiltTransportClient.<init>(PreBuiltTransportClient.java:130)
> at
> org.elasticsearch.transport.client.PreBuiltTransportClient.<init>(PreBuiltTransportClient.java:116)
> at
> org.elasticsearch.transport.client.PreBuiltTransportClient.<init>(PreBuiltTransportClient.java:106)
> at
> org.apache.calcite.adapter.elasticsearch5.Elasticsearch5Schema.open(Elasticsearch5Schema.java:119)
> at
> org.apache.calcite.adapter.elasticsearch5.Elasticsearch5Schema.<init>(Elasticsearch5Schema.java:74)
> at
> org.apache.calcite.adapter.elasticsearch5.Elasticsearch5SchemaFactory.create(Elasticsearch5SchemaFactory.java:56)
> at org.apache.calcite.model.ModelHandler.visit(ModelHandler.java:269)
> at
> org.apache.calcite.model.JsonCustomSchema.accept(JsonCustomSchema.java:45)
> at org.apache.calcite.model.ModelHandler.visit(ModelHandler.java:195)
> at org.apache.calcite.model.ModelHandler.<init>(ModelHandler.java:87)
> at org.apache.calcite.jdbc.Driver$1.onConnectionInit(Driver.java:104)
> at
> org.apache.calcite.avatica.UnregisteredDriver.connect(UnregisteredDriver.java:139)
> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:156)
> at sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:204)
> at sqlline.Commands.connect(Commands.java:1095)
> at sqlline.Commands.connect(Commands.java:1001)
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
> at
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:498)
> at
> sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:38)
> at sqlline.SqlLine.dispatch(SqlLine.java:791)
> at sqlline.SqlLine.begin(SqlLine.java:668)
> at sqlline.SqlLine.start(SqlLine.java:373)
> at sqlline.SqlLine.main(SqlLine.java:265)
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
