Try running it with "bin/strart-phoenix.sh &" to force it to the background.
On 24/08/2016 10:21 AM, Cheyenne Forbes wrote:
Okay, thank you, but it doesnt seem to run in the background
"bin/start-phoenix.sh"
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 6:56 PM, F21 <f21.gro...@gmail.com
<mailto:f21.gro...@gmail.com>> wrote:
Tephra is used for transactions in 4.7.0 and onwards. In your
case, ignore tephra and the transaction related settings in the
configuration.
On 24/08/2016 9:55 AM, Cheyenne Forbes wrote:
I dont see "phoenix/bin/tephra" in phoenix version 4.4.0
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 6:16 PM, F21 <f21.gro...@gmail.com
<mailto:f21.gro...@gmail.com>> wrote:
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
