# Getting SQLFeatureNotSupportedException while connecting Hbase phoenix via river-jdbc **URL:** \ **Category:** Elasticsearch\ **Created:** [December 11, 2014, 7:19am UTC](https://discuss.elastic.co/t/getting-sqlfeaturenotsupportedexception-while-connecting-hbase-phoenix-via-river-jdbc/21204 "2014-12-11T07:19:49Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![cto](https://avatars.discourse-cdn.com/v4/letter/c/5daacb/32.png) [@cto](https://discuss.elastic.co/u/cto)\ **Post date:** [December 11, 2014, 7:19am UTC](https://discuss.elastic.co/t/getting-sqlfeaturenotsupportedexception-while-connecting-hbase-phoenix-via-river-jdbc/21204/1 "2014-12-11T07:19:49Z")
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](mailto: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). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![jprante](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/jprante/32/44941_2.png) [@jprante](https://discuss.elastic.co/u/jprante)\ **Post date:** [December 11, 2014, 8:18am UTC](https://discuss.elastic.co/t/getting-sqlfeaturenotsupportedexception-while-connecting-hbase-phoenix-via-river-jdbc/21204/2 "2014-12-11T08:18:25Z")
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](mailto: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](mailto: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) > [https://groups.google.com/d/msgid/elasticsearch/5d00da83-8899-4555-bd96-b6d067742ced%40googlegroups.com?utm\_medium=email&utm\_source=footer](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](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](mailto:elasticsearch+unsubscribe@googlegroups.com). To view this discussion on the web visit [https://groups.google.com/d/msgid/elasticsearch/CAKdsXoGkpSauUKSmnAGHss9GW7ToMtvd%3DMMBd2Ap4jN5tn1HTQ%40mail.gmail.com](https://groups.google.com/d/msgid/elasticsearch/CAKdsXoGkpSauUKSmnAGHss9GW7ToMtvd%3DMMBd2Ap4jN5tn1HTQ%40mail.gmail.com). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![cto](https://avatars.discourse-cdn.com/v4/letter/c/5daacb/32.png) [@cto](https://discuss.elastic.co/u/cto)\ **Post date:** [December 11, 2014, 8:53am UTC](https://discuss.elastic.co/t/getting-sqlfeaturenotsupportedexception-while-connecting-hbase-phoenix-via-river-jdbc/21204/3 "2014-12-11T08:53:03Z")
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](mailto: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). For more options, visit [https://groups.google.com/d/optout](https://groups.google.com/d/optout). ---
**Author:** ![Alex\_Kamil](https://avatars.discourse-cdn.com/v4/letter/a/d9b06d/32.png) [@Alex\_Kamil](https://discuss.elastic.co/u/Alex_Kamil)\ **Post date:** [December 11, 2014, 7:25pm UTC](https://discuss.elastic.co/t/getting-sqlfeaturenotsupportedexception-while-connecting-hbase-phoenix-via-river-jdbc/21204/4 "2014-12-11T19:25:01Z")
Rimita, this was fixed in phoenix 3.1.0, pls follow these instructions: [http://lessc0de.github.io/connecting\_hbase\_to\_elasticsearch.html](http://lessc0de.github.io/connecting_hbase_to_elasticsearch.html) On Thu, Dec 11, 2014 at 3:53 AM, cto@TCS [rimita.mitra6@gmail.com](mailto: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](mailto: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) > [https://groups.google.com/d/msgid/elasticsearch/0fff1fbc-c05e-4479-b095-d0d345b74512%40googlegroups.com?utm\_medium=email&utm\_source=footer](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](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](mailto: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](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](https://groups.google.com/d/optout). ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [July 6, 2017, 12:44am UTC](https://discuss.elastic.co/t/getting-sqlfeaturenotsupportedexception-while-connecting-hbase-phoenix-via-river-jdbc/21204/5 "2017-07-06T00:44:05Z")