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 05:31:49 GMT
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