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 Wed, 24 Aug 2016 05:56:38 GMT
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/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
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>

Mime
View raw message