This is in the query server log: 2016-08-27 01:30:33,595 WARN org.apache.hadoop.util.NativeCodeLoader: Unable to load native-hadoop library for your platform.$ 2016-08-27 01:30:49,021 INFO org.apache.phoenix.metrics.Metrics: Initializing metrics system: phoenix 2016-08-27 01:30:49,756 WARN org.apache.hadoop.metrics2.impl.MetricsConfig: Cannot locate configuration: tried hadoop-metrics$ 2016-08-27 01:30:50,915 INFO org.apache.hadoop.metrics2.impl.MetricsSystemImpl: Scheduled snapshot period at 10 second(s). 2016-08-27 01:30:50,915 INFO org.apache.hadoop.metrics2.impl.MetricsSystemImpl: phoenix metrics system started 2016-08-27 01:30:58,688 INFO org.apache.phoenix.query.ConnectionQueryServicesImpl: Found quorum: localhost:2181 2016-08-27 01:31:56,305 INFO org.apache.hadoop.hbase.client.RpcRetryingCaller: Call exception, tries=10, retries=35, started=$ 2016-08-27 01:32:20,069 INFO org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation: Closing master proto$ 2016-08-27 01:32:20,070 INFO org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation: Closing zookeeper se$ 2016-08-27 01:33:48,561 INFO org.apache.phoenix.query.ConnectionQueryServicesImpl: Found quorum: localhost:2181 2016-08-27 01:34:02,644 INFO org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation: Closing master proto$ 2016-08-27 01:34:02,644 INFO org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation: Closing zookeeper se$ 2016-08-27 01:34:08,127 INFO org.apache.phoenix.query.ConnectionQueryServicesImpl: Found quorum: localhost:2181 2016-08-27 01:34:11,006 INFO org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation: Closing master proto$ 2016-08-27 01:34:11,007 INFO org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation: Closing zookeeper se$ 2016-08-27 01:34:13,227 INFO org.apache.phoenix.query.ConnectionQueryServicesImpl: Found quorum: localhost:2181 2016-08-27 01:34:14,035 INFO org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation: Closing master proto$ 2016-08-27 01:34:14,043 INFO org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation: Closing zookeeper se$ 2016-08-27 01:34:17,566 INFO org.eclipse.jetty.util.log: Logging initialized @243633ms 2016-08-27 01:34:33,564 INFO org.eclipse.jetty.server.Server: jetty-9.2.z-SNAPSHOT 2016-08-27 01:34:34,156 INFO org.eclipse.jetty.server.ServerConnector: Started ServerConnector@539b5b78{HTTP/1.1}{0.0.0.0:876$ 2016-08-27 01:34:34,157 INFO org.eclipse.jetty.server.Server: Started @260431ms 2016-08-27 01:34:34,157 INFO org.apache.calcite.avatica.server.HttpServer: Service listening on port 8765.
Regards, Cheyenne Forbes Chief Executive Officer Avapno Omnitech Chief Operating Officer Avapno Solutions Chairman Avapno Assets, LLC Bethel Town P.O Westmoreland Jamaica Email: cheyenne.osanu.for...@gmail.com Mobile: 876-881-7889 skype: cheyenne.forbes1 On Sat, Aug 27, 2016 at 12:31 AM, Cheyenne Forbes < cheyenne.osanu.for...@gmail.com> wrote: > I already see it in the start-hbase-phoenix.sh file > > export HBASE_CONF_DIR=/opt/hbase/conf > export HBASE_CP=/opt/hbase/lib > export HBASE_HOME=/opt/hbase > > > > On Wed, Aug 24, 2016 at 1:36 AM, F21 <f21.gro...@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.for...@gmail.com > > Mobile: 876-881-7889 > > skype: cheyenne.forbes1 > > > > > > > > On Tue, Aug 23, 2016 at 7:50 PM, F21 <f21.gro...@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.for...@gmail.com > >> Mobile: 876-881-7889 > >> skype: cheyenne.forbes1 > >> > >> > >> > >> On Tue, Aug 23, 2016 at 7:23 PM, F21 <f21.gro...@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.for...@gmail.com > >>> Mobile: 876-881-7889 > >>> skype: cheyenne.forbes1 > >>> > >>> > >>> > >>> On Tue, Aug 23, 2016 at 6:56 PM, F21 <f21.gro...@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.for...@gmail.com > >>>> Mobile: 876-881-7889 > >>>> skype: cheyenne.forbes1 > >>>> > >>>> > >>>> > >>>> On Tue, Aug 23, 2016 at 6:16 PM, F21 <f21.gro...@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.for...@gmail.com > >>>>> Mobile: 876-881-7889 > >>>>> skype: cheyenne.forbes1 > >>>>> > >>>>> > >>>>> > >>>>> On Tue, Aug 23, 2016 at 5:49 PM, F21 <f21.gro...@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 > >>>>>> > >>>>>> > >>>>> > >>>>> > >>>> > >>>> > >>> > >>> > >> > >> > > > > >