phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From F21 <f21.gro...@gmail.com>
Subject Re: Can phoenix run without hadoop? (hbase standalone)
Date Wed, 24 Aug 2016 00:50:14 GMT
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 
> <mailto:cheyenne.osanu.forbes@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 
> <mailto: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
>>     <mailto:cheyenne.osanu.forbes@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
>>     <mailto: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
>>>         <mailto:cheyenne.osanu.forbes@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
>>>         <mailto: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
>>>>             <mailto:cheyenne.osanu.forbes@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 <mailto: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
>>>>                 <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
>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


Mime
View raw message