You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Cheyenne Forbes <ch...@gmail.com> on 2016/08/23 22:23:02 UTC
Can phoenix run without hadoop? (hbase standalone)
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(AbstractPlainSock
etImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPl
ainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocket
Impl.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(AbstractPlainSock
etImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPl
ainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocket
Impl.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(AbstractPlainSock
etImpl.java:339)
at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPl
ainSocketImpl.java:200)
at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocket
Impl.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
Re: Can phoenix run without hadoop? (hbase standalone)
Posted by Vladimir Rodionov <vl...@gmail.com>.
Can you run HBase w/o Hadoop?
Minimum config: HDFS + Yarn (MapReduce2) + HBase + Phoenix
You will need HDFS to store data, Yarn to run bulk loads or perform other
distributed tasks: export import data mostly, (HBase by itself depends on
Yarn/MapReduce)
-Vlad
On Tue, Aug 23, 2016 at 3:23 PM, Cheyenne Forbes <
cheyenne.osanu.forbes@gmail.com> 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
>
Re: Can phoenix run without hadoop? (hbase standalone)
Posted by F21 <f2...@gmail.com>.
chmod +x myfile.sh
Also, check that the line endings for the file are LR and not CRLF.
On 31/08/2016 9:37 PM, Cheyenne Forbes wrote:
> how do I make start-hbase-phoenix.sh executable?
>
> Regards,
>
> Cheyenne Forbes
>
> Chief Executive Officer
> Avapno Omnitech
>
> Chief Operating Officer
> Avapno Solutions, Co.
>
> Chairman
> Avapno Assets, LLC
>
> Bethel Town P.O
> Westmoreland
> Jamaica
>
> Email: cheyenne.osanu.forbes@gmail.com
> <ma...@gmail.com>
> Mobile: 876-881-7889 <tel:876-881-7889>
> skype: cheyenne.forbes1
>
>
> On Wed, Aug 31, 2016 at 5:39 AM, F21 <f21.groups@gmail.com
> <ma...@gmail.com>> wrote:
>
> Did you build the image yourself? If so, you need to make
> start-hbase-phoenix.sh executable before building it.
>
>
> On 31/08/2016 8:02 PM, Cheyenne Forbes wrote:
>
>
> " ': No such file or directory"
>
>
>
>
Re: Can phoenix run without hadoop? (hbase standalone)
Posted by Cheyenne Forbes <ch...@gmail.com>.
how do I make start-hbase-phoenix.sh executable?
Regards,
Cheyenne Forbes
Chief Executive Officer
Avapno Omnitech
Chief Operating Officer
Avapno Solutions, Co.
Chairman
Avapno Assets, LLC
Bethel Town P.O
Westmoreland
Jamaica
Email: cheyenne.osanu.forbes@gmail.com
Mobile: 876-881-7889
skype: cheyenne.forbes1
On Wed, Aug 31, 2016 at 5:39 AM, F21 <f2...@gmail.com> wrote:
> Did you build the image yourself? If so, you need to make
> start-hbase-phoenix.sh executable before building it.
>
>
> On 31/08/2016 8:02 PM, Cheyenne Forbes wrote:
>
>>
>> " ': No such file or directory"
>>
>
>
>
Re: Can phoenix run without hadoop? (hbase standalone)
Posted by F21 <f2...@gmail.com>.
Did you build the image yourself? If so, you need to make
start-hbase-phoenix.sh executable before building it.
On 31/08/2016 8:02 PM, Cheyenne Forbes wrote:
>
> " ': No such file or directory"
Re: Can phoenix run without hadoop? (hbase standalone)
Posted by Cheyenne Forbes <ch...@gmail.com>.
I decided to use docker but after executing "docker run -i -t 4044a9f77527
./start-hbase-phoenix.sh" I get the following error (including open quote
beside the colon)
" ': No such file or directory"
Regards,
Cheyenne Forbes
On Sat, Aug 27, 2016 at 2:00 AM, Cheyenne Forbes <
cheyenne.osanu.forbes@gmail.com> wrote:
> This is in the query server log:
>
> 2016-08-27 01:30:33,595 WARN org.apache.hadoop.util.NativeCodeLoader:
> Unable to load native-hadoop library for your platform.$
> 2016-08-27 01:30:49,021 INFO org.apache.phoenix.metrics.Metrics:
> Initializing metrics system: phoenix
> 2016-08-27 01:30:49,756 WARN org.apache.hadoop.metrics2.impl.MetricsConfig:
> Cannot locate configuration: tried hadoop-metrics$
> 2016-08-27 01:30:50,915 INFO org.apache.hadoop.metrics2.impl.MetricsSystemImpl:
> Scheduled snapshot period at 10 second(s).
> 2016-08-27 01:30:50,915 INFO org.apache.hadoop.metrics2.impl.MetricsSystemImpl:
> phoenix metrics system started
> 2016-08-27 01:30:58,688 INFO org.apache.phoenix.query.ConnectionQueryServicesImpl:
> Found quorum: localhost:2181
> 2016-08-27 01:31:56,305 INFO org.apache.hadoop.hbase.client.RpcRetryingCaller:
> Call exception, tries=10, retries=35, started=$
> 2016-08-27 01:32:20,069 INFO org.apache.hadoop.hbase.
> client.ConnectionManager$HConnectionImplementation: Closing master proto$
> 2016-08-27 01:32:20,070 INFO org.apache.hadoop.hbase.
> client.ConnectionManager$HConnectionImplementation: Closing zookeeper se$
> 2016-08-27 01:33:48,561 INFO org.apache.phoenix.query.ConnectionQueryServicesImpl:
> Found quorum: localhost:2181
> 2016-08-27 01:34:02,644 INFO org.apache.hadoop.hbase.
> client.ConnectionManager$HConnectionImplementation: Closing master proto$
> 2016-08-27 01:34:02,644 INFO org.apache.hadoop.hbase.
> client.ConnectionManager$HConnectionImplementation: Closing zookeeper se$
> 2016-08-27 01:34:08,127 INFO org.apache.phoenix.query.ConnectionQueryServicesImpl:
> Found quorum: localhost:2181
> 2016-08-27 01:34:11,006 INFO org.apache.hadoop.hbase.
> client.ConnectionManager$HConnectionImplementation: Closing master proto$
> 2016-08-27 01:34:11,007 INFO org.apache.hadoop.hbase.
> client.ConnectionManager$HConnectionImplementation: Closing zookeeper se$
> 2016-08-27 01:34:13,227 INFO org.apache.phoenix.query.ConnectionQueryServicesImpl:
> Found quorum: localhost:2181
> 2016-08-27 01:34:14,035 INFO org.apache.hadoop.hbase.
> client.ConnectionManager$HConnectionImplementation: Closing master proto$
> 2016-08-27 01:34:14,043 INFO org.apache.hadoop.hbase.
> client.ConnectionManager$HConnectionImplementation: Closing zookeeper se$
> 2016-08-27 01:34:17,566 INFO org.eclipse.jetty.util.log: Logging
> initialized @243633ms
> 2016-08-27 01:34:33,564 INFO org.eclipse.jetty.server.Server:
> jetty-9.2.z-SNAPSHOT
> 2016-08-27 01:34:34,156 INFO org.eclipse.jetty.server.ServerConnector:
> Started ServerConnector@539b5b78{HTTP/1.1}{0.0.0.0:876$
> 2016-08-27 01:34:34,157 INFO org.eclipse.jetty.server.Server: Started
> @260431ms
> 2016-08-27 01:34:34,157 INFO org.apache.calcite.avatica.server.HttpServer:
> Service listening on port 8765.
>
>
> 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 Sat, Aug 27, 2016 at 12:31 AM, Cheyenne Forbes <
> cheyenne.osanu.forbes@gmail.com> wrote:
>
>> I already see it in the start-hbase-phoenix.sh file
>>
>> export HBASE_CONF_DIR=/opt/hbase/conf
>> export HBASE_CP=/opt/hbase/lib
>> export HBASE_HOME=/opt/hbase
>>
>>
>>
>> On Wed, Aug 24, 2016 at 1:36 AM, F21 <f2...@gmail.com> wrote:
>> >
>> > You probably need to export some environment variables for HBase to
>> point things to the right place, so that it can use its own bundled hadoop
>> libraries:
>> >
>> > export HBASE_CONF_DIR=/opt/hbase/conf
>> > export HBASE_CP=/opt/hbase/lib
>> > export HBASE_HOME=/opt/hbase
>> >
>> > On 24/08/2016 3:56 PM, Cheyenne Forbes wrote:
>> >
>> > this is what I see:
>> >
>> > 2016-08-24 00:14:45,079 WARN org.apache.hadoop.util.NativeCodeLoader:
>> Unable to load native-hadoop library for your platform.$
>> > 2016-08-24 00:14:58,479 INFO org.apache.phoenix.metrics.Metrics:
>> Initializing metrics system: phoenix
>> > 2016-08-24 00:14:59,065 WARN org.apache.hadoop.metrics2.impl.MetricsConfig:
>> Cannot locate configuration: tried hadoop-metrics$
>> > 2016-08-24 00:14:59,695 INFO org.apache.hadoop.metrics2.impl.MetricsSystemImpl:
>> Scheduled snapshot period at 10 second(s).
>> > 2016-08-24 00:14:59,695 INFO org.apache.hadoop.metrics2.impl.MetricsSystemImpl:
>> phoenix metrics system started
>> > 2016-08-24 00:15:05,891 INFO org.apache.phoenix.query.ConnectionQueryServicesImpl:
>> Found quorum: localhost:2181
>> >
>> >
>> > 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 7:50 PM, F21 <f2...@gmail.com> wrote:
>> >>
>> >> That probably means that the phoenix query server didn't start
>> correctly. Check the logs to see if there's anything interesting.
>> >>
>> >> On 24/08/2016 10:42 AM, Cheyenne Forbes wrote:
>> >>
>> >> 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.rem
>> ote.RemoteService.apply(RemoteService.java:59)
>> >> at org.apache.calcite.avatica.rem
>> ote.JsonService.apply(JsonService.java:235)
>> >> at org.apache.calcite.avatica.rem
>> ote.RemoteMeta.connectionSync(RemoteMeta.java:97)
>> >> at org.apache.calcite.avatica.Ava
>> ticaConnection.getAutoCommit(AvaticaConnection.java:135)
>> >> at sqlline.SqlLine.autocommitStatus(SqlLine.java:951)
>> >> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:
>> 178)
>> >> at sqlline.DatabaseConnection.get
>> Connection(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.NativeMethodAccess
>> orImpl.invoke(NativeMethodAccessorImpl.java:57)
>> >> at sun.reflect.DelegatingMethodAc
>> cessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> >> at java.lang.reflect.Method.invoke(Method.java:606)
>> >> at sqlline.ReflectiveCommandHandl
>> er.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.AbstractPlainSocketIm
>> pl.doConnect(AbstractPlainSocketImpl.java:339)
>> >> at java.net.AbstractPlainSocketIm
>> pl.connectToAddress(AbstractPlainSocketImpl.java:200)
>> >> at java.net.AbstractPlainSocketIm
>> pl.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.Http
>> URLConnection.getNewHttpClient(HttpURLConnection.java:998)
>> >> at sun.net.www.protocol.http.Http
>> URLConnection.plainConnect(HttpURLConnection.java:934)
>> >> at sun.net.www.protocol.http.Http
>> URLConnection.connect(HttpURLConnection.java:852)
>> >> at sun.net.www.protocol.http.Http
>> URLConnection.getInputStream(HttpURLConnection.java:1302)
>> >> at java.net.HttpURLConnection.get
>> ResponseCode(HttpURLConnection.java:468)
>> >> at org.apache.calcite.avatica.rem
>> ote.RemoteService.apply(RemoteService.java:43)
>> >> ... 18 more
>> >> java.lang.RuntimeException: java.net.ConnectException: Connection
>> refused
>> >> at org.apache.calcite.avatica.rem
>> ote.RemoteService.apply(RemoteService.java:59)
>> >> at org.apache.calcite.avatica.rem
>> ote.JsonService.apply(JsonService.java:235)
>> >> at org.apache.calcite.avatica.rem
>> ote.RemoteMeta.connectionSync(RemoteMeta.java:97)
>> >> at org.apache.calcite.avatica.Ava
>> ticaConnection.getTransactionIsolation(AvaticaConnection.java:190)
>> >> at sqlline.Commands.isolation(Commands.java:681)
>> >> at sqlline.DatabaseConnection.connect(DatabaseConnection.java:
>> 186)
>> >> at sqlline.DatabaseConnection.get
>> Connection(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.NativeMethodAccess
>> orImpl.invoke(NativeMethodAccessorImpl.java:57)
>> >> at sun.reflect.DelegatingMethodAc
>> cessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> >> at java.lang.reflect.Method.invoke(Method.java:606)
>> >> at sqlline.ReflectiveCommandHandl
>> er.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.AbstractPlainSocketIm
>> pl.doConnect(AbstractPlainSocketImpl.java:339)
>> >> at java.net.AbstractPlainSocketIm
>> pl.connectToAddress(AbstractPlainSocketImpl.java:200)
>> >> at java.net.AbstractPlainSocketIm
>> pl.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.Http
>> URLConnection.getNewHttpClient(HttpURLConnection.java:998)
>> >> at sun.net.www.protocol.http.Http
>> URLConnection.plainConnect(HttpURLConnection.java:934)
>> >> at sun.net.www.protocol.http.Http
>> URLConnection.connect(HttpURLConnection.java:852)
>> >> at sun.net.www.protocol.http.Http
>> URLConnection.getInputStream(HttpURLConnection.java:1302)
>> >> at java.net.HttpURLConnection.get
>> ResponseCode(HttpURLConnection.java:468)
>> >> at org.apache.calcite.avatica.rem
>> ote.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.rem
>> ote.RemoteService.apply(RemoteService.java:59)
>> >> at org.apache.calcite.avatica.rem
>> ote.JsonService.apply(JsonService.java:235)
>> >> at org.apache.calcite.avatica.rem
>> ote.RemoteMeta.connectionSync(RemoteMeta.java:97)
>> >> at org.apache.calcite.avatica.Ava
>> ticaConnection.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.set
>> Completions(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.NativeMethodAccess
>> orImpl.invoke(NativeMethodAccessorImpl.java:57)
>> >> at sun.reflect.DelegatingMethodAc
>> cessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> >> at java.lang.reflect.Method.invoke(Method.java:606)
>> >> at sqlline.ReflectiveCommandHandl
>> er.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.AbstractPlainSocketIm
>> pl.doConnect(AbstractPlainSocketImpl.java:339)
>> >> at java.net.AbstractPlainSocketIm
>> pl.connectToAddress(AbstractPlainSocketImpl.java:200)
>> >> at java.net.AbstractPlainSocketIm
>> pl.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.Http
>> URLConnection.getNewHttpClient(HttpURLConnection.java:998)
>> >> at sun.net.www.protocol.http.Http
>> URLConnection.plainConnect(HttpURLConnection.java:934)
>> >> at sun.net.www.protocol.http.Http
>> URLConnection.connect(HttpURLConnection.java:852)
>> >> at sun.net.www.protocol.http.Http
>> URLConnection.getInputStream(HttpURLConnection.java:1302)
>> >> at java.net.HttpURLConnection.get
>> ResponseCode(HttpURLConnection.java:468)
>> >> at org.apache.calcite.avatica.rem
>> ote.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: cheyenne.osanu.forbes@gmail.com
>> >> Mobile: 876-881-7889
>> >> skype: cheyenne.forbes1
>> >>
>> >>
>> >>
>> >> On Tue, Aug 23, 2016 at 7:23 PM, F21 <f2...@gmail.com> 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: cheyenne.osanu.forbes@gmail.com
>> >>> Mobile: 876-881-7889
>> >>> skype: cheyenne.forbes1
>> >>>
>> >>>
>> >>>
>> >>> On Tue, Aug 23, 2016 at 6:56 PM, F21 <f2...@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.forbes@gmail.com
>> >>>> Mobile: 876-881-7889
>> >>>> skype: cheyenne.forbes1
>> >>>>
>> >>>>
>> >>>>
>> >>>> On Tue, Aug 23, 2016 at 6:16 PM, F21 <f2...@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.forbes@gmail.com
>> >>>>> Mobile: 876-881-7889
>> >>>>> skype: cheyenne.forbes1
>> >>>>>
>> >>>>>
>> >>>>>
>> >>>>> On Tue, Aug 23, 2016 at 5:49 PM, F21 <f2...@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/h
>> base-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.rem
>> ote.RemoteService.apply(RemoteService.java:59)
>> >>>>>> at org.apache.calcite.avatica.rem
>> ote.JsonService.apply(JsonService.java:235)
>> >>>>>> at org.apache.calcite.avatica.rem
>> ote.RemoteMeta.connectionSync(RemoteMeta.java:97)
>> >>>>>> at org.apache.calcite.avatica.Ava
>> ticaConnection.getAutoCommit(AvaticaConnection.java:135)
>> >>>>>> at sqlline.SqlLine.autocommitStatus(SqlLine.java:951)
>> >>>>>> at sqlline.DatabaseConnection.con
>> nect(DatabaseConnection.java:178)
>> >>>>>> at sqlline.DatabaseConnection.get
>> Connection(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.NativeMethodAccess
>> orImpl.invoke(NativeMethodAccessorImpl.java:57)
>> >>>>>> at sun.reflect.DelegatingMethodAc
>> cessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> >>>>>> at java.lang.reflect.Method.invoke(Method.java:606)
>> >>>>>> at sqlline.ReflectiveCommandHandl
>> er.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.AbstractPlainSocketIm
>> pl.doConnect(AbstractPlainSocketImpl.java:339)
>> >>>>>> at java.net.AbstractPlainSocketIm
>> pl.connectToAddress(AbstractPlainSocketImpl.java:200)
>> >>>>>> at java.net.AbstractPlainSocketIm
>> pl.connect(AbstractPlainSocketImpl.java:182)
>> >>>>>> at java.net.SocksSocketImpl.conne
>> ct(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.op
>> enServer(HttpClient.java:432)
>> >>>>>> at sun.net.www.http.HttpClient.op
>> enServer(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.Http
>> URLConnection.getNewHttpClient(HttpURLConnection.java:998)
>> >>>>>> at sun.net.www.protocol.http.Http
>> URLConnection.plainConnect(HttpURLConnection.java:934)
>> >>>>>> at sun.net.www.protocol.http.Http
>> URLConnection.connect(HttpURLConnection.java:852)
>> >>>>>> at sun.net.www.protocol.http.Http
>> URLConnection.getInputStream(HttpURLConnection.java:1302)
>> >>>>>> at java.net.HttpURLConnection.get
>> ResponseCode(HttpURLConnection.java:468)
>> >>>>>> at org.apache.calcite.avatica.rem
>> ote.RemoteService.apply(RemoteService.java:43)
>> >>>>>> ... 18 more
>> >>>>>> java.lang.RuntimeException: java.net.ConnectException: Connection
>> refused
>> >>>>>> at org.apache.calcite.avatica.rem
>> ote.RemoteService.apply(RemoteService.java:59)
>> >>>>>> at org.apache.calcite.avatica.rem
>> ote.JsonService.apply(JsonService.java:235)
>> >>>>>> at org.apache.calcite.avatica.rem
>> ote.RemoteMeta.connectionSync(RemoteMeta.java:97)
>> >>>>>> at org.apache.calcite.avatica.Ava
>> ticaConnection.getTransactionIsolation(AvaticaConnection.java:190)
>> >>>>>> at sqlline.Commands.isolation(Commands.java:681)
>> >>>>>> at sqlline.DatabaseConnection.con
>> nect(DatabaseConnection.java:186)
>> >>>>>> at sqlline.DatabaseConnection.get
>> Connection(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.NativeMethodAccess
>> orImpl.invoke(NativeMethodAccessorImpl.java:57)
>> >>>>>> at sun.reflect.DelegatingMethodAc
>> cessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> >>>>>> at java.lang.reflect.Method.invoke(Method.java:606)
>> >>>>>> at sqlline.ReflectiveCommandHandl
>> er.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.AbstractPlainSocketIm
>> pl.doConnect(AbstractPlainSocketImpl.java:339)
>> >>>>>> at java.net.AbstractPlainSocketIm
>> pl.connectToAddress(AbstractPlainSocketImpl.java:200)
>> >>>>>> at java.net.AbstractPlainSocketIm
>> pl.connect(AbstractPlainSocketImpl.java:182)
>> >>>>>> at java.net.SocksSocketImpl.conne
>> ct(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.op
>> enServer(HttpClient.java:432)
>> >>>>>> at sun.net.www.http.HttpClient.op
>> enServer(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.Http
>> URLConnection.getNewHttpClient(HttpURLConnection.java:998)
>> >>>>>> at sun.net.www.protocol.http.Http
>> URLConnection.plainConnect(HttpURLConnection.java:934)
>> >>>>>> at sun.net.www.protocol.http.Http
>> URLConnection.connect(HttpURLConnection.java:852)
>> >>>>>> at sun.net.www.protocol.http.Http
>> URLConnection.getInputStream(HttpURLConnection.java:1302)
>> >>>>>> at java.net.HttpURLConnection.get
>> ResponseCode(HttpURLConnection.java:468)
>> >>>>>> at org.apache.calcite.avatica.rem
>> ote.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.rem
>> ote.RemoteService.apply(RemoteService.java:59)
>> >>>>>> at org.apache.calcite.avatica.rem
>> ote.JsonService.apply(JsonService.java:235)
>> >>>>>> at org.apache.calcite.avatica.rem
>> ote.RemoteMeta.connectionSync(RemoteMeta.java:97)
>> >>>>>> at org.apache.calcite.avatica.Ava
>> ticaConnection.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.set
>> Completions(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.NativeMethodAccess
>> orImpl.invoke(NativeMethodAccessorImpl.java:57)
>> >>>>>> at sun.reflect.DelegatingMethodAc
>> cessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>> >>>>>> at java.lang.reflect.Method.invoke(Method.java:606)
>> >>>>>> at sqlline.ReflectiveCommandHandl
>> er.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.AbstractPlainSocketIm
>> pl.doConnect(AbstractPlainSocketImpl.java:339)
>> >>>>>> at java.net.AbstractPlainSocketIm
>> pl.connectToAddress(AbstractPlainSocketImpl.java:200)
>> >>>>>> at java.net.AbstractPlainSocketIm
>> pl.connect(AbstractPlainSocketImpl.java:182)
>> >>>>>> at java.net.SocksSocketImpl.conne
>> ct(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.op
>> enServer(HttpClient.java:432)
>> >>>>>> at sun.net.www.http.HttpClient.op
>> enServer(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.Http
>> URLConnection.getNewHttpClient(HttpURLConnection.java:998)
>> >>>>>> at sun.net.www.protocol.http.Http
>> URLConnection.plainConnect(HttpURLConnection.java:934)
>> >>>>>> at sun.net.www.protocol.http.Http
>> URLConnection.connect(HttpURLConnection.java:852)
>> >>>>>> at sun.net.www.protocol.http.Http
>> URLConnection.getInputStream(HttpURLConnection.java:1302)
>> >>>>>> at java.net.HttpURLConnection.get
>> ResponseCode(HttpURLConnection.java:468)
>> >>>>>> at org.apache.calcite.avatica.rem
>> ote.RemoteService.apply(RemoteService.java:43)
>> >>>>>> ... 20 more
>> >>>>>>
>> >>>>>>
>> >>>>>> Regards,
>> >>>>>> Cheyenne Forbes
>> >>>>>>
>> >>>>>>
>> >>>>>
>> >>>>>
>> >>>>
>> >>>>
>> >>>
>> >>>
>> >>
>> >>
>> >
>> >
>>
>
>
Re: Can phoenix run without hadoop? (hbase standalone)
Posted by Cheyenne Forbes <ch...@gmail.com>.
This is in the query server log:
2016-08-27 01:30:33,595 WARN org.apache.hadoop.util.NativeCodeLoader:
Unable to load native-hadoop library for your platform.$
2016-08-27 01:30:49,021 INFO org.apache.phoenix.metrics.Metrics:
Initializing metrics system: phoenix
2016-08-27 01:30:49,756 WARN org.apache.hadoop.metrics2.impl.MetricsConfig:
Cannot locate configuration: tried hadoop-metrics$
2016-08-27 01:30:50,915 INFO
org.apache.hadoop.metrics2.impl.MetricsSystemImpl: Scheduled snapshot
period at 10 second(s).
2016-08-27 01:30:50,915 INFO
org.apache.hadoop.metrics2.impl.MetricsSystemImpl: phoenix metrics system
started
2016-08-27 01:30:58,688 INFO
org.apache.phoenix.query.ConnectionQueryServicesImpl: Found quorum:
localhost:2181
2016-08-27 01:31:56,305 INFO
org.apache.hadoop.hbase.client.RpcRetryingCaller: Call exception, tries=10,
retries=35, started=$
2016-08-27 01:32:20,069 INFO
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation:
Closing master proto$
2016-08-27 01:32:20,070 INFO
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation:
Closing zookeeper se$
2016-08-27 01:33:48,561 INFO
org.apache.phoenix.query.ConnectionQueryServicesImpl: Found quorum:
localhost:2181
2016-08-27 01:34:02,644 INFO
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation:
Closing master proto$
2016-08-27 01:34:02,644 INFO
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation:
Closing zookeeper se$
2016-08-27 01:34:08,127 INFO
org.apache.phoenix.query.ConnectionQueryServicesImpl: Found quorum:
localhost:2181
2016-08-27 01:34:11,006 INFO
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation:
Closing master proto$
2016-08-27 01:34:11,007 INFO
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation:
Closing zookeeper se$
2016-08-27 01:34:13,227 INFO
org.apache.phoenix.query.ConnectionQueryServicesImpl: Found quorum:
localhost:2181
2016-08-27 01:34:14,035 INFO
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation:
Closing master proto$
2016-08-27 01:34:14,043 INFO
org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation:
Closing zookeeper se$
2016-08-27 01:34:17,566 INFO org.eclipse.jetty.util.log: Logging
initialized @243633ms
2016-08-27 01:34:33,564 INFO org.eclipse.jetty.server.Server:
jetty-9.2.z-SNAPSHOT
2016-08-27 01:34:34,156 INFO org.eclipse.jetty.server.ServerConnector:
Started ServerConnector@539b5b78{HTTP/1.1}{0.0.0.0:876$
2016-08-27 01:34:34,157 INFO org.eclipse.jetty.server.Server: Started
@260431ms
2016-08-27 01:34:34,157 INFO org.apache.calcite.avatica.server.HttpServer:
Service listening on port 8765.
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 Sat, Aug 27, 2016 at 12:31 AM, Cheyenne Forbes <
cheyenne.osanu.forbes@gmail.com> wrote:
> I already see it in the start-hbase-phoenix.sh file
>
> export HBASE_CONF_DIR=/opt/hbase/conf
> export HBASE_CP=/opt/hbase/lib
> export HBASE_HOME=/opt/hbase
>
>
>
> On Wed, Aug 24, 2016 at 1:36 AM, F21 <f2...@gmail.com> wrote:
> >
> > You probably need to export some environment variables for HBase to
> point things to the right place, so that it can use its own bundled hadoop
> libraries:
> >
> > export HBASE_CONF_DIR=/opt/hbase/conf
> > export HBASE_CP=/opt/hbase/lib
> > export HBASE_HOME=/opt/hbase
> >
> > On 24/08/2016 3:56 PM, Cheyenne Forbes wrote:
> >
> > this is what I see:
> >
> > 2016-08-24 00:14:45,079 WARN org.apache.hadoop.util.NativeCodeLoader:
> Unable to load native-hadoop library for your platform.$
> > 2016-08-24 00:14:58,479 INFO org.apache.phoenix.metrics.Metrics:
> Initializing metrics system: phoenix
> > 2016-08-24 00:14:59,065 WARN org.apache.hadoop.metrics2.impl.MetricsConfig:
> Cannot locate configuration: tried hadoop-metrics$
> > 2016-08-24 00:14:59,695 INFO org.apache.hadoop.metrics2.impl.MetricsSystemImpl:
> Scheduled snapshot period at 10 second(s).
> > 2016-08-24 00:14:59,695 INFO org.apache.hadoop.metrics2.impl.MetricsSystemImpl:
> phoenix metrics system started
> > 2016-08-24 00:15:05,891 INFO org.apache.phoenix.query.ConnectionQueryServicesImpl:
> Found quorum: localhost:2181
> >
> >
> > 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 7:50 PM, F21 <f2...@gmail.com> wrote:
> >>
> >> That probably means that the phoenix query server didn't start
> correctly. Check the logs to see if there's anything interesting.
> >>
> >> On 24/08/2016 10:42 AM, Cheyenne Forbes wrote:
> >>
> >> 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: cheyenne.osanu.forbes@gmail.com
> >> Mobile: 876-881-7889
> >> skype: cheyenne.forbes1
> >>
> >>
> >>
> >> On Tue, Aug 23, 2016 at 7:23 PM, F21 <f2...@gmail.com> 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: cheyenne.osanu.forbes@gmail.com
> >>> Mobile: 876-881-7889
> >>> skype: cheyenne.forbes1
> >>>
> >>>
> >>>
> >>> On Tue, Aug 23, 2016 at 6:56 PM, F21 <f2...@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.forbes@gmail.com
> >>>> Mobile: 876-881-7889
> >>>> skype: cheyenne.forbes1
> >>>>
> >>>>
> >>>>
> >>>> On Tue, Aug 23, 2016 at 6:16 PM, F21 <f2...@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.forbes@gmail.com
> >>>>> Mobile: 876-881-7889
> >>>>> skype: cheyenne.forbes1
> >>>>>
> >>>>>
> >>>>>
> >>>>> On Tue, Aug 23, 2016 at 5:49 PM, F21 <f2...@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(
> 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
> >>>>>>
> >>>>>>
> >>>>>
> >>>>>
> >>>>
> >>>>
> >>>
> >>>
> >>
> >>
> >
> >
>
Re: Can phoenix run without hadoop? (hbase standalone)
Posted by Cheyenne Forbes <ch...@gmail.com>.
I already see it in the start-hbase-phoenix.sh file
export HBASE_CONF_DIR=/opt/hbase/conf
export HBASE_CP=/opt/hbase/lib
export HBASE_HOME=/opt/hbase
On Wed, Aug 24, 2016 at 1:36 AM, F21 <f2...@gmail.com> wrote:
>
> You probably need to export some environment variables for HBase to point
things to the right place, so that it can use its own bundled hadoop
libraries:
>
> export HBASE_CONF_DIR=/opt/hbase/conf
> export HBASE_CP=/opt/hbase/lib
> export HBASE_HOME=/opt/hbase
>
> On 24/08/2016 3:56 PM, Cheyenne Forbes wrote:
>
> this is what I see:
>
> 2016-08-24 00:14:45,079 WARN org.apache.hadoop.util.NativeCodeLoader:
Unable to load native-hadoop library for your platform.$
> 2016-08-24 00:14:58,479 INFO org.apache.phoenix.metrics.Metrics:
Initializing metrics system: phoenix
> 2016-08-24 00:14:59,065 WARN
org.apache.hadoop.metrics2.impl.MetricsConfig: Cannot locate configuration:
tried hadoop-metrics$
> 2016-08-24 00:14:59,695 INFO
org.apache.hadoop.metrics2.impl.MetricsSystemImpl: Scheduled snapshot
period at 10 second(s).
> 2016-08-24 00:14:59,695 INFO
org.apache.hadoop.metrics2.impl.MetricsSystemImpl: phoenix metrics system
started
> 2016-08-24 00:15:05,891 INFO
org.apache.phoenix.query.ConnectionQueryServicesImpl: Found quorum:
localhost:2181
>
>
> 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 7:50 PM, F21 <f2...@gmail.com> wrote:
>>
>> That probably means that the phoenix query server didn't start
correctly. Check the logs to see if there's anything interesting.
>>
>> On 24/08/2016 10:42 AM, Cheyenne Forbes wrote:
>>
>> 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: cheyenne.osanu.forbes@gmail.com
>> Mobile: 876-881-7889
>> skype: cheyenne.forbes1
>>
>>
>>
>> On Tue, Aug 23, 2016 at 7:23 PM, F21 <f2...@gmail.com> 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: cheyenne.osanu.forbes@gmail.com
>>> Mobile: 876-881-7889
>>> skype: cheyenne.forbes1
>>>
>>>
>>>
>>> On Tue, Aug 23, 2016 at 6:56 PM, F21 <f2...@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.forbes@gmail.com
>>>> Mobile: 876-881-7889
>>>> skype: cheyenne.forbes1
>>>>
>>>>
>>>>
>>>> On Tue, Aug 23, 2016 at 6:16 PM, F21 <f2...@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.forbes@gmail.com
>>>>> Mobile: 876-881-7889
>>>>> skype: cheyenne.forbes1
>>>>>
>>>>>
>>>>>
>>>>> On Tue, Aug 23, 2016 at 5:49 PM, F21 <f2...@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(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
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
Re: Can phoenix run without hadoop? (hbase standalone)
Posted by F21 <f2...@gmail.com>.
You probably need to export some environment variables for HBase to
point things to the right place, so that it can use its own bundled
hadoop libraries:
export HBASE_CONF_DIR=/opt/hbase/conf
export HBASE_CP=/opt/hbase/lib
export HBASE_HOME=/opt/hbase
On 24/08/2016 3:56 PM, Cheyenne Forbes wrote:
> this is what I see:
>
> 2016-08-24 00:14:45,079 WARN org.apache.hadoop.util.NativeCodeLoader:
> Unable to load native-hadoop library for your platform.$
> 2016-08-24 00:14:58,479 INFO org.apache.phoenix.metrics.Metrics:
> Initializing metrics system: phoenix
> 2016-08-24 00:14:59,065 WARN
> org.apache.hadoop.metrics2.impl.MetricsConfig: Cannot locate
> configuration: tried hadoop-metrics$
> 2016-08-24 00:14:59,695 INFO
> org.apache.hadoop.metrics2.impl.MetricsSystemImpl: Scheduled snapshot
> period at 10 second(s).
> 2016-08-24 00:14:59,695 INFO
> org.apache.hadoop.metrics2.impl.MetricsSystemImpl: phoenix metrics
> system started
> 2016-08-24 00:15:05,891 INFO
> org.apache.phoenix.query.ConnectionQueryServicesImpl: Found quorum:
> localhost:2181
>
>
> 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
> <ma...@gmail.com>
> Mobile: 876-881-7889 <tel:876-881-7889>
> skype: cheyenne.forbes1
>
>
>
> On Tue, Aug 23, 2016 at 7:50 PM, F21 <f21.groups@gmail.com
> <ma...@gmail.com>> wrote:
>
> That probably means that the phoenix query server didn't start
> correctly. Check the logs to see if there's anything interesting.
>
> On 24/08/2016 10:42 AM, Cheyenne Forbes wrote:
>> 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
>> <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.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
>> <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.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
>> <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.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: cheyenne.osanu.forbes@gmail.com
>> <ma...@gmail.com>
>> Mobile: 876-881-7889 <tel:876-881-7889>
>> skype: cheyenne.forbes1
>>
>>
>>
>> On Tue, Aug 23, 2016 at 7:23 PM, F21 <f21.groups@gmail.com
>> <ma...@gmail.com>> 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: cheyenne.osanu.forbes@gmail.com
>>> <ma...@gmail.com>
>>> Mobile: 876-881-7889 <tel:876-881-7889>
>>> skype: cheyenne.forbes1
>>>
>>>
>>>
>>> On Tue, Aug 23, 2016 at 6:56 PM, F21 <f21.groups@gmail.com
>>> <ma...@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.forbes@gmail.com
>>>> <ma...@gmail.com>
>>>> Mobile: 876-881-7889 <tel:876-881-7889>
>>>> skype: cheyenne.forbes1
>>>>
>>>>
>>>>
>>>> On Tue, Aug 23, 2016 at 6:16 PM, F21
>>>> <f21.groups@gmail.com <ma...@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.forbes@gmail.com
>>>>> <ma...@gmail.com>
>>>>> Mobile: 876-881-7889 <tel:876-881-7889>
>>>>> skype: cheyenne.forbes1
>>>>>
>>>>>
>>>>>
>>>>> On Tue, Aug 23, 2016 at 5:49 PM, F21
>>>>> <f21.groups@gmail.com
>>>>> <ma...@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
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
Re: Can phoenix run without hadoop? (hbase standalone)
Posted by Cheyenne Forbes <ch...@gmail.com>.
this is what I see:
2016-08-24 00:14:45,079 WARN org.apache.hadoop.util.NativeCodeLoader:
Unable to load native-hadoop library for your platform.$
2016-08-24 00:14:58,479 INFO org.apache.phoenix.metrics.Metrics:
Initializing metrics system: phoenix
2016-08-24 00:14:59,065 WARN org.apache.hadoop.metrics2.impl.MetricsConfig:
Cannot locate configuration: tried hadoop-metrics$
2016-08-24 00:14:59,695 INFO
org.apache.hadoop.metrics2.impl.MetricsSystemImpl: Scheduled snapshot
period at 10 second(s).
2016-08-24 00:14:59,695 INFO
org.apache.hadoop.metrics2.impl.MetricsSystemImpl: phoenix metrics system
started
2016-08-24 00:15:05,891 INFO
org.apache.phoenix.query.ConnectionQueryServicesImpl: Found quorum:
localhost:2181
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 7:50 PM, F21 <f2...@gmail.com> wrote:
> That probably means that the phoenix query server didn't start correctly.
> Check the logs to see if there's anything interesting.
>
> On 24/08/2016 10:42 AM, Cheyenne Forbes wrote:
>
> 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: cheyenne.osanu.forbes@gmail.com
> Mobile: 876-881-7889
> skype: cheyenne.forbes1
>
>
>
> On Tue, Aug 23, 2016 at 7:23 PM, F21 <f2...@gmail.com> 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: cheyenne.osanu.forbes@gmail.com
>> Mobile: 876-881-7889
>> skype: cheyenne.forbes1
>>
>>
>>
>> On Tue, Aug 23, 2016 at 6:56 PM, F21 <f2...@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.forbes@gmail.com
>>> Mobile: 876-881-7889
>>> skype: cheyenne.forbes1
>>>
>>>
>>>
>>> On Tue, Aug 23, 2016 at 6:16 PM, F21 <f2...@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.forbes@gmail.com
>>>> Mobile: 876-881-7889
>>>> skype: cheyenne.forbes1
>>>>
>>>>
>>>>
>>>> On Tue, Aug 23, 2016 at 5:49 PM, F21 <f2...@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/h
>>>>> base-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.rem
>>>>> ote.RemoteService.apply(RemoteService.java:59)
>>>>> at org.apache.calcite.avatica.rem
>>>>> ote.JsonService.apply(JsonService.java:235)
>>>>> at org.apache.calcite.avatica.rem
>>>>> ote.RemoteMeta.connectionSync(RemoteMeta.java:97)
>>>>> at org.apache.calcite.avatica.Ava
>>>>> ticaConnection.getAutoCommit(AvaticaConnection.java:135)
>>>>> at sqlline.SqlLine.autocommitStatus(SqlLine.java:951)
>>>>> at sqlline.DatabaseConnection.con
>>>>> nect(DatabaseConnection.java:178)
>>>>> at sqlline.DatabaseConnection.get
>>>>> Connection(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.NativeMethodAccess
>>>>> orImpl.invoke(NativeMethodAccessorImpl.java:57)
>>>>> at sun.reflect.DelegatingMethodAc
>>>>> cessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>>>> at java.lang.reflect.Method.invoke(Method.java:606)
>>>>> at sqlline.ReflectiveCommandHandl
>>>>> er.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(AbstractPlainS
>>>>> ocketImpl.java:339)
>>>>> at java.net.AbstractPlainSocketImpl.connectToAddress(Abstrac
>>>>> tPlainSocketImpl.java:200)
>>>>> at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSoc
>>>>> ketImpl.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.Http
>>>>> URLConnection.getNewHttpClient(HttpURLConnection.java:998)
>>>>> at sun.net.www.protocol.http.Http
>>>>> URLConnection.plainConnect(HttpURLConnection.java:934)
>>>>> at sun.net.www.protocol.http.Http
>>>>> URLConnection.connect(HttpURLConnection.java:852)
>>>>> at sun.net.www.protocol.http.Http
>>>>> URLConnection.getInputStream(HttpURLConnection.java:1302)
>>>>> at java.net.HttpURLConnection.get
>>>>> ResponseCode(HttpURLConnection.java:468)
>>>>> at org.apache.calcite.avatica.rem
>>>>> ote.RemoteService.apply(RemoteService.java:43)
>>>>> ... 18 more
>>>>> java.lang.RuntimeException: java.net.ConnectException: Connection
>>>>> refused
>>>>> at org.apache.calcite.avatica.rem
>>>>> ote.RemoteService.apply(RemoteService.java:59)
>>>>> at org.apache.calcite.avatica.rem
>>>>> ote.JsonService.apply(JsonService.java:235)
>>>>> at org.apache.calcite.avatica.rem
>>>>> ote.RemoteMeta.connectionSync(RemoteMeta.java:97)
>>>>> at org.apache.calcite.avatica.Ava
>>>>> ticaConnection.getTransactionIsolation(AvaticaConnection.java:190)
>>>>> at sqlline.Commands.isolation(Commands.java:681)
>>>>> at sqlline.DatabaseConnection.con
>>>>> nect(DatabaseConnection.java:186)
>>>>> at sqlline.DatabaseConnection.get
>>>>> Connection(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.NativeMethodAccess
>>>>> orImpl.invoke(NativeMethodAccessorImpl.java:57)
>>>>> at sun.reflect.DelegatingMethodAc
>>>>> cessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>>>> at java.lang.reflect.Method.invoke(Method.java:606)
>>>>> at sqlline.ReflectiveCommandHandl
>>>>> er.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(AbstractPlainS
>>>>> ocketImpl.java:339)
>>>>> at java.net.AbstractPlainSocketImpl.connectToAddress(Abstrac
>>>>> tPlainSocketImpl.java:200)
>>>>> at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSoc
>>>>> ketImpl.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.Http
>>>>> URLConnection.getNewHttpClient(HttpURLConnection.java:998)
>>>>> at sun.net.www.protocol.http.Http
>>>>> URLConnection.plainConnect(HttpURLConnection.java:934)
>>>>> at sun.net.www.protocol.http.Http
>>>>> URLConnection.connect(HttpURLConnection.java:852)
>>>>> at sun.net.www.protocol.http.Http
>>>>> URLConnection.getInputStream(HttpURLConnection.java:1302)
>>>>> at java.net.HttpURLConnection.get
>>>>> ResponseCode(HttpURLConnection.java:468)
>>>>> at org.apache.calcite.avatica.rem
>>>>> ote.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.rem
>>>>> ote.RemoteService.apply(RemoteService.java:59)
>>>>> at org.apache.calcite.avatica.rem
>>>>> ote.JsonService.apply(JsonService.java:235)
>>>>> at org.apache.calcite.avatica.rem
>>>>> ote.RemoteMeta.connectionSync(RemoteMeta.java:97)
>>>>> at org.apache.calcite.avatica.Ava
>>>>> ticaConnection.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.set
>>>>> Completions(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.NativeMethodAccess
>>>>> orImpl.invoke(NativeMethodAccessorImpl.java:57)
>>>>> at sun.reflect.DelegatingMethodAc
>>>>> cessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>>>>> at java.lang.reflect.Method.invoke(Method.java:606)
>>>>> at sqlline.ReflectiveCommandHandl
>>>>> er.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(AbstractPlainS
>>>>> ocketImpl.java:339)
>>>>> at java.net.AbstractPlainSocketImpl.connectToAddress(Abstrac
>>>>> tPlainSocketImpl.java:200)
>>>>> at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSoc
>>>>> ketImpl.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.Http
>>>>> URLConnection.getNewHttpClient(HttpURLConnection.java:998)
>>>>> at sun.net.www.protocol.http.Http
>>>>> URLConnection.plainConnect(HttpURLConnection.java:934)
>>>>> at sun.net.www.protocol.http.Http
>>>>> URLConnection.connect(HttpURLConnection.java:852)
>>>>> at sun.net.www.protocol.http.Http
>>>>> URLConnection.getInputStream(HttpURLConnection.java:1302)
>>>>> at java.net.HttpURLConnection.get
>>>>> ResponseCode(HttpURLConnection.java:468)
>>>>> at org.apache.calcite.avatica.rem
>>>>> ote.RemoteService.apply(RemoteService.java:43)
>>>>> ... 20 more
>>>>>
>>>>>
>>>>> Regards,
>>>>> Cheyenne Forbes
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
Re: Can phoenix run without hadoop? (hbase standalone)
Posted by F21 <f2...@gmail.com>.
That probably means that the phoenix query server didn't start
correctly. Check the logs to see if there's anything interesting.
On 24/08/2016 10:42 AM, Cheyenne Forbes wrote:
> 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: cheyenne.osanu.forbes@gmail.com
> <ma...@gmail.com>
> Mobile: 876-881-7889 <tel:876-881-7889>
> skype: cheyenne.forbes1
>
>
>
> On Tue, Aug 23, 2016 at 7:23 PM, F21 <f21.groups@gmail.com
> <ma...@gmail.com>> 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: cheyenne.osanu.forbes@gmail.com
>> <ma...@gmail.com>
>> Mobile: 876-881-7889 <tel:876-881-7889>
>> skype: cheyenne.forbes1
>>
>>
>>
>> On Tue, Aug 23, 2016 at 6:56 PM, F21 <f21.groups@gmail.com
>> <ma...@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.forbes@gmail.com
>>> <ma...@gmail.com>
>>> Mobile: 876-881-7889 <tel:876-881-7889>
>>> skype: cheyenne.forbes1
>>>
>>>
>>>
>>> On Tue, Aug 23, 2016 at 6:16 PM, F21 <f21.groups@gmail.com
>>> <ma...@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.forbes@gmail.com
>>>> <ma...@gmail.com>
>>>> Mobile: 876-881-7889 <tel:876-881-7889>
>>>> skype: cheyenne.forbes1
>>>>
>>>>
>>>>
>>>> On Tue, Aug 23, 2016 at 5:49 PM, F21
>>>> <f21.groups@gmail.com <ma...@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
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
Re: Can phoenix run without hadoop? (hbase standalone)
Posted by Cheyenne Forbes <ch...@gmail.com>.
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: cheyenne.osanu.forbes@gmail.com
Mobile: 876-881-7889
skype: cheyenne.forbes1
On Tue, Aug 23, 2016 at 7:23 PM, F21 <f2...@gmail.com> 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: cheyenne.osanu.forbes@gmail.com
> Mobile: 876-881-7889
> skype: cheyenne.forbes1
>
>
>
> On Tue, Aug 23, 2016 at 6:56 PM, F21 <f2...@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.forbes@gmail.com
>> Mobile: 876-881-7889
>> skype: cheyenne.forbes1
>>
>>
>>
>> On Tue, Aug 23, 2016 at 6:16 PM, F21 <f2...@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.forbes@gmail.com
>>> Mobile: 876-881-7889
>>> skype: cheyenne.forbes1
>>>
>>>
>>>
>>> On Tue, Aug 23, 2016 at 5:49 PM, F21 <f2...@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/h
>>>> base-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:1
>>>> 78)
>>>> 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(AbstractPlainS
>>>> ocketImpl.java:339)
>>>> at java.net.AbstractPlainSocketImpl.connectToAddress(Abstrac
>>>> tPlainSocketImpl.java:200)
>>>> at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSoc
>>>> ketImpl.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:1
>>>> 86)
>>>> 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(AbstractPlainS
>>>> ocketImpl.java:339)
>>>> at java.net.AbstractPlainSocketImpl.connectToAddress(Abstrac
>>>> tPlainSocketImpl.java:200)
>>>> at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSoc
>>>> ketImpl.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(AbstractPlainS
>>>> ocketImpl.java:339)
>>>> at java.net.AbstractPlainSocketImpl.connectToAddress(Abstrac
>>>> tPlainSocketImpl.java:200)
>>>> at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSoc
>>>> ketImpl.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
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>
Re: Can phoenix run without hadoop? (hbase standalone)
Posted by F21 <f2...@gmail.com>.
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.forbes@gmail.com
> <ma...@gmail.com>
> Mobile: 876-881-7889 <tel:876-881-7889>
> skype: cheyenne.forbes1
>
>
>
> On Tue, Aug 23, 2016 at 6:56 PM, F21 <f21.groups@gmail.com
> <ma...@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.forbes@gmail.com
>> <ma...@gmail.com>
>> Mobile: 876-881-7889 <tel:876-881-7889>
>> skype: cheyenne.forbes1
>>
>>
>>
>> On Tue, Aug 23, 2016 at 6:16 PM, F21 <f21.groups@gmail.com
>> <ma...@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.forbes@gmail.com
>>> <ma...@gmail.com>
>>> Mobile: 876-881-7889 <tel:876-881-7889>
>>> skype: cheyenne.forbes1
>>>
>>>
>>>
>>> On Tue, Aug 23, 2016 at 5:49 PM, F21 <f21.groups@gmail.com
>>> <ma...@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
>>>
>>>
>>>
>>
>>
>
>
Re: Can phoenix run without hadoop? (hbase standalone)
Posted by Cheyenne Forbes <ch...@gmail.com>.
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.forbes@gmail.com
Mobile: 876-881-7889
skype: cheyenne.forbes1
On Tue, Aug 23, 2016 at 6:56 PM, F21 <f2...@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.forbes@gmail.com
> Mobile: 876-881-7889
> skype: cheyenne.forbes1
>
>
>
> On Tue, Aug 23, 2016 at 6:16 PM, F21 <f2...@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.forbes@gmail.com
>> Mobile: 876-881-7889
>> skype: cheyenne.forbes1
>>
>>
>>
>> On Tue, Aug 23, 2016 at 5:49 PM, F21 <f2...@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/h
>>> base-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:1
>>> 78)
>>> 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(AbstractPlainS
>>> ocketImpl.java:339)
>>> at java.net.AbstractPlainSocketImpl.connectToAddress(Abstrac
>>> tPlainSocketImpl.java:200)
>>> at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSoc
>>> ketImpl.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:1
>>> 86)
>>> 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(AbstractPlainS
>>> ocketImpl.java:339)
>>> at java.net.AbstractPlainSocketImpl.connectToAddress(Abstrac
>>> tPlainSocketImpl.java:200)
>>> at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSoc
>>> ketImpl.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(AbstractPlainS
>>> ocketImpl.java:339)
>>> at java.net.AbstractPlainSocketImpl.connectToAddress(Abstrac
>>> tPlainSocketImpl.java:200)
>>> at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSoc
>>> ketImpl.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
>>>
>>>
>>>
>>
>>
>
>
Re: Can phoenix run without hadoop? (hbase standalone)
Posted by F21 <f2...@gmail.com>.
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.forbes@gmail.com
> <ma...@gmail.com>
> Mobile: 876-881-7889 <tel:876-881-7889>
> skype: cheyenne.forbes1
>
>
>
> On Tue, Aug 23, 2016 at 6:16 PM, F21 <f21.groups@gmail.com
> <ma...@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.forbes@gmail.com
>> <ma...@gmail.com>
>> Mobile: 876-881-7889 <tel:876-881-7889>
>> skype: cheyenne.forbes1
>>
>>
>>
>> On Tue, Aug 23, 2016 at 5:49 PM, F21 <f21.groups@gmail.com
>> <ma...@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
>>
>>
>>
>
>
Re: Can phoenix run without hadoop? (hbase standalone)
Posted by Cheyenne Forbes <ch...@gmail.com>.
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.forbes@gmail.com
Mobile: 876-881-7889
skype: cheyenne.forbes1
On Tue, Aug 23, 2016 at 6:16 PM, F21 <f2...@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.forbes@gmail.com
> Mobile: 876-881-7889
> skype: cheyenne.forbes1
>
>
>
> On Tue, Aug 23, 2016 at 5:49 PM, F21 <f2...@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/h
>> base-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:1
>> 78)
>> 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(
>> 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(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:1
>> 86)
>> 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(
>> 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(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(
>> 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(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
>>
>>
>>
>
>
Re: Can phoenix run without hadoop? (hbase standalone)
Posted by F21 <f2...@gmail.com>.
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.forbes@gmail.com
> <ma...@gmail.com>
> Mobile: 876-881-7889 <tel:876-881-7889>
> skype: cheyenne.forbes1
>
>
>
> On Tue, Aug 23, 2016 at 5:49 PM, F21 <f21.groups@gmail.com
> <ma...@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
>
>
>
Re: Can phoenix run without hadoop? (hbase standalone)
Posted by Cheyenne Forbes <ch...@gmail.com>.
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 <f2...@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
>
>
>
Re: Can phoenix run without hadoop? (hbase standalone)
Posted by F21 <f2...@gmail.com>.
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