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 <[email protected]> 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: [email protected] > Mobile: 876-881-7889 > skype: cheyenne.forbes1 > > > > On Tue, Aug 23, 2016 at 7:50 PM, F21 <[email protected]> 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: [email protected] >> Mobile: 876-881-7889 >> skype: cheyenne.forbes1 >> >> >> >> On Tue, Aug 23, 2016 at 7:23 PM, F21 <[email protected]> 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: [email protected] >>> Mobile: 876-881-7889 >>> skype: cheyenne.forbes1 >>> >>> >>> >>> On Tue, Aug 23, 2016 at 6:56 PM, F21 <[email protected]> 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: [email protected] >>>> Mobile: 876-881-7889 >>>> skype: cheyenne.forbes1 >>>> >>>> >>>> >>>> On Tue, Aug 23, 2016 at 6:16 PM, F21 <[email protected]> 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: [email protected] >>>>> Mobile: 876-881-7889 >>>>> skype: cheyenne.forbes1 >>>>> >>>>> >>>>> >>>>> On Tue, Aug 23, 2016 at 5:49 PM, F21 <[email protected]> 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 >>>>>> >>>>>> >>>>> >>>>> >>>> >>>> >>> >>> >> >> > >
