You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Poonam Ligade <po...@gmail.com> on 2014/09/08 19:26:32 UTC
phoenix sqlline not working on hortonworks + ubuntu 12.4
Hi ,
I have installed hortonworks hadoop 2.1 on ubuntu12.4 manually.
hadoop version 2.4.0.2.1.3.0-563
hbase version 0.98.0.2.1.3.0-563-hadoop2
I have added symlinks to phoenix-core-4.0.0.2.1.3.0-563.jar inside
/hbase/lib
as well as phoenix-client.jar
added symlinks for core-site.xml and hbase-site.xml in phoenix/bin
when I am trying to connect to sqlline
sqlline.py zookeeper.quoram:2181:/hbase-unsecure.
It just hangs after printing this.
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
issuing: !connect jdbc:phoenix:localhost:2181:/hbase-unsecure none none
org.apache.phoenix.jdbc.PhoenixDriver
Connecting to jdbc:phoenix:localhost:2181:/hbase-unsecure
14/09/08 10:22:23 WARN util.NativeCodeLoader: Unable to load native-hadoop
library for your platform... using builtin-java classes where applicable
and doesn't come out until I kill it
Where should I check phoenix logs?
Any pointers?
Thanks,
Poonam.
Re: phoenix sqlline not working on hortonworks + ubuntu 12.4
Posted by Jeffrey Zhong <jz...@hortonworks.com>.
After you link phoenix-core.jar into hbase lib folder, have you restarted
region server & master? To see the log from sqlline, you need to modify
these two lines in log4j.properties file which is under the same folder as
the sqlline.py to following:
³psql.root.logger=DEBUG,console
log4j.threshold=DEBUG²
In addition, it¹s better that you start sqlline from phoenix bin folder.
From: Poonam Ligade <po...@gmail.com>
Reply-To: <us...@phoenix.apache.org>
Date: Monday, September 8, 2014 at 10:26 AM
To: <us...@phoenix.apache.org>
Subject: phoenix sqlline not working on hortonworks + ubuntu 12.4
Hi ,
I have installed hortonworks hadoop 2.1 on ubuntu12.4 manually.
hadoop version 2.4.0.2.1.3.0-563
hbase version 0.98.0.2.1.3.0-563-hadoop2
I have added symlinks to phoenix-core-4.0.0.2.1.3.0-563.jar inside
/hbase/lib
as well as phoenix-client.jar
added symlinks for core-site.xml and hbase-site.xml in phoenix/bin
when I am trying to connect to sqlline
sqlline.py zookeeper.quoram:2181:/hbase-unsecure.
It just hangs after printing this.
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
issuing: !connect jdbc:phoenix:localhost:2181:/hbase-unsecure none none
org.apache.phoenix.jdbc.PhoenixDriver
Connecting to jdbc:phoenix:localhost:2181:/hbase-unsecure
14/09/08 10:22:23 WARN util.NativeCodeLoader: Unable to load native-hadoop
library for your platform... using builtin-java classes where applicable
and doesn't come out until I kill it
Where should I check phoenix logs?
Any pointers?
Thanks,
Poonam.
--
CONFIDENTIALITY NOTICE
NOTICE: This message is intended for the use of the individual or entity to
which it is addressed and may contain information that is confidential,
privileged and exempt from disclosure under applicable law. If the reader
of this message is not the intended recipient, you are hereby notified that
any printing, copying, dissemination, distribution, disclosure or
forwarding of this communication is strictly prohibited. If you have
received this communication in error, please contact the sender immediately
and delete it from your system. Thank You.
Re: phoenix sqlline not working on hortonworks + ubuntu 12.4
Posted by Poonam Ligade <po...@gmail.com>.
Thanks Vikas,
Removing System.Catalog helped.
Thanks Jeffrey, I can see logs now.
Regards,
Poonam.
On Tue, Sep 9, 2014 at 8:49 AM, Vikas Agarwal <vi...@infoobjects.com> wrote:
> We have faced the same situation. Please check
> http://mail-archives.apache.org/mod_mbox/phoenix-user/201409.mbox/browser
> for detailed errors and solution.
>
> You don't need phoenix client jar in hbase region server lib.
>
> Also, sqlline emits error logs after a while (around 10-15 minutes).
>
>
> On Mon, Sep 8, 2014 at 10:56 PM, Poonam Ligade <po...@gmail.com>
> wrote:
>
>> Hi ,
>>
>> I have installed hortonworks hadoop 2.1 on ubuntu12.4 manually.
>> hadoop version 2.4.0.2.1.3.0-563
>> hbase version 0.98.0.2.1.3.0-563-hadoop2
>> I have added symlinks to phoenix-core-4.0.0.2.1.3.0-563.jar inside
>> /hbase/lib
>> as well as phoenix-client.jar
>> added symlinks for core-site.xml and hbase-site.xml in phoenix/bin
>>
>> when I am trying to connect to sqlline
>> sqlline.py zookeeper.quoram:2181:/hbase-unsecure.
>>
>> It just hangs after printing this.
>> Setting property: [isolation, TRANSACTION_READ_COMMITTED]
>> issuing: !connect jdbc:phoenix:localhost:2181:/hbase-unsecure none none
>> org.apache.phoenix.jdbc.PhoenixDriver
>> Connecting to jdbc:phoenix:localhost:2181:/hbase-unsecure
>> 14/09/08 10:22:23 WARN util.NativeCodeLoader: Unable to load
>> native-hadoop library for your platform... using builtin-java classes where
>> applicable
>>
>> and doesn't come out until I kill it
>>
>> Where should I check phoenix logs?
>> Any pointers?
>>
>> Thanks,
>> Poonam.
>>
>
>
>
> --
> Regards,
> Vikas Agarwal
> 91 – 9928301411
>
> InfoObjects, Inc.
> Execution Matters
> http://www.infoobjects.com
> 2041 Mission College Boulevard, #280
> Santa Clara, CA 95054
> +1 (408) 988-2000 Work
> +1 (408) 716-2726 Fax
>
>
Re: phoenix sqlline not working on hortonworks + ubuntu 12.4
Posted by Vikas Agarwal <vi...@infoobjects.com>.
We have faced the same situation. Please check
http://mail-archives.apache.org/mod_mbox/phoenix-user/201409.mbox/browser
for detailed errors and solution.
You don't need phoenix client jar in hbase region server lib.
Also, sqlline emits error logs after a while (around 10-15 minutes).
On Mon, Sep 8, 2014 at 10:56 PM, Poonam Ligade <po...@gmail.com>
wrote:
> Hi ,
>
> I have installed hortonworks hadoop 2.1 on ubuntu12.4 manually.
> hadoop version 2.4.0.2.1.3.0-563
> hbase version 0.98.0.2.1.3.0-563-hadoop2
> I have added symlinks to phoenix-core-4.0.0.2.1.3.0-563.jar inside
> /hbase/lib
> as well as phoenix-client.jar
> added symlinks for core-site.xml and hbase-site.xml in phoenix/bin
>
> when I am trying to connect to sqlline
> sqlline.py zookeeper.quoram:2181:/hbase-unsecure.
>
> It just hangs after printing this.
> Setting property: [isolation, TRANSACTION_READ_COMMITTED]
> issuing: !connect jdbc:phoenix:localhost:2181:/hbase-unsecure none none
> org.apache.phoenix.jdbc.PhoenixDriver
> Connecting to jdbc:phoenix:localhost:2181:/hbase-unsecure
> 14/09/08 10:22:23 WARN util.NativeCodeLoader: Unable to load native-hadoop
> library for your platform... using builtin-java classes where applicable
>
> and doesn't come out until I kill it
>
> Where should I check phoenix logs?
> Any pointers?
>
> Thanks,
> Poonam.
>
--
Regards,
Vikas Agarwal
91 – 9928301411
InfoObjects, Inc.
Execution Matters
http://www.infoobjects.com
2041 Mission College Boulevard, #280
Santa Clara, CA 95054
+1 (408) 988-2000 Work
+1 (408) 716-2726 Fax