Re: Can phoenix run without hadoop? (hbase standalone)

Tue, 23 Aug 2016 15:50:18 -0700

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 <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

























					Reply via email to