Getting SQLFeatureNotSupportedException while connecting Hbase phoenix via river-jdbc

Elastic Stack Elasticsearch
1

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 elasticsearch+unsubscribe@googlegroups.com.
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.

2

This is a bug in Apache Phoenix. As long as this bug exists, Apache Phoenix
is not supported by JDBC plugin.

Jörg

On Thu, Dec 11, 2014 at 8:19 AM, cto@TCS rimita.mitra6@gmail.com wrote:

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 elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/5d00da83-8899-4555-bd96-b6d067742ced%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/5d00da83-8899-4555-bd96-b6d067742ced%40googlegroups.com?utm_medium=email&utm_source=footer
.
For more options, visit https://groups.google.com/d/optout.

--
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 elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAKdsXoGkpSauUKSmnAGHss9GW7ToMtvd%3DMMBd2Ap4jN5tn1HTQ%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.

3

Thank you so much

On Thursday, December 11, 2014 12:49:49 PM UTC+5:30, cto@TCS wrote:

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 elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/0fff1fbc-c05e-4479-b095-d0d345b74512%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

4

Rimita, this was fixed in phoenix 3.1.0, pls follow these instructions:
http://lessc0de.github.io/connecting_hbase_to_elasticsearch.html

On Thu, Dec 11, 2014 at 3:53 AM, cto@TCS rimita.mitra6@gmail.com wrote:

Thank you so much

On Thursday, December 11, 2014 12:49:49 PM UTC+5:30, cto@TCS wrote:

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 elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/0fff1fbc-c05e-4479-b095-d0d345b74512%40googlegroups.com
https://groups.google.com/d/msgid/elasticsearch/0fff1fbc-c05e-4479-b095-d0d345b74512%40googlegroups.com?utm_medium=email&utm_source=footer
.

For more options, visit https://groups.google.com/d/optout.

--
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 elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/CAOtKWX7e%2Br6k1ux2oY1%3DFbPapv-ibXj2chn_YZDX0d934bmX1w%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.