phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Cheyenne Forbes <cheyenne.osanu.for...@gmail.com>
Subject Re: Can phoenix run without hadoop? (hbase standalone)
Date Wed, 31 Aug 2016 10:02:23 GMT
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 <
cheyenne.osanu.forbes@gmail.com> 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: cheyenne.osanu.forbes@gmail.com
> Mobile: 876-881-7889
> skype: cheyenne.forbes1
>
>
>
> On Sat, Aug 27, 2016 at 12:31 AM, Cheyenne Forbes <
> cheyenne.osanu.forbes@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.groups@gmail.com> wrote:
>> >
>> > You probably need to export some environment variables for HBase to
>> point things to the right place, so that it can use its own bundled hadoop
>> libraries:
>> >
>> > export HBASE_CONF_DIR=/opt/hbase/conf
>> > export HBASE_CP=/opt/hbase/lib
>> > export HBASE_HOME=/opt/hbase
>> >
>> > On 24/08/2016 3:56 PM, Cheyenne Forbes wrote:
>> >
>> > this is what I see:
>> >
>> > 2016-08-24 00:14:45,079 WARN org.apache.hadoop.util.NativeCodeLoader:
>> Unable to load native-hadoop library for your platform.$
>> > 2016-08-24 00:14:58,479 INFO org.apache.phoenix.metrics.Metrics:
>> Initializing metrics system: phoenix
>> > 2016-08-24 00:14:59,065 WARN org.apache.hadoop.metrics2.impl.MetricsConfig:
>> Cannot locate configuration: tried hadoop-metrics$
>> > 2016-08-24 00:14:59,695 INFO org.apache.hadoop.metrics2.impl.MetricsSystemImpl:
>> Scheduled snapshot period at 10 second(s).
>> > 2016-08-24 00:14:59,695 INFO org.apache.hadoop.metrics2.impl.MetricsSystemImpl:
>> phoenix metrics system started
>> > 2016-08-24 00:15:05,891 INFO org.apache.phoenix.query.ConnectionQueryServicesImpl:
>> Found quorum: localhost:2181
>> >
>> >
>> > Regards,
>> >
>> > Cheyenne Forbes
>> >
>> > Chief Executive Officer
>> > Avapno Omnitech
>> >
>> > Chief Operating Officer
>> > Avapno Solutions
>> >
>> > Chairman
>> > Avapno Assets, LLC
>> >
>> > Bethel Town P.O
>> > Westmoreland
>> > Jamaica
>> >
>> > Email: cheyenne.osanu.forbes@gmail.com
>> > Mobile: 876-881-7889
>> > skype: cheyenne.forbes1
>> >
>> >
>> >
>> > On Tue, Aug 23, 2016 at 7:50 PM, F21 <f21.groups@gmail.com> wrote:
>> >>
>> >> That probably means that the phoenix query server didn't start
>> correctly. Check the logs to see if there's anything interesting.
>> >>
>> >> On 24/08/2016 10:42 AM, Cheyenne Forbes wrote:
>> >>
>> >> when I run "phoenix_path/bin/sqlline-thin.py http://localhost:8765" I
>> get this error:
>> >>
>> >> java.lang.RuntimeException: java.net.ConnectException: Connection
>> refused
>> >>         at org.apache.calcite.avatica.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: cheyenne.osanu.forbes@gmail.com
>> >> Mobile: 876-881-7889
>> >> skype: cheyenne.forbes1
>> >>
>> >>
>> >>
>> >> On Tue, Aug 23, 2016 at 7:23 PM, F21 <f21.groups@gmail.com> wrote:
>> >>>
>> >>> Try running it with "bin/strart-phoenix.sh &" to force it to the
>> background.
>> >>>
>> >>>
>> >>> On 24/08/2016 10:21 AM, Cheyenne Forbes wrote:
>> >>>
>> >>> Okay, thank you, but it doesnt seem to run in the background
>> "bin/start-phoenix.sh"
>> >>>
>> >>> Regards,
>> >>>
>> >>> Cheyenne Forbes
>> >>>
>> >>> Chief Executive Officer
>> >>> Avapno Omnitech
>> >>>
>> >>> Chief Operating Officer
>> >>> Avapno Solutions
>> >>>
>> >>> Chairman
>> >>> Avapno Assets, LLC
>> >>>
>> >>> Bethel Town P.O
>> >>> Westmoreland
>> >>> Jamaica
>> >>>
>> >>> Email: cheyenne.osanu.forbes@gmail.com
>> >>> Mobile: 876-881-7889
>> >>> skype: cheyenne.forbes1
>> >>>
>> >>>
>> >>>
>> >>> On Tue, Aug 23, 2016 at 6:56 PM, F21 <f21.groups@gmail.com> wrote:
>> >>>>
>> >>>> Tephra is used for transactions in 4.7.0 and onwards. In your case,
>> ignore tephra and the transaction related settings in the configuration.
>> >>>>
>> >>>> On 24/08/2016 9:55 AM, Cheyenne Forbes wrote:
>> >>>>
>> >>>> I dont see "phoenix/bin/tephra" in phoenix version 4.4.0
>> >>>>
>> >>>> Regards,
>> >>>>
>> >>>> Cheyenne Forbes
>> >>>>
>> >>>> Chief Executive Officer
>> >>>> Avapno Omnitech
>> >>>>
>> >>>> Chief Operating Officer
>> >>>> Avapno Solutions
>> >>>>
>> >>>> Chairman
>> >>>> Avapno Assets, LLC
>> >>>>
>> >>>> Bethel Town P.O
>> >>>> Westmoreland
>> >>>> Jamaica
>> >>>>
>> >>>> Email: cheyenne.osanu.forbes@gmail.com
>> >>>> Mobile: 876-881-7889
>> >>>> skype: cheyenne.forbes1
>> >>>>
>> >>>>
>> >>>>
>> >>>> On Tue, Aug 23, 2016 at 6:16 PM, F21 <f21.groups@gmail.com>
wrote:
>> >>>>>
>> >>>>> You don't have to download the docker image. Look at the Dockerfile
>> file to see how to install phoenix with hbase in standalone mode. Then look
>> at start-hbase-phoenix.sh to see how to set up the configuration file and
>> start the services.
>> >>>>>
>> >>>>>
>> >>>>> On 24/08/2016 9:03 AM, Cheyenne Forbes wrote:
>> >>>>>
>> >>>>> I already have Hbase and Phoenix but I dont want to set up Hadoop,
>> how can I do it with what I already have? (without downloading the docker
>> file)
>> >>>>>
>> >>>>> Regards,
>> >>>>>
>> >>>>> Cheyenne Forbes
>> >>>>>
>> >>>>> Chief Executive Officer
>> >>>>> Avapno Omnitech
>> >>>>>
>> >>>>> Chief Operating Officer
>> >>>>> Avapno Solutions
>> >>>>>
>> >>>>> Chairman
>> >>>>> Avapno Assets, LLC
>> >>>>>
>> >>>>> Bethel Town P.O
>> >>>>> Westmoreland
>> >>>>> Jamaica
>> >>>>>
>> >>>>> Email: cheyenne.osanu.forbes@gmail.com
>> >>>>> Mobile: 876-881-7889
>> >>>>> skype: cheyenne.forbes1
>> >>>>>
>> >>>>>
>> >>>>>
>> >>>>> On Tue, Aug 23, 2016 at 5:49 PM, F21 <f21.groups@gmail.com>
wrote:
>> >>>>>>
>> >>>>>> It's possible to run phoenix with out hadoop using hbase
in
>> standalone mode. However, you will not be able to do bulk load, etc. The
>> safety of your data is also not guaranteed without HDFS.
>> >>>>>>
>> >>>>>> For reference, I have a docker image running hbase standalone
with
>> phoenix for testing purposes: https://github.com/Boostport/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
>> >>>>>>
>> >>>>>>
>> >>>>>
>> >>>>>
>> >>>>
>> >>>>
>> >>>
>> >>>
>> >>
>> >>
>> >
>> >
>>
>
>

Mime
View raw message