I decided to use docker but after executing "docker run -i -t 4044a9f77527 ./start-hbase-phoenix.sh" I get the following error (including open quote beside the colon)
" ': No such file or directory" Regards, Cheyenne Forbes On Sat, Aug 27, 2016 at 2:00 AM, Cheyenne Forbes < [email protected]> wrote: > 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: [email protected] > Mobile: 876-881-7889 > skype: cheyenne.forbes1 > > > > On Sat, Aug 27, 2016 at 12:31 AM, Cheyenne Forbes < > [email protected]> 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 <[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.rem >> ote.RemoteService.apply(RemoteService.java:59) >> >> at org.apache.calcite.avatica.rem >> ote.JsonService.apply(JsonService.java:235) >> >> at org.apache.calcite.avatica.rem >> ote.RemoteMeta.connectionSync(RemoteMeta.java:97) >> >> at org.apache.calcite.avatica.Ava >> ticaConnection.getAutoCommit(AvaticaConnection.java:135) >> >> at sqlline.SqlLine.autocommitStatus(SqlLine.java:951) >> >> at sqlline.DatabaseConnection.connect(DatabaseConnection.java: >> 178) >> >> at sqlline.DatabaseConnection.get >> Connection(DatabaseConnection.java:203) >> >> at sqlline.Commands.connect(Commands.java:1064) >> >> at sqlline.Commands.connect(Commands.java:996) >> >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> >> at sun.reflect.NativeMethodAccess >> orImpl.invoke(NativeMethodAccessorImpl.java:57) >> >> at sun.reflect.DelegatingMethodAc >> cessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> >> at java.lang.reflect.Method.invoke(Method.java:606) >> >> at sqlline.ReflectiveCommandHandl >> er.execute(ReflectiveCommandHandler.java:36) >> >> at sqlline.SqlLine.dispatch(SqlLine.java:804) >> >> at sqlline.SqlLine.initArgs(SqlLine.java:588) >> >> at sqlline.SqlLine.begin(SqlLine.java:656) >> >> at sqlline.SqlLine.start(SqlLine.java:398) >> >> at sqlline.SqlLine.main(SqlLine.java:292) >> >> Caused by: java.net.ConnectException: Connection refused >> >> at java.net.PlainSocketImpl.socketConnect(Native Method) >> >> at java.net.AbstractPlainSocketIm >> pl.doConnect(AbstractPlainSocketImpl.java:339) >> >> at java.net.AbstractPlainSocketIm >> pl.connectToAddress(AbstractPlainSocketImpl.java:200) >> >> at java.net.AbstractPlainSocketIm >> pl.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.Http >> URLConnection.getNewHttpClient(HttpURLConnection.java:998) >> >> at sun.net.www.protocol.http.Http >> URLConnection.plainConnect(HttpURLConnection.java:934) >> >> at sun.net.www.protocol.http.Http >> URLConnection.connect(HttpURLConnection.java:852) >> >> at sun.net.www.protocol.http.Http >> URLConnection.getInputStream(HttpURLConnection.java:1302) >> >> at java.net.HttpURLConnection.get >> ResponseCode(HttpURLConnection.java:468) >> >> at org.apache.calcite.avatica.rem >> ote.RemoteService.apply(RemoteService.java:43) >> >> ... 18 more >> >> java.lang.RuntimeException: java.net.ConnectException: Connection >> refused >> >> at org.apache.calcite.avatica.rem >> ote.RemoteService.apply(RemoteService.java:59) >> >> at org.apache.calcite.avatica.rem >> ote.JsonService.apply(JsonService.java:235) >> >> at org.apache.calcite.avatica.rem >> ote.RemoteMeta.connectionSync(RemoteMeta.java:97) >> >> at org.apache.calcite.avatica.Ava >> ticaConnection.getTransactionIsolation(AvaticaConnection.java:190) >> >> at sqlline.Commands.isolation(Commands.java:681) >> >> at sqlline.DatabaseConnection.connect(DatabaseConnection.java: >> 186) >> >> at sqlline.DatabaseConnection.get >> Connection(DatabaseConnection.java:203) >> >> at sqlline.Commands.connect(Commands.java:1064) >> >> at sqlline.Commands.connect(Commands.java:996) >> >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> >> at sun.reflect.NativeMethodAccess >> orImpl.invoke(NativeMethodAccessorImpl.java:57) >> >> at sun.reflect.DelegatingMethodAc >> cessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> >> at java.lang.reflect.Method.invoke(Method.java:606) >> >> at sqlline.ReflectiveCommandHandl >> er.execute(ReflectiveCommandHandler.java:36) >> >> at sqlline.SqlLine.dispatch(SqlLine.java:804) >> >> at sqlline.SqlLine.initArgs(SqlLine.java:588) >> >> at sqlline.SqlLine.begin(SqlLine.java:656) >> >> at sqlline.SqlLine.start(SqlLine.java:398) >> >> at sqlline.SqlLine.main(SqlLine.java:292) >> >> Caused by: java.net.ConnectException: Connection refused >> >> at java.net.PlainSocketImpl.socketConnect(Native Method) >> >> at java.net.AbstractPlainSocketIm >> pl.doConnect(AbstractPlainSocketImpl.java:339) >> >> at java.net.AbstractPlainSocketIm >> pl.connectToAddress(AbstractPlainSocketImpl.java:200) >> >> at java.net.AbstractPlainSocketIm >> pl.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.Http >> URLConnection.getNewHttpClient(HttpURLConnection.java:998) >> >> at sun.net.www.protocol.http.Http >> URLConnection.plainConnect(HttpURLConnection.java:934) >> >> at sun.net.www.protocol.http.Http >> URLConnection.connect(HttpURLConnection.java:852) >> >> at sun.net.www.protocol.http.Http >> URLConnection.getInputStream(HttpURLConnection.java:1302) >> >> at java.net.HttpURLConnection.get >> ResponseCode(HttpURLConnection.java:468) >> >> at org.apache.calcite.avatica.rem >> ote.RemoteService.apply(RemoteService.java:43) >> >> ... 18 more >> >> Building list of tables and columns for tab-completion (set >> fastconnect to true to skip)... >> >> java.lang.RuntimeException: java.net.ConnectException: Connection >> refused >> >> at org.apache.calcite.avatica.rem >> ote.RemoteService.apply(RemoteService.java:59) >> >> at org.apache.calcite.avatica.rem >> ote.JsonService.apply(JsonService.java:235) >> >> at org.apache.calcite.avatica.rem >> ote.RemoteMeta.connectionSync(RemoteMeta.java:97) >> >> at org.apache.calcite.avatica.Ava >> ticaConnection.getCatalog(AvaticaConnection.java:182) >> >> at sqlline.SqlLine.getColumns(SqlLine.java:1098) >> >> at sqlline.SqlLine.getColumnNames(SqlLine.java:1122) >> >> at sqlline.SqlCompleter.<init>(SqlCompleter.java:81) >> >> at sqlline.DatabaseConnection.set >> Completions(DatabaseConnection.java:84) >> >> at sqlline.SqlLine.setCompletions(SqlLine.java:1730) >> >> at sqlline.Commands.connect(Commands.java:1066) >> >> at sqlline.Commands.connect(Commands.java:996) >> >> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) >> >> at sun.reflect.NativeMethodAccess >> orImpl.invoke(NativeMethodAccessorImpl.java:57) >> >> at sun.reflect.DelegatingMethodAc >> cessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> >> at java.lang.reflect.Method.invoke(Method.java:606) >> >> at sqlline.ReflectiveCommandHandl >> er.execute(ReflectiveCommandHandler.java:36) >> >> at sqlline.SqlLine.dispatch(SqlLine.java:804) >> >> at sqlline.SqlLine.initArgs(SqlLine.java:588) >> >> at sqlline.SqlLine.begin(SqlLine.java:656) >> >> at sqlline.SqlLine.start(SqlLine.java:398) >> >> at sqlline.SqlLine.main(SqlLine.java:292) >> >> Caused by: java.net.ConnectException: Connection refused >> >> at java.net.PlainSocketImpl.socketConnect(Native Method) >> >> at java.net.AbstractPlainSocketIm >> pl.doConnect(AbstractPlainSocketImpl.java:339) >> >> at java.net.AbstractPlainSocketIm >> pl.connectToAddress(AbstractPlainSocketImpl.java:200) >> >> at java.net.AbstractPlainSocketIm >> pl.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.Http >> URLConnection.getNewHttpClient(HttpURLConnection.java:998) >> >> at sun.net.www.protocol.http.Http >> URLConnection.plainConnect(HttpURLConnection.java:934) >> >> at sun.net.www.protocol.http.Http >> URLConnection.connect(HttpURLConnection.java:852) >> >> at sun.net.www.protocol.http.Http >> URLConnection.getInputStream(HttpURLConnection.java:1302) >> >> at java.net.HttpURLConnection.get >> ResponseCode(HttpURLConnection.java:468) >> >> at org.apache.calcite.avatica.rem >> ote.RemoteService.apply(RemoteService.java:43) >> >> ... 20 more >> >> >> >> >> >> Regards, >> >> >> >> Cheyenne Forbes >> >> >> >> 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/h >> base-phoenix-all-in-one >> >>>>>> >> >>>>>> >> >>>>>> On 24/08/2016 8:23 AM, Cheyenne Forbes wrote: >> >>>>>> >> >>>>>> what settings should be changed if I can? >> >>>>>> >> >>>>>> Hbase 1.1.2 >> >>>>>> Phoenix 4.4.0 >> >>>>>> Ubuntu 14 >> >>>>>> >> >>>>>> I try in this order "/usr/lihbase-1.1.2/bin/start-hbase.sh" then >> "/usr/lib/phoenix-4.4.0/bin/queryserver.py start" >> then"/usr/lib/phoenix-4.4.0/bin/sqlline-thin.py http://localhost:8765"; >> but it gives this error: >> >>>>>> >> >>>>>> java.lang.RuntimeException: java.net.ConnectException: Connection >> refused >> >>>>>> at org.apache.calcite.avatica.rem >> ote.RemoteService.apply(RemoteService.java:59) >> >>>>>> at org.apache.calcite.avatica.rem >> ote.JsonService.apply(JsonService.java:235) >> >>>>>> at org.apache.calcite.avatica.rem >> ote.RemoteMeta.connectionSync(RemoteMeta.java:97) >> >>>>>> at org.apache.calcite.avatica.Ava >> ticaConnection.getAutoCommit(AvaticaConnection.java:135) >> >>>>>> at sqlline.SqlLine.autocommitStatus(SqlLine.java:951) >> >>>>>> at sqlline.DatabaseConnection.con >> nect(DatabaseConnection.java:178) >> >>>>>> at sqlline.DatabaseConnection.get >> Connection(DatabaseConnection.java:203) >> >>>>>> at sqlline.Commands.connect(Commands.java:1064) >> >>>>>> at sqlline.Commands.connect(Commands.java:996) >> >>>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >> Method) >> >>>>>> at sun.reflect.NativeMethodAccess >> orImpl.invoke(NativeMethodAccessorImpl.java:57) >> >>>>>> at sun.reflect.DelegatingMethodAc >> cessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> >>>>>> at java.lang.reflect.Method.invoke(Method.java:606) >> >>>>>> at sqlline.ReflectiveCommandHandl >> er.execute(ReflectiveCommandHandler.java:36) >> >>>>>> at sqlline.SqlLine.dispatch(SqlLine.java:804) >> >>>>>> at sqlline.SqlLine.initArgs(SqlLine.java:588) >> >>>>>> at sqlline.SqlLine.begin(SqlLine.java:656) >> >>>>>> at sqlline.SqlLine.start(SqlLine.java:398) >> >>>>>> at sqlline.SqlLine.main(SqlLine.java:292) >> >>>>>> Caused by: java.net.ConnectException: Connection refused >> >>>>>> at java.net.PlainSocketImpl.socketConnect(Native Method) >> >>>>>> at java.net.AbstractPlainSocketIm >> pl.doConnect(AbstractPlainSocketImpl.java:339) >> >>>>>> at java.net.AbstractPlainSocketIm >> pl.connectToAddress(AbstractPlainSocketImpl.java:200) >> >>>>>> at java.net.AbstractPlainSocketIm >> pl.connect(AbstractPlainSocketImpl.java:182) >> >>>>>> at java.net.SocksSocketImpl.conne >> ct(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.op >> enServer(HttpClient.java:432) >> >>>>>> at sun.net.www.http.HttpClient.op >> enServer(HttpClient.java:527) >> >>>>>> at sun.net.www.http.HttpClient.<init>(HttpClient.java:211) >> >>>>>> at sun.net.www.http.HttpClient.New(HttpClient.java:308) >> >>>>>> at sun.net.www.http.HttpClient.New(HttpClient.java:326) >> >>>>>> at sun.net.www.protocol.http.Http >> URLConnection.getNewHttpClient(HttpURLConnection.java:998) >> >>>>>> at sun.net.www.protocol.http.Http >> URLConnection.plainConnect(HttpURLConnection.java:934) >> >>>>>> at sun.net.www.protocol.http.Http >> URLConnection.connect(HttpURLConnection.java:852) >> >>>>>> at sun.net.www.protocol.http.Http >> URLConnection.getInputStream(HttpURLConnection.java:1302) >> >>>>>> at java.net.HttpURLConnection.get >> ResponseCode(HttpURLConnection.java:468) >> >>>>>> at org.apache.calcite.avatica.rem >> ote.RemoteService.apply(RemoteService.java:43) >> >>>>>> ... 18 more >> >>>>>> java.lang.RuntimeException: java.net.ConnectException: Connection >> refused >> >>>>>> at org.apache.calcite.avatica.rem >> ote.RemoteService.apply(RemoteService.java:59) >> >>>>>> at org.apache.calcite.avatica.rem >> ote.JsonService.apply(JsonService.java:235) >> >>>>>> at org.apache.calcite.avatica.rem >> ote.RemoteMeta.connectionSync(RemoteMeta.java:97) >> >>>>>> at org.apache.calcite.avatica.Ava >> ticaConnection.getTransactionIsolation(AvaticaConnection.java:190) >> >>>>>> at sqlline.Commands.isolation(Commands.java:681) >> >>>>>> at sqlline.DatabaseConnection.con >> nect(DatabaseConnection.java:186) >> >>>>>> at sqlline.DatabaseConnection.get >> Connection(DatabaseConnection.java:203) >> >>>>>> at sqlline.Commands.connect(Commands.java:1064) >> >>>>>> at sqlline.Commands.connect(Commands.java:996) >> >>>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >> Method) >> >>>>>> at sun.reflect.NativeMethodAccess >> orImpl.invoke(NativeMethodAccessorImpl.java:57) >> >>>>>> at sun.reflect.DelegatingMethodAc >> cessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> >>>>>> at java.lang.reflect.Method.invoke(Method.java:606) >> >>>>>> at sqlline.ReflectiveCommandHandl >> er.execute(ReflectiveCommandHandler.java:36) >> >>>>>> at sqlline.SqlLine.dispatch(SqlLine.java:804) >> >>>>>> at sqlline.SqlLine.initArgs(SqlLine.java:588) >> >>>>>> at sqlline.SqlLine.begin(SqlLine.java:656) >> >>>>>> at sqlline.SqlLine.start(SqlLine.java:398) >> >>>>>> at sqlline.SqlLine.main(SqlLine.java:292) >> >>>>>> Caused by: java.net.ConnectException: Connection refused >> >>>>>> at java.net.PlainSocketImpl.socketConnect(Native Method) >> >>>>>> at java.net.AbstractPlainSocketIm >> pl.doConnect(AbstractPlainSocketImpl.java:339) >> >>>>>> at java.net.AbstractPlainSocketIm >> pl.connectToAddress(AbstractPlainSocketImpl.java:200) >> >>>>>> at java.net.AbstractPlainSocketIm >> pl.connect(AbstractPlainSocketImpl.java:182) >> >>>>>> at java.net.SocksSocketImpl.conne >> ct(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.op >> enServer(HttpClient.java:432) >> >>>>>> at sun.net.www.http.HttpClient.op >> enServer(HttpClient.java:527) >> >>>>>> at sun.net.www.http.HttpClient.<init>(HttpClient.java:211) >> >>>>>> at sun.net.www.http.HttpClient.New(HttpClient.java:308) >> >>>>>> at sun.net.www.http.HttpClient.New(HttpClient.java:326) >> >>>>>> at sun.net.www.protocol.http.Http >> URLConnection.getNewHttpClient(HttpURLConnection.java:998) >> >>>>>> at sun.net.www.protocol.http.Http >> URLConnection.plainConnect(HttpURLConnection.java:934) >> >>>>>> at sun.net.www.protocol.http.Http >> URLConnection.connect(HttpURLConnection.java:852) >> >>>>>> at sun.net.www.protocol.http.Http >> URLConnection.getInputStream(HttpURLConnection.java:1302) >> >>>>>> at java.net.HttpURLConnection.get >> ResponseCode(HttpURLConnection.java:468) >> >>>>>> at org.apache.calcite.avatica.rem >> ote.RemoteService.apply(RemoteService.java:43) >> >>>>>> ... 18 more >> >>>>>> Building list of tables and columns for tab-completion (set >> fastconnect to true to skip)... >> >>>>>> java.lang.RuntimeException: java.net.ConnectException: Connection >> refused >> >>>>>> at org.apache.calcite.avatica.rem >> ote.RemoteService.apply(RemoteService.java:59) >> >>>>>> at org.apache.calcite.avatica.rem >> ote.JsonService.apply(JsonService.java:235) >> >>>>>> at org.apache.calcite.avatica.rem >> ote.RemoteMeta.connectionSync(RemoteMeta.java:97) >> >>>>>> at org.apache.calcite.avatica.Ava >> ticaConnection.getCatalog(AvaticaConnection.java:182) >> >>>>>> at sqlline.SqlLine.getColumns(SqlLine.java:1098) >> >>>>>> at sqlline.SqlLine.getColumnNames(SqlLine.java:1122) >> >>>>>> at sqlline.SqlCompleter.<init>(SqlCompleter.java:81) >> >>>>>> at sqlline.DatabaseConnection.set >> Completions(DatabaseConnection.java:84) >> >>>>>> at sqlline.SqlLine.setCompletions(SqlLine.java:1730) >> >>>>>> at sqlline.Commands.connect(Commands.java:1066) >> >>>>>> at sqlline.Commands.connect(Commands.java:996) >> >>>>>> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native >> Method) >> >>>>>> at sun.reflect.NativeMethodAccess >> orImpl.invoke(NativeMethodAccessorImpl.java:57) >> >>>>>> at sun.reflect.DelegatingMethodAc >> cessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) >> >>>>>> at java.lang.reflect.Method.invoke(Method.java:606) >> >>>>>> at sqlline.ReflectiveCommandHandl >> er.execute(ReflectiveCommandHandler.java:36) >> >>>>>> at sqlline.SqlLine.dispatch(SqlLine.java:804) >> >>>>>> at sqlline.SqlLine.initArgs(SqlLine.java:588) >> >>>>>> at sqlline.SqlLine.begin(SqlLine.java:656) >> >>>>>> at sqlline.SqlLine.start(SqlLine.java:398) >> >>>>>> at sqlline.SqlLine.main(SqlLine.java:292) >> >>>>>> Caused by: java.net.ConnectException: Connection refused >> >>>>>> at java.net.PlainSocketImpl.socketConnect(Native Method) >> >>>>>> at java.net.AbstractPlainSocketIm >> pl.doConnect(AbstractPlainSocketImpl.java:339) >> >>>>>> at java.net.AbstractPlainSocketIm >> pl.connectToAddress(AbstractPlainSocketImpl.java:200) >> >>>>>> at java.net.AbstractPlainSocketIm >> pl.connect(AbstractPlainSocketImpl.java:182) >> >>>>>> at java.net.SocksSocketImpl.conne >> ct(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.op >> enServer(HttpClient.java:432) >> >>>>>> at sun.net.www.http.HttpClient.op >> enServer(HttpClient.java:527) >> >>>>>> at sun.net.www.http.HttpClient.<init>(HttpClient.java:211) >> >>>>>> at sun.net.www.http.HttpClient.New(HttpClient.java:308) >> >>>>>> at sun.net.www.http.HttpClient.New(HttpClient.java:326) >> >>>>>> at sun.net.www.protocol.http.Http >> URLConnection.getNewHttpClient(HttpURLConnection.java:998) >> >>>>>> at sun.net.www.protocol.http.Http >> URLConnection.plainConnect(HttpURLConnection.java:934) >> >>>>>> at sun.net.www.protocol.http.Http >> URLConnection.connect(HttpURLConnection.java:852) >> >>>>>> at sun.net.www.protocol.http.Http >> URLConnection.getInputStream(HttpURLConnection.java:1302) >> >>>>>> at java.net.HttpURLConnection.get >> ResponseCode(HttpURLConnection.java:468) >> >>>>>> at org.apache.calcite.avatica.rem >> ote.RemoteService.apply(RemoteService.java:43) >> >>>>>> ... 20 more >> >>>>>> >> >>>>>> >> >>>>>> Regards, >> >>>>>> Cheyenne Forbes >> >>>>>> >> >>>>>> >> >>>>> >> >>>>> >> >>>> >> >>>> >> >>> >> >>> >> >> >> >> >> > >> > >> > >
