You don't have to download the docker image. Look at the Dockerfile file
to see how to install phoenix with hbase in standalone mode. Then look
at start-hbase-phoenix.sh to see how to set up the configuration file
and start the services.
On 24/08/2016 9:03 AM, Cheyenne Forbes wrote:
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.for...@gmail.com
<mailto:cheyenne.osanu.for...@gmail.com>
Mobile: 876-881-7889 <tel:876-881-7889>
skype: cheyenne.forbes1
On Tue, Aug 23, 2016 at 5:49 PM, F21 <f21.gro...@gmail.com
<mailto:f21.gro...@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
<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 <http://localhost:8765/>" *but it* *gives
this error:*
java.lang.RuntimeException: java.net.ConnectException: Connection
refused
at
org.apache.calcite.avatica.remote.RemoteService.apply(RemoteService.java:59)
at
org.apache.calcite.avatica.remote.JsonService.apply(JsonService.java:235)
at
org.apache.calcite.avatica.remote.RemoteMeta.connectionSync(RemoteMeta.java:97)
at
org.apache.calcite.avatica.AvaticaConnection.getAutoCommit(AvaticaConnection.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(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.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
<http://java.net/>.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net
<http://java.net/>.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net
<http://java.net/>.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.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.Ne
<http://sun.net.www.http.HttpClient.Ne>w(HttpClient.java:308)
at sun.net.www.http.HttpClient.Ne
<http://sun.net.www.http.HttpClient.Ne>w(HttpClient.java:326)
at
sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:998)
at
sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:934)
at
sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:852)
at
sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1302)
at
java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:468)
at
org.apache.calcite.avatica.remote.RemoteService.apply(RemoteService.java:43)
... 18 more
java.lang.RuntimeException: java.net.ConnectException: Connection
refused
at
org.apache.calcite.avatica.remote.RemoteService.apply(RemoteService.java:59)
at
org.apache.calcite.avatica.remote.JsonService.apply(JsonService.java:235)
at
org.apache.calcite.avatica.remote.RemoteMeta.connectionSync(RemoteMeta.java:97)
at
org.apache.calcite.avatica.AvaticaConnection.getTransactionIsolation(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(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.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
<http://java.net/>.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net
<http://java.net/>.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net
<http://java.net/>.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.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.Ne
<http://sun.net.www.http.HttpClient.Ne>w(HttpClient.java:308)
at sun.net.www.http.HttpClient.Ne
<http://sun.net.www.http.HttpClient.Ne>w(HttpClient.java:326)
at
sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:998)
at
sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:934)
at
sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:852)
at
sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1302)
at
java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:468)
at
org.apache.calcite.avatica.remote.RemoteService.apply(RemoteService.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(RemoteService.java:59)
at
org.apache.calcite.avatica.remote.JsonService.apply(JsonService.java:235)
at
org.apache.calcite.avatica.remote.RemoteMeta.connectionSync(RemoteMeta.java:97)
at
org.apache.calcite.avatica.AvaticaConnection.getCatalog(AvaticaConnection.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(NativeMethodAccessorImpl.java:57)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at
sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.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
<http://java.net/>.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at java.net
<http://java.net/>.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at java.net
<http://java.net/>.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.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.Ne
<http://sun.net.www.http.HttpClient.Ne>w(HttpClient.java:308)
at sun.net.www.http.HttpClient.Ne
<http://sun.net.www.http.HttpClient.Ne>w(HttpClient.java:326)
at
sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:998)
at
sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:934)
at
sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:852)
at
sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1302)
at
java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:468)
at
org.apache.calcite.avatica.remote.RemoteService.apply(RemoteService.java:43)
... 20 more
Regards,
Cheyenne Forbes
