phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Cheyenne Forbes <cheyenne.osanu.for...@gmail.com>
Subject Re: Can phoenix run without hadoop? (hbase standalone)
Date Sat, 27 Aug 2016 07:00:30 GMT
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 <f21.groups@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 <f21.groups@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 <f21.groups@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 <f21.groups@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 <f21.groups@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 <f21.groups@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
> >>>>>>
> >>>>>>
> >>>>>
> >>>>>
> >>>>
> >>>>
> >>>
> >>>
> >>
> >>
> >
> >
>

Mime
View raw message