Hi,
I have a HBase database and I use phoenix as a RDBMS skin over it.
Now I am trying to retrieve those data via ElasticSearch using the
river-jdbc plugin.
I am using the following:-
1). elasticsearch-1.4.0
2). elasticsearch-river-jdbc-1.4.0.3.Beta1
3). phoenix-3.0.0-incubating-client
4). HBase 0.94.1
But I keep getting the following exception when I try to create a river.
[2014-12-11 12:34:48,957][INFO ][org.apache.zookeeper.ZooKeeper] Session:
0x14a380290fe001d closed
[2014-12-11 12:34:48,957][INFO ][org.apache.zookeeper.ClientCnxn]
EventThread shut down
[2014-12-11 12:34:49,022][ERROR][river.jdbc.SimpleRiverSource] while
opening read connection: jdbc:phoenix:localhost:2181 null
java.sql.SQLFeatureNotSupportedException
at
org.apache.phoenix.jdbc.PhoenixConnection.setReadOnly(PhoenixConnection.java:587)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.getConnectionForReading(SimpleRiverSource.java:226)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.execute(SimpleRiverSource.java:376)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverSource.fetch(SimpleRiverSource.java:320)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.fetch(SimpleRiverFlow.java:209)
at
org.xbib.elasticsearch.river.jdbc.strategy.simple.SimpleRiverFlow.execute(SimpleRiverFlow.java:139)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.request(RiverPipeline.java:88)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(RiverPipeline.java:66)
at
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline.call(RiverPipeline.java:30)
at java.util.concurrent.FutureTask.run(FutureTask.java:262)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
at java.lang.Thread.run(Thread.java:745)
[2014-12-11 12:34:49,432][INFO ][river.jdbc.RiverMetrics ] pipeline
org.xbib.elasticsearch.plugin.jdbc.RiverPipeline@700dd36f is running: river
jdbc/myriver metrics: 0 rows, 0.0 mean, (0.0 0.0 0.0), ingest metrics:
elapsed 9 seconds, 0.0 bytes bytes, 0.0 bytes avg, 0 MB/s
Please help!
--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/5d00da83-8899-4555-bd96-b6d067742ced%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.