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 <[email protected]> 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 [email protected].
> 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 [email protected].
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.

Reply via email to