when I run "phoenix_path/bin/sqlline-thin.py http://localhost:8765" I
get 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.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at
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.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(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.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at
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.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(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.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
at
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
at
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.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(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
Chief Executive Officer
Avapno Omnitech
Chief Operating Officer
Avapno Solutions
Chairman
Avapno Assets, LLC
Bethel Town P.O
Westmoreland
Jamaica
Email: [email protected]
<mailto:[email protected]>
Mobile: 876-881-7889 <tel:876-881-7889>
skype: cheyenne.forbes1
On Tue, Aug 23, 2016 at 7:23 PM, F21 <[email protected]
<mailto:[email protected]>> wrote:
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: [email protected]
<mailto:[email protected]>
Mobile: 876-881-7889 <tel:876-881-7889>
skype: cheyenne.forbes1
On Tue, Aug 23, 2016 at 6:56 PM, F21 <[email protected]
<mailto:[email protected]>> 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: [email protected]
<mailto:[email protected]>
Mobile: 876-881-7889 <tel:876-881-7889>
skype: cheyenne.forbes1
On Tue, Aug 23, 2016 at 6:16 PM, F21 <[email protected]
<mailto:[email protected]>> 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: [email protected]
<mailto:[email protected]>
Mobile: 876-881-7889 <tel:876-881-7889>
skype: cheyenne.forbes1
On Tue, Aug 23, 2016 at 5:49 PM, F21
<[email protected] <mailto:[email protected]>> 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