phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Cheyenne Forbes <cheyenne.osanu.for...@gmail.com>
Subject Re: Can phoenix run without hadoop? (hbase standalone)
Date Tue, 23 Aug 2016 23:03:02 GMT
I already have Hbase and Phoenix but I dont want to set up Hadoop, how can
I do it with what I already have? (without downloading the docker file)

Regards,

Cheyenne Forbes

Chief Executive Officer
Avapno Omnitech

Chief Operating Officer
Avapno Solutions

Chairman
Avapno Assets, LLC

Bethel Town P.O
Westmoreland
Jamaica

Email: cheyenne.osanu.forbes@gmail.com
Mobile: 876-881-7889
skype: cheyenne.forbes1



On Tue, Aug 23, 2016 at 5:49 PM, F21 <f21.groups@gmail.com> wrote:

> It's possible to run phoenix with out hadoop using hbase in standalone
> mode. However, you will not be able to do bulk load, etc. The safety of
> your data is also not guaranteed without HDFS.
>
> For reference, I have a docker image running hbase standalone with phoenix
> for testing purposes: https://github.com/Boostport/
> hbase-phoenix-all-in-one
>
>
> On 24/08/2016 8:23 AM, Cheyenne Forbes wrote:
>
> what settings should be changed if I can?
>
> Hbase 1.1.2
> Phoenix 4.4.0
> Ubuntu 14
>
> *I try in this order* "/usr/lihbase-1.1.2/bin/start-hbase.sh"* then*
>  "/usr/lib/phoenix-4.4.0/bin/queryserver.py start" *then*
> "/usr/lib/phoenix-4.4.0/bin/sqlline-thin.py http://localhost:8765" *but
> it* *gives this error:*
>
> java.lang.RuntimeException: java.net.ConnectException: Connection refused
>         at org.apache.calcite.avatica.remote.RemoteService.apply(Remote
> Service.java:59)
>         at org.apache.calcite.avatica.remote.JsonService.apply(JsonServ
> ice.java:235)
>         at org.apache.calcite.avatica.remote.RemoteMeta.connectionSync(
> RemoteMeta.java:97)
>         at org.apache.calcite.avatica.AvaticaConnection.getAutoCommit(A
> vaticaConnection.java:135)
>         at sqlline.SqlLine.autocommitStatus(SqlLine.java:951)
>         at sqlline.DatabaseConnection.connect(DatabaseConnection.java:178)
>         at sqlline.DatabaseConnection.getConnection(DatabaseConnection.
> java:203)
>         at sqlline.Commands.connect(Commands.java:1064)
>         at sqlline.Commands.connect(Commands.java:996)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
> ssorImpl.java:57)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
> thodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:606)
>         at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHa
> ndler.java:36)
>         at sqlline.SqlLine.dispatch(SqlLine.java:804)
>         at sqlline.SqlLine.initArgs(SqlLine.java:588)
>         at sqlline.SqlLine.begin(SqlLine.java:656)
>         at sqlline.SqlLine.start(SqlLine.java:398)
>         at sqlline.SqlLine.main(SqlLine.java:292)
> Caused by: java.net.ConnectException: Connection refused
>         at java.net.PlainSocketImpl.socketConnect(Native Method)
>         at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketI
> mpl.java:339)
>         at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlain
> SocketImpl.java:200)
>         at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImp
> l.java:182)
>         at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>         at java.net.Socket.connect(Socket.java:579)
>         at java.net.Socket.connect(Socket.java:528)
>         at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>         at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>         at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>         at sun.net.www.http.HttpClient.<init>(HttpClient.java:211)
>         at sun.net.www.http.HttpClient.New(HttpClient.java:308)
>         at sun.net.www.http.HttpClient.New(HttpClient.java:326)
>         at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient
> (HttpURLConnection.java:998)
>         at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Htt
> pURLConnection.java:934)
>         at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLC
> onnection.java:852)
>         at sun.net.www.protocol.http.HttpURLConnection.getInputStream(H
> ttpURLConnection.java:1302)
>         at java.net.HttpURLConnection.getResponseCode(HttpURLConnection
> .java:468)
>         at org.apache.calcite.avatica.remote.RemoteService.apply(Remote
> Service.java:43)
>         ... 18 more
> java.lang.RuntimeException: java.net.ConnectException: Connection refused
>         at org.apache.calcite.avatica.remote.RemoteService.apply(Remote
> Service.java:59)
>         at org.apache.calcite.avatica.remote.JsonService.apply(JsonServ
> ice.java:235)
>         at org.apache.calcite.avatica.remote.RemoteMeta.connectionSync(
> RemoteMeta.java:97)
>         at org.apache.calcite.avatica.AvaticaConnection.getTransactionI
> solation(AvaticaConnection.java:190)
>         at sqlline.Commands.isolation(Commands.java:681)
>         at sqlline.DatabaseConnection.connect(DatabaseConnection.java:186)
>         at sqlline.DatabaseConnection.getConnection(DatabaseConnection.
> java:203)
>         at sqlline.Commands.connect(Commands.java:1064)
>         at sqlline.Commands.connect(Commands.java:996)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
> ssorImpl.java:57)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
> thodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:606)
>         at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHa
> ndler.java:36)
>         at sqlline.SqlLine.dispatch(SqlLine.java:804)
>         at sqlline.SqlLine.initArgs(SqlLine.java:588)
>         at sqlline.SqlLine.begin(SqlLine.java:656)
>         at sqlline.SqlLine.start(SqlLine.java:398)
>         at sqlline.SqlLine.main(SqlLine.java:292)
> Caused by: java.net.ConnectException: Connection refused
>         at java.net.PlainSocketImpl.socketConnect(Native Method)
>         at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketI
> mpl.java:339)
>         at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlain
> SocketImpl.java:200)
>         at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImp
> l.java:182)
>         at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>         at java.net.Socket.connect(Socket.java:579)
>         at java.net.Socket.connect(Socket.java:528)
>         at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>         at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>         at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>         at sun.net.www.http.HttpClient.<init>(HttpClient.java:211)
>         at sun.net.www.http.HttpClient.New(HttpClient.java:308)
>         at sun.net.www.http.HttpClient.New(HttpClient.java:326)
>         at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient
> (HttpURLConnection.java:998)
>         at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Htt
> pURLConnection.java:934)
>         at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLC
> onnection.java:852)
>         at sun.net.www.protocol.http.HttpURLConnection.getInputStream(H
> ttpURLConnection.java:1302)
>         at java.net.HttpURLConnection.getResponseCode(HttpURLConnection
> .java:468)
>         at org.apache.calcite.avatica.remote.RemoteService.apply(Remote
> Service.java:43)
>         ... 18 more
> Building list of tables and columns for tab-completion (set fastconnect to
> true to skip)...
> java.lang.RuntimeException: java.net.ConnectException: Connection refused
>         at org.apache.calcite.avatica.remote.RemoteService.apply(Remote
> Service.java:59)
>         at org.apache.calcite.avatica.remote.JsonService.apply(JsonServ
> ice.java:235)
>         at org.apache.calcite.avatica.remote.RemoteMeta.connectionSync(
> RemoteMeta.java:97)
>         at org.apache.calcite.avatica.AvaticaConnection.getCatalog(Avat
> icaConnection.java:182)
>         at sqlline.SqlLine.getColumns(SqlLine.java:1098)
>         at sqlline.SqlLine.getColumnNames(SqlLine.java:1122)
>         at sqlline.SqlCompleter.<init>(SqlCompleter.java:81)
>         at sqlline.DatabaseConnection.setCompletions(DatabaseConnection
> .java:84)
>         at sqlline.SqlLine.setCompletions(SqlLine.java:1730)
>         at sqlline.Commands.connect(Commands.java:1066)
>         at sqlline.Commands.connect(Commands.java:996)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAcce
> ssorImpl.java:57)
>         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
> thodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:606)
>         at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHa
> ndler.java:36)
>         at sqlline.SqlLine.dispatch(SqlLine.java:804)
>         at sqlline.SqlLine.initArgs(SqlLine.java:588)
>         at sqlline.SqlLine.begin(SqlLine.java:656)
>         at sqlline.SqlLine.start(SqlLine.java:398)
>         at sqlline.SqlLine.main(SqlLine.java:292)
> Caused by: java.net.ConnectException: Connection refused
>         at java.net.PlainSocketImpl.socketConnect(Native Method)
>         at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketI
> mpl.java:339)
>         at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlain
> SocketImpl.java:200)
>         at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImp
> l.java:182)
>         at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
>         at java.net.Socket.connect(Socket.java:579)
>         at java.net.Socket.connect(Socket.java:528)
>         at sun.net.NetworkClient.doConnect(NetworkClient.java:180)
>         at sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
>         at sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
>         at sun.net.www.http.HttpClient.<init>(HttpClient.java:211)
>         at sun.net.www.http.HttpClient.New(HttpClient.java:308)
>         at sun.net.www.http.HttpClient.New(HttpClient.java:326)
>         at sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient
> (HttpURLConnection.java:998)
>         at sun.net.www.protocol.http.HttpURLConnection.plainConnect(Htt
> pURLConnection.java:934)
>         at sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLC
> onnection.java:852)
>         at sun.net.www.protocol.http.HttpURLConnection.getInputStream(H
> ttpURLConnection.java:1302)
>         at java.net.HttpURLConnection.getResponseCode(HttpURLConnection
> .java:468)
>         at org.apache.calcite.avatica.remote.RemoteService.apply(Remote
> Service.java:43)
>         ... 20 more
>
>
> Regards,
> Cheyenne Forbes
>
>
>

Mime
View raw message