Re: Can phoenix run without hadoop? (hbase standalone)

F21 Tue, 23 Aug 2016 17:50:51 -0700

That probably means that the phoenix query server didn't startcorrectly. 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"; Iget this error:


java.lang.RuntimeException: java.net.ConnectException: Connection refused

atorg.apache.calcite.avatica.remote.RemoteService.apply(RemoteService.java:59)atorg.apache.calcite.avatica.remote.JsonService.apply(JsonService.java:235)atorg.apache.calcite.avatica.remote.RemoteMeta.connectionSync(RemoteMeta.java:97)atorg.apache.calcite.avatica.AvaticaConnection.getAutoCommit(AvaticaConnection.java:135)

        at sqlline.SqlLine.autocommitStatus(SqlLine.java:951)
        at sqlline.DatabaseConnection.connect(DatabaseConnection.java:178)

atsqlline.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)

atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:606)

atsqlline.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)

atjava.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)atjava.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)atjava.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)

atsun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:998)atsun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:934)atsun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:852)atsun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1302)atjava.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:468)atorg.apache.calcite.avatica.remote.RemoteService.apply(RemoteService.java:43)

        ... 18 more
java.lang.RuntimeException: java.net.ConnectException: Connection refused

        at sqlline.Commands.isolation(Commands.java:681)
        at sqlline.DatabaseConnection.connect(DatabaseConnection.java:186)

atsqlline.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)

atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:606)

atsqlline.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.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)

        ... 18 more

Building list of tables and columns for tab-completion (setfastconnect to true to skip)...

java.lang.RuntimeException: java.net.ConnectException: Connection refused

        at sqlline.SqlLine.getColumns(SqlLine.java:1098)
        at sqlline.SqlLine.getColumnNames(SqlLine.java:1122)
        at sqlline.SqlCompleter.<init>(SqlCompleter.java:81)

atsqlline.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)

atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

        at java.lang.reflect.Method.invoke(Method.java:606)

atsqlline.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.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)

        ... 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<mailto:cheyenne.osanu.for...@gmail.com>

Mobile: 876-881-7889 <tel:876-881-7889>
skype: cheyenne.forbes1

On Tue, Aug 23, 2016 at 7:23 PM, F21 <f21.gro...@gmail.com<mailto: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
    <mailto:cheyenne.osanu.for...@gmail.com>
    Mobile: 876-881-7889 <tel:876-881-7889>
    skype: cheyenne.forbes1



    On Tue, Aug 23, 2016 at 6:56 PM, F21 <f21.gro...@gmail.com
    <mailto: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
        <mailto:cheyenne.osanu.for...@gmail.com>
        Mobile: 876-881-7889 <tel:876-881-7889>
        skype: cheyenne.forbes1



        On Tue, Aug 23, 2016 at 6:16 PM, F21 <f21.gro...@gmail.com
        <mailto: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
            <mailto:cheyenne.osanu.for...@gmail.com>
            Mobile: 876-881-7889 <tel:876-881-7889>
            skype: cheyenne.forbes1



            On Tue, Aug 23, 2016 at 5:49 PM, F21
            <f21.gro...@gmail.com <mailto: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
                <https://github.com/Boostport/hbase-phoenix-all-in-one>



                On 24/08/2016 8:23 AM, Cheyenne Forbes wrote:

                what settings should be changed if I can?

                Hbase 1.1.2
                Phoenix 4.4.0
                Ubuntu 14

                *I try in this
                order* "/usr/lihbase-1.1.2/bin/start-hbase.sh"* then* 
"/usr/lib/phoenix-4.4.0/bin/queryserver.py
                start"
                *then*"/usr/lib/phoenix-4.4.0/bin/sqlline-thin.py
                http://localhost:8765 <http://localhost:8765/>"
                *but it* *gives this error:*

                java.lang.RuntimeException:
                java.net.ConnectException: Connection refused
                      at
                
org.apache.calcite.avatica.remote.RemoteService.apply(RemoteService.java:59)
                      at
                
org.apache.calcite.avatica.remote.JsonService.apply(JsonService.java:235)
                      at
                
org.apache.calcite.avatica.remote.RemoteMeta.connectionSync(RemoteMeta.java:97)
                      at
                
org.apache.calcite.avatica.AvaticaConnection.getAutoCommit(AvaticaConnection.java:135)
                      at
                sqlline.SqlLine.autocommitStatus(SqlLine.java:951)
                      at
                sqlline.DatabaseConnection.connect(DatabaseConnection.java:178)
                      at
                
sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203)
                      at sqlline.Commands.connect(Commands.java:1064)
                      at sqlline.Commands.connect(Commands.java:996)
                      at
                sun.reflect.NativeMethodAccessorImpl.invoke0(Native
                Method)
                      at
                
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
                      at
                
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
                      at
                java.lang.reflect.Method.invoke(Method.java:606)
                      at
                
sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
                      at sqlline.SqlLine.dispatch(SqlLine.java:804)
                      at sqlline.SqlLine.initArgs(SqlLine.java:588)
                      at sqlline.SqlLine.begin(SqlLine.java:656)
                      at sqlline.SqlLine.start(SqlLine.java:398)
                      at sqlline.SqlLine.main(SqlLine.java:292)
                Caused by: java.net.ConnectException: Connection
                refused
                      at
                java.net.PlainSocketImpl.socketConnect(Native Method)
                      at java.net
                
<http://java.net/>.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
                      at java.net
                
<http://java.net/>.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
                      at java.net
                
<http://java.net/>.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
                      at
                java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
                      at java.net.Socket.connect(Socket.java:579)
                      at java.net.Socket.connect(Socket.java:528)
                      at
                sun.net.NetworkClient.doConnect(NetworkClient.java:180)
                      at
                sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
                      at
                sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
                      at
                sun.net.www.http.HttpClient.<init>(HttpClient.java:211)
                      at sun.net.www.http.HttpClient.Ne
                <http://sun.net.www.http.HttpClient.Ne>w(HttpClient.java:308)
                      at sun.net.www.http.HttpClient.Ne
                <http://sun.net.www.http.HttpClient.Ne>w(HttpClient.java:326)
                      at
                
sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:998)
                      at
                
sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:934)
                      at
                
sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:852)
                      at
                
sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1302)
                      at
                
java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:468)
                      at
                
org.apache.calcite.avatica.remote.RemoteService.apply(RemoteService.java:43)
                      ... 18 more
                java.lang.RuntimeException:
                java.net.ConnectException: Connection refused
                      at
                
org.apache.calcite.avatica.remote.RemoteService.apply(RemoteService.java:59)
                      at
                
org.apache.calcite.avatica.remote.JsonService.apply(JsonService.java:235)
                      at
                
org.apache.calcite.avatica.remote.RemoteMeta.connectionSync(RemoteMeta.java:97)
                      at
                
org.apache.calcite.avatica.AvaticaConnection.getTransactionIsolation(AvaticaConnection.java:190)
                      at sqlline.Commands.isolation(Commands.java:681)
                      at
                sqlline.DatabaseConnection.connect(DatabaseConnection.java:186)
                      at
                
sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203)
                      at sqlline.Commands.connect(Commands.java:1064)
                      at sqlline.Commands.connect(Commands.java:996)
                      at
                sun.reflect.NativeMethodAccessorImpl.invoke0(Native
                Method)
                      at
                
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
                      at
                
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
                      at
                java.lang.reflect.Method.invoke(Method.java:606)
                      at
                
sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
                      at sqlline.SqlLine.dispatch(SqlLine.java:804)
                      at sqlline.SqlLine.initArgs(SqlLine.java:588)
                      at sqlline.SqlLine.begin(SqlLine.java:656)
                      at sqlline.SqlLine.start(SqlLine.java:398)
                      at sqlline.SqlLine.main(SqlLine.java:292)
                Caused by: java.net.ConnectException: Connection
                refused
                      at
                java.net.PlainSocketImpl.socketConnect(Native Method)
                      at java.net
                
<http://java.net/>.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
                      at java.net
                
<http://java.net/>.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
                      at java.net
                
<http://java.net/>.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
                      at
                java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
                      at java.net.Socket.connect(Socket.java:579)
                      at java.net.Socket.connect(Socket.java:528)
                      at
                sun.net.NetworkClient.doConnect(NetworkClient.java:180)
                      at
                sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
                      at
                sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
                      at
                sun.net.www.http.HttpClient.<init>(HttpClient.java:211)
                      at sun.net.www.http.HttpClient.Ne
                <http://sun.net.www.http.HttpClient.Ne>w(HttpClient.java:308)
                      at sun.net.www.http.HttpClient.Ne
                <http://sun.net.www.http.HttpClient.Ne>w(HttpClient.java:326)
                      at
                
sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:998)
                      at
                
sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:934)
                      at
                
sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:852)
                      at
                
sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1302)
                      at
                
java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:468)
                      at
                
org.apache.calcite.avatica.remote.RemoteService.apply(RemoteService.java:43)
                      ... 18 more
                Building list of tables and columns for
                tab-completion (set fastconnect to true to skip)...
                java.lang.RuntimeException:
                java.net.ConnectException: Connection refused
                      at
                
org.apache.calcite.avatica.remote.RemoteService.apply(RemoteService.java:59)
                      at
                
org.apache.calcite.avatica.remote.JsonService.apply(JsonService.java:235)
                      at
                
org.apache.calcite.avatica.remote.RemoteMeta.connectionSync(RemoteMeta.java:97)
                      at
                
org.apache.calcite.avatica.AvaticaConnection.getCatalog(AvaticaConnection.java:182)
                      at sqlline.SqlLine.getColumns(SqlLine.java:1098)
                      at
                sqlline.SqlLine.getColumnNames(SqlLine.java:1122)
                      at
                sqlline.SqlCompleter.<init>(SqlCompleter.java:81)
                      at
                
sqlline.DatabaseConnection.setCompletions(DatabaseConnection.java:84)
                      at
                sqlline.SqlLine.setCompletions(SqlLine.java:1730)
                      at sqlline.Commands.connect(Commands.java:1066)
                      at sqlline.Commands.connect(Commands.java:996)
                      at
                sun.reflect.NativeMethodAccessorImpl.invoke0(Native
                Method)
                      at
                
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
                      at
                
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
                      at
                java.lang.reflect.Method.invoke(Method.java:606)
                      at
                
sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
                      at sqlline.SqlLine.dispatch(SqlLine.java:804)
                      at sqlline.SqlLine.initArgs(SqlLine.java:588)
                      at sqlline.SqlLine.begin(SqlLine.java:656)
                      at sqlline.SqlLine.start(SqlLine.java:398)
                      at sqlline.SqlLine.main(SqlLine.java:292)
                Caused by: java.net.ConnectException: Connection
                refused
                      at
                java.net.PlainSocketImpl.socketConnect(Native Method)
                      at java.net
                
<http://java.net/>.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:339)
                      at java.net
                
<http://java.net/>.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:200)
                      at java.net
                
<http://java.net/>.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:182)
                      at
                java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
                      at java.net.Socket.connect(Socket.java:579)
                      at java.net.Socket.connect(Socket.java:528)
                      at
                sun.net.NetworkClient.doConnect(NetworkClient.java:180)
                      at
                sun.net.www.http.HttpClient.openServer(HttpClient.java:432)
                      at
                sun.net.www.http.HttpClient.openServer(HttpClient.java:527)
                      at
                sun.net.www.http.HttpClient.<init>(HttpClient.java:211)
                      at sun.net.www.http.HttpClient.Ne
                <http://sun.net.www.http.HttpClient.Ne>w(HttpClient.java:308)
                      at sun.net.www.http.HttpClient.Ne
                <http://sun.net.www.http.HttpClient.Ne>w(HttpClient.java:326)
                      at
                
sun.net.www.protocol.http.HttpURLConnection.getNewHttpClient(HttpURLConnection.java:998)
                      at
                
sun.net.www.protocol.http.HttpURLConnection.plainConnect(HttpURLConnection.java:934)
                      at
                
sun.net.www.protocol.http.HttpURLConnection.connect(HttpURLConnection.java:852)
                      at
                
sun.net.www.protocol.http.HttpURLConnection.getInputStream(HttpURLConnection.java:1302)
                      at
                
java.net.HttpURLConnection.getResponseCode(HttpURLConnection.java:468)
                      at
                
org.apache.calcite.avatica.remote.RemoteService.apply(RemoteService.java:43)
                      ... 20 more


                Regards,
                Cheyenne Forbes

Re: Can phoenix run without hadoop? (hbase standalone)

Reply via email to