You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hbase.apache.org by Asfare <am...@hotmail.com> on 2015/05/13 12:30:08 UTC

Problems with Phoenix and HBase

Hi!

I'm very new in HBase and newer in Phoenix. 
My mainly problem currently is that:

When I try to lanch sqlline the execution crash and the client can't connect
to the server. Moreover, I think the hbase have another problem, because
when I try to use the command list in the shell sometimes recognize my
tables, sometimes not. Can you give me some advices or tips?



--
View this message in context: http://apache-hbase.679495.n3.nabble.com/Problems-with-Phoenix-and-HBase-tp4071362.html
Sent from the HBase Developer mailing list archive at Nabble.com.

Re: Problems with Phoenix and HBase

Posted by Ted Yu <yu...@gmail.com>.
Sending to Phoenix user mailing list.

Here is the thread:
http://search-hadoop.com/m/YGbbu2WzHtZBkq1

On Mon, May 18, 2015 at 7:20 AM, Asfare <am...@hotmail.com> wrote:

> Can someone give some tips?
>
>
>
> --
> View this message in context:
> http://apache-hbase.679495.n3.nabble.com/Problems-with-Phoenix-and-HBase-tp4071362p4071537.html
> Sent from the HBase Developer mailing list archive at Nabble.com.
>

Re: Problems with Phoenix and HBase

Posted by Ted Yu <yu...@gmail.com>.
Sending to Phoenix user mailing list.

Here is the thread:
http://search-hadoop.com/m/YGbbu2WzHtZBkq1

On Mon, May 18, 2015 at 7:20 AM, Asfare <am...@hotmail.com> wrote:

> Can someone give some tips?
>
>
>
> --
> View this message in context:
> http://apache-hbase.679495.n3.nabble.com/Problems-with-Phoenix-and-HBase-tp4071362p4071537.html
> Sent from the HBase Developer mailing list archive at Nabble.com.
>

RE: Problems with Phoenix and HBase

Posted by Asfare <am...@hotmail.com>.
Can someone give some tips?



--
View this message in context: http://apache-hbase.679495.n3.nabble.com/Problems-with-Phoenix-and-HBase-tp4071362p4071537.html
Sent from the HBase Developer mailing list archive at Nabble.com.

RE: Problems with Phoenix and HBase

Posted by Asfare <am...@hotmail.com>.
ZooKeeper works fine, I guess. And the standart port it's 2181. Results don't
change with the port appended. I'm trying to do the communication in a
remote desktop. It's important?



--
View this message in context: http://apache-hbase.679495.n3.nabble.com/Problems-with-Phoenix-and-HBase-tp4071362p4071486.html
Sent from the HBase Developer mailing list archive at Nabble.com.

RE: Problems with Phoenix and HBase

Posted by Siddharth Ubale <si...@syncoms.com>.
Hi,

I assume u have not given the zookeeper port in the command line.
Try with sqlline.py localhost:2181

Thnks,
Sid

-----Original Message-----
From: Asfare [mailto:amancf2@hotmail.com] 
Sent: Thursday, May 14, 2015 5:10 PM
To: hbase-dev@hadoop.apache.org
Subject: Re: Problems with Phoenix and HBase

I reinstalled the phoenix version and I follow the steps, step by step.

Now I have a new groups of errors. 

sqlline.py localhost
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
issuing: !connect jdbc:phoenix:localhost none none org.apache.phoenix.jdbc.PhoenixDriver
Connecting to jdbc:phoenix:localhost
15/05/14 12:33:09 WARN util.NativeCodeLoader: Unable to load native-hadoop library for your platform... using builtin-java classes where applicable
Error: ERROR 103 (08004): Unable to establish connection.
(state=08004,code=103)
java.sql.SQLException: ERROR 103 (08004): Unable to establish connection.
        at
org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:333)
        at
org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:133)
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:237)
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl.access$300(ConnectionQueryServicesImpl.java:147)
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(ConnectionQueryServicesImpl.java:1510)
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(ConnectionQueryServicesImpl.java:1489)
        at
org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:77)
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1489)
        at
org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:162)
        at
org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:129)
        at
org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:133)
        at sqlline.SqlLine$DatabaseConnection.connect(SqlLine.java:4650)
        at
sqlline.SqlLine$DatabaseConnection.getConnection(SqlLine.java:4701)
        at sqlline.SqlLine$Commands.connect(SqlLine.java:3942)
        at sqlline.SqlLine$Commands.connect(SqlLine.java:3851)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at
sqlline.SqlLine$ReflectiveCommandHandler.execute(SqlLine.java:2810)
        at sqlline.SqlLine.dispatch(SqlLine.java:817)
        at sqlline.SqlLine.initArgs(SqlLine.java:633)
        at sqlline.SqlLine.begin(SqlLine.java:680)
        at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441)
        at sqlline.SqlLine.main(SqlLine.java:424)
Caused by: java.io.IOException: java.lang.reflect.InvocationTargetException
        at
org.apache.hadoop.hbase.client.HConnectionManager.createConnection(HConnectionManager.java:417)
        at
org.apache.hadoop.hbase.client.HConnectionManager.createConnection(HConnectionManager.java:310)
        at
org.apache.phoenix.query.HConnectionFactory$HConnectionFactoryImpl.createConnection(HConnectionFactory.java:47)
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:235)
        ... 22 more
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
        at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
        at
org.apache.hadoop.hbase.client.HConnectionManager.createConnection(HConnectionManager.java:415)
        ... 25 more
Caused by: java.lang.ExceptionInInitializerError
        at org.apache.hadoop.hbase.ClusterId.parseFrom(ClusterId.java:64)
        at
org.apache.hadoop.hbase.zookeeper.ZKClusterId.readClusterIdZNode(ZKClusterId.java:69)
        at
org.apache.hadoop.hbase.client.ZooKeeperRegistry.getClusterId(ZooKeeperRegistry.java:83)
        at
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.retrieveClusterId(HConnectionManager.java:858)
        at
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.<init>(HConnectionManager.java:663)
        ... 30 more
Caused by: java.lang.RuntimeException: java.lang.ClassNotFoundException:
Class org.apache.hadoop.hdfs.DistributedFileSystem not found
        at
org.apache.hadoop.conf.Configuration.getClass(Configuration.java:1720)
        at
org.apache.hadoop.fs.FileSystem.getFileSystemClass(FileSystem.java:2415)
        at
org.apache.hadoop.fs.FileSystem.createFileSystem(FileSystem.java:2428)
        at org.apache.hadoop.fs.FileSystem.access$200(FileSystem.java:88)
        at
org.apache.hadoop.fs.FileSystem$Cache.getInternal(FileSystem.java:2467)
        at org.apache.hadoop.fs.FileSystem$Cache.get(FileSystem.java:2449)
        at org.apache.hadoop.fs.FileSystem.get(FileSystem.java:367)
        at org.apache.hadoop.fs.Path.getFileSystem(Path.java:287)
        at
org.apache.hadoop.hbase.util.DynamicClassLoader.<init>(DynamicClassLoader.java:104)
        at
org.apache.hadoop.hbase.protobuf.ProtobufUtil.<clinit>(ProtobufUtil.java:202)
        ... 35 more
Caused by: java.lang.ClassNotFoundException: Class org.apache.hadoop.hdfs.DistributedFileSystem not found
        at
org.apache.hadoop.conf.Configuration.getClassByName(Configuration.java:1626)
        at
org.apache.hadoop.conf.Configuration.getClass(Configuration.java:1718)
        ... 44 more
sqlline version 1.1.2
0: jdbc:phoenix:localhost>




The recourses remains up. So I suppose the problem is with the Phoenix client. I'm wrong?



--
View this message in context: http://apache-hbase.679495.n3.nabble.com/Problems-with-Phoenix-and-HBase-tp4071362p4071458.html
Sent from the HBase Developer mailing list archive at Nabble.com.

Re: Problems with Phoenix and HBase

Posted by Ted Yu <yu...@gmail.com>.
bq. Class org.apache.hadoop.hdfs.DistributedFileSystem not found

Looks like hadoop-hdfs-XX.jar is not on classpath.

FYI

On Thu, May 14, 2015 at 4:39 AM, Asfare <am...@hotmail.com> wrote:

> I reinstalled the phoenix version and I follow the steps, step by step.
>
> Now I have a new groups of errors.
>
> sqlline.py localhost
> Setting property: [isolation, TRANSACTION_READ_COMMITTED]
> issuing: !connect jdbc:phoenix:localhost none none
> org.apache.phoenix.jdbc.PhoenixDriver
> Connecting to jdbc:phoenix:localhost
> 15/05/14 12:33:09 WARN util.NativeCodeLoader: Unable to load native-hadoop
> library for your platform... using builtin-java classes where applicable
> Error: ERROR 103 (08004): Unable to establish connection.
> (state=08004,code=103)
> java.sql.SQLException: ERROR 103 (08004): Unable to establish connection.
>         at
>
> org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:333)
>         at
>
> org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:133)
>         at
>
> org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:237)
>         at
>
> org.apache.phoenix.query.ConnectionQueryServicesImpl.access$300(ConnectionQueryServicesImpl.java:147)
>         at
>
> org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(ConnectionQueryServicesImpl.java:1510)
>         at
>
> org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(ConnectionQueryServicesImpl.java:1489)
>         at
>
> org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:77)
>         at
>
> org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1489)
>         at
>
> org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:162)
>         at
>
> org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:129)
>         at
> org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:133)
>         at sqlline.SqlLine$DatabaseConnection.connect(SqlLine.java:4650)
>         at
> sqlline.SqlLine$DatabaseConnection.getConnection(SqlLine.java:4701)
>         at sqlline.SqlLine$Commands.connect(SqlLine.java:3942)
>         at sqlline.SqlLine$Commands.connect(SqlLine.java:3851)
>         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
>         at
>
> sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
>         at
>
> sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
>         at java.lang.reflect.Method.invoke(Method.java:497)
>         at
> sqlline.SqlLine$ReflectiveCommandHandler.execute(SqlLine.java:2810)
>         at sqlline.SqlLine.dispatch(SqlLine.java:817)
>         at sqlline.SqlLine.initArgs(SqlLine.java:633)
>         at sqlline.SqlLine.begin(SqlLine.java:680)
>         at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441)
>         at sqlline.SqlLine.main(SqlLine.java:424)
> Caused by: java.io.IOException: java.lang.reflect.InvocationTargetException
>         at
>
> org.apache.hadoop.hbase.client.HConnectionManager.createConnection(HConnectionManager.java:417)
>         at
>
> org.apache.hadoop.hbase.client.HConnectionManager.createConnection(HConnectionManager.java:310)
>         at
>
> org.apache.phoenix.query.HConnectionFactory$HConnectionFactoryImpl.createConnection(HConnectionFactory.java:47)
>         at
>
> org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:235)
>         ... 22 more
> Caused by: java.lang.reflect.InvocationTargetException
>         at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
> Method)
>         at
>
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
>         at
>
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>         at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
>         at
>
> org.apache.hadoop.hbase.client.HConnectionManager.createConnection(HConnectionManager.java:415)
>         ... 25 more
> Caused by: java.lang.ExceptionInInitializerError
>         at org.apache.hadoop.hbase.ClusterId.parseFrom(ClusterId.java:64)
>         at
>
> org.apache.hadoop.hbase.zookeeper.ZKClusterId.readClusterIdZNode(ZKClusterId.java:69)
>         at
>
> org.apache.hadoop.hbase.client.ZooKeeperRegistry.getClusterId(ZooKeeperRegistry.java:83)
>         at
>
> org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.retrieveClusterId(HConnectionManager.java:858)
>         at
>
> org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.<init>(HConnectionManager.java:663)
>         ... 30 more
> Caused by: java.lang.RuntimeException: java.lang.ClassNotFoundException:
> Class org.apache.hadoop.hdfs.DistributedFileSystem not found
>         at
> org.apache.hadoop.conf.Configuration.getClass(Configuration.java:1720)
>         at
> org.apache.hadoop.fs.FileSystem.getFileSystemClass(FileSystem.java:2415)
>         at
> org.apache.hadoop.fs.FileSystem.createFileSystem(FileSystem.java:2428)
>         at org.apache.hadoop.fs.FileSystem.access$200(FileSystem.java:88)
>         at
> org.apache.hadoop.fs.FileSystem$Cache.getInternal(FileSystem.java:2467)
>         at org.apache.hadoop.fs.FileSystem$Cache.get(FileSystem.java:2449)
>         at org.apache.hadoop.fs.FileSystem.get(FileSystem.java:367)
>         at org.apache.hadoop.fs.Path.getFileSystem(Path.java:287)
>         at
>
> org.apache.hadoop.hbase.util.DynamicClassLoader.<init>(DynamicClassLoader.java:104)
>         at
>
> org.apache.hadoop.hbase.protobuf.ProtobufUtil.<clinit>(ProtobufUtil.java:202)
>         ... 35 more
> Caused by: java.lang.ClassNotFoundException: Class
> org.apache.hadoop.hdfs.DistributedFileSystem not found
>         at
>
> org.apache.hadoop.conf.Configuration.getClassByName(Configuration.java:1626)
>         at
> org.apache.hadoop.conf.Configuration.getClass(Configuration.java:1718)
>         ... 44 more
> sqlline version 1.1.2
> 0: jdbc:phoenix:localhost>
>
>
>
>
> The recourses remains up. So I suppose the problem is with the Phoenix
> client. I'm wrong?
>
>
>
> --
> View this message in context:
> http://apache-hbase.679495.n3.nabble.com/Problems-with-Phoenix-and-HBase-tp4071362p4071458.html
> Sent from the HBase Developer mailing list archive at Nabble.com.
>

Re: Problems with Phoenix and HBase

Posted by Asfare <am...@hotmail.com>.
I reinstalled the phoenix version and I follow the steps, step by step.

Now I have a new groups of errors. 

sqlline.py localhost
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
issuing: !connect jdbc:phoenix:localhost none none
org.apache.phoenix.jdbc.PhoenixDriver
Connecting to jdbc:phoenix:localhost
15/05/14 12:33:09 WARN util.NativeCodeLoader: Unable to load native-hadoop
library for your platform... using builtin-java classes where applicable
Error: ERROR 103 (08004): Unable to establish connection.
(state=08004,code=103)
java.sql.SQLException: ERROR 103 (08004): Unable to establish connection.
        at
org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:333)
        at
org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:133)
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:237)
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl.access$300(ConnectionQueryServicesImpl.java:147)
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(ConnectionQueryServicesImpl.java:1510)
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl$9.call(ConnectionQueryServicesImpl.java:1489)
        at
org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:77)
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1489)
        at
org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:162)
        at
org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:129)
        at
org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:133)
        at sqlline.SqlLine$DatabaseConnection.connect(SqlLine.java:4650)
        at
sqlline.SqlLine$DatabaseConnection.getConnection(SqlLine.java:4701)
        at sqlline.SqlLine$Commands.connect(SqlLine.java:3942)
        at sqlline.SqlLine$Commands.connect(SqlLine.java:3851)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
        at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.lang.reflect.Method.invoke(Method.java:497)
        at
sqlline.SqlLine$ReflectiveCommandHandler.execute(SqlLine.java:2810)
        at sqlline.SqlLine.dispatch(SqlLine.java:817)
        at sqlline.SqlLine.initArgs(SqlLine.java:633)
        at sqlline.SqlLine.begin(SqlLine.java:680)
        at sqlline.SqlLine.mainWithInputRedirection(SqlLine.java:441)
        at sqlline.SqlLine.main(SqlLine.java:424)
Caused by: java.io.IOException: java.lang.reflect.InvocationTargetException
        at
org.apache.hadoop.hbase.client.HConnectionManager.createConnection(HConnectionManager.java:417)
        at
org.apache.hadoop.hbase.client.HConnectionManager.createConnection(HConnectionManager.java:310)
        at
org.apache.phoenix.query.HConnectionFactory$HConnectionFactoryImpl.createConnection(HConnectionFactory.java:47)
        at
org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:235)
        ... 22 more
Caused by: java.lang.reflect.InvocationTargetException
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
        at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
        at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
        at
org.apache.hadoop.hbase.client.HConnectionManager.createConnection(HConnectionManager.java:415)
        ... 25 more
Caused by: java.lang.ExceptionInInitializerError
        at org.apache.hadoop.hbase.ClusterId.parseFrom(ClusterId.java:64)
        at
org.apache.hadoop.hbase.zookeeper.ZKClusterId.readClusterIdZNode(ZKClusterId.java:69)
        at
org.apache.hadoop.hbase.client.ZooKeeperRegistry.getClusterId(ZooKeeperRegistry.java:83)
        at
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.retrieveClusterId(HConnectionManager.java:858)
        at
org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.<init>(HConnectionManager.java:663)
        ... 30 more
Caused by: java.lang.RuntimeException: java.lang.ClassNotFoundException:
Class org.apache.hadoop.hdfs.DistributedFileSystem not found
        at
org.apache.hadoop.conf.Configuration.getClass(Configuration.java:1720)
        at
org.apache.hadoop.fs.FileSystem.getFileSystemClass(FileSystem.java:2415)
        at
org.apache.hadoop.fs.FileSystem.createFileSystem(FileSystem.java:2428)
        at org.apache.hadoop.fs.FileSystem.access$200(FileSystem.java:88)
        at
org.apache.hadoop.fs.FileSystem$Cache.getInternal(FileSystem.java:2467)
        at org.apache.hadoop.fs.FileSystem$Cache.get(FileSystem.java:2449)
        at org.apache.hadoop.fs.FileSystem.get(FileSystem.java:367)
        at org.apache.hadoop.fs.Path.getFileSystem(Path.java:287)
        at
org.apache.hadoop.hbase.util.DynamicClassLoader.<init>(DynamicClassLoader.java:104)
        at
org.apache.hadoop.hbase.protobuf.ProtobufUtil.<clinit>(ProtobufUtil.java:202)
        ... 35 more
Caused by: java.lang.ClassNotFoundException: Class
org.apache.hadoop.hdfs.DistributedFileSystem not found
        at
org.apache.hadoop.conf.Configuration.getClassByName(Configuration.java:1626)
        at
org.apache.hadoop.conf.Configuration.getClass(Configuration.java:1718)
        ... 44 more
sqlline version 1.1.2
0: jdbc:phoenix:localhost>




The recourses remains up. So I suppose the problem is with the Phoenix
client. I'm wrong?



--
View this message in context: http://apache-hbase.679495.n3.nabble.com/Problems-with-Phoenix-and-HBase-tp4071362p4071458.html
Sent from the HBase Developer mailing list archive at Nabble.com.

Re: Problems with Phoenix and HBase

Posted by Alicia Shu <as...@hortonworks.com>.
Please follow the doc
http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.1.3/bk_installing_manua
lly_book/content/rpm-chap-phoenix.html and make sure your setup is all
right.

Alicia

On 5/13/15, 10:05 AM, "Asfare" <am...@hotmail.com> wrote:

>Hi, the shell problem is solved.
>
>Now the problem is this:
>sqlline.py localhost
>Setting property: [isolation, TRANSACTION_READ_COMMITTED]
>issuing: !connect jdbc:phoenix:localhost none none
>org.apache.phoenix.jdbc.PhoenixDriver
>Connecting to jdbc:phoenix:localhost
>SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
>SLF4J: Defaulting to no-operation (NOP) logger implementation
>SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further
>details.
>15/05/13 19:04:11 WARN util.NativeCodeLoader: Unable to load native-hadoop
>library for your platform... using builtin-java classes where applicable
>------------------------------------------------------------------------
>And no more
>
>
>In the other hand the master log is:
>2015-05-13 18:38:16,016 INFO  [AM.ZK.Worker-pool2-t13]
>master.RegionStates:
>Transition {3c89ac6db5c278c3d74e3801fd2b0005 state=OPENING,
>ts=1431535095997, server=myname.mycompany.com,16201,1431535081143} to
>{3c89ac6db5c278c3d74e3801fd2b0005 state=CLOSED, ts=1431535096016,
>server=myname.mycompany.com,16201,1431535081143}
>2015-05-13 18:38:16,016 WARN  [AM.ZK.Worker-pool2-t13]
>master.AssignmentManager: Can't move 3c89ac6db5c278c3d74e3801fd2b0005,
>there
>is no destination server available.
>2015-05-13 18:38:16,017 INFO  [AM.ZK.Worker-pool2-t13]
>master.RegionStates:
>Transition {3c89ac6db5c278c3d74e3801fd2b0005 state=CLOSED,
>ts=1431535096016,
>server=myname.mycompany.com,16201,1431535081143} to
>{3c89ac6db5c278c3d74e3801fd2b0005 state=OFFLINE, ts=1431535096017,
>server=myname.mycompany.com,16201,1431535081143}
>2015-05-13 18:38:16,017 INFO  [AM.ZK.Worker-pool2-t17]
>master.RegionStates:
>Transition {c76be7ccc0d249d9e9f31e6f45a9f7ab state=PENDING_OPEN,
>ts=1431535095984, server=myname.mycompany.com,16201,1431535081143} to
>{c76be7ccc0d249d9e9f31e6f45a9f7ab state=OPENING, ts=1431535096017,
>server=myname.mycompany.com,16201,1431535081143}
>2015-05-13 18:38:16,021 INFO  [AM.ZK.Worker-pool2-t13]
>master.AssignmentManager: Assigning
>dummy,,1430393911021.3c89ac6db5c278c3d74e3801fd2b0005. to
>myname.mycompany.com,16201,1431535081143
>2015-05-13 18:38:16,022 INFO  [AM.ZK.Worker-pool2-t13]
>master.RegionStates:
>Transition {3c89ac6db5c278c3d74e3801fd2b0005 state=OFFLINE,
>ts=1431535096017, server=myname.mycompany.com,16201,1431535081143} to
>{3c89ac6db5c278c3d74e3801fd2b0005 state=PENDING_OPEN, ts=1431535096022,
>server=myname.mycompany.com,16201,1431535081143}
>2015-05-13 18:38:16,026 INFO  [AM.ZK.Worker-pool2-t15]
>master.RegionStates:
>Transition {c76be7ccc0d249d9e9f31e6f45a9f7ab state=OPENING,
>ts=1431535096017, server=myname.mycompany.com,16201,1431535081143} to
>{c76be7ccc0d249d9e9f31e6f45a9f7ab state=CLOSED, ts=1431535096026,
>server=myname.mycompany.com,16201,1431535081143}
>2015-05-13 18:38:16,026 WARN  [AM.ZK.Worker-pool2-t15]
>master.AssignmentManager: Can't move c76be7ccc0d249d9e9f31e6f45a9f7ab,
>there
>is no destination server available.
>2015-05-13 18:38:16,026 INFO  [AM.ZK.Worker-pool2-t15]
>master.RegionStates:
>Transition {c76be7ccc0d249d9e9f31e6f45a9f7ab state=CLOSED,
>ts=1431535096026,
>server=myname.mycompany.com,16201,1431535081143} to
>{c76be7ccc0d249d9e9f31e6f45a9f7ab state=OFFLINE, ts=1431535096026,
>server=myname.mycompany.com,16201,1431535081143}
>2015-05-13 18:38:16,035 INFO  [AM.ZK.Worker-pool2-t15]
>master.AssignmentManager: Assigning
>dummy2,,1430396515524.c76be7ccc0d249d9e9f31e6f45a9f7ab. to
>myname.mycompany.com,16201,1431535081143
>2015-05-13 18:38:16,035 INFO  [AM.ZK.Worker-pool2-t15]
>master.RegionStates:
>Transition {c76be7ccc0d249d9e9f31e6f45a9f7ab state=OFFLINE,
>ts=1431535096026, server=myname.mycompany.com,16201,1431535081143} to
>{c76be7ccc0d249d9e9f31e6f45a9f7ab state=PENDING_OPEN, ts=1431535096035,
>server=myname.mycompany.com,16201,1431535081143}
>2015-05-13 18:38:16,040 INFO  [AM.ZK.Worker-pool2-t19]
>master.RegionStates:
>Transition {3c89ac6db5c278c3d74e3801fd2b0005 state=PENDING_OPEN,
>ts=1431535096022, server=myname.mycompany.com,16201,1431535081143} to
>{3c89ac6db5c278c3d74e3801fd2b0005 state=OPENING, ts=1431535096040,
>server=myname.mycompany.com,16201,1431535081143}
>2015-05-13 18:38:16,048 WARN  [AM.ZK.Worker-pool2-t10]
>master.RegionStates:
>Failed to open/close 3c89ac6db5c278c3d74e3801fd2b0005 on
>myname.mycompany.com,16201,1431535081143, set to FAILED_OPEN
>2015-05-13 18:38:16,048 INFO  [AM.ZK.Worker-pool2-t10]
>master.RegionStates:
>Transition {3c89ac6db5c278c3d74e3801fd2b0005 state=OPENING,
>ts=1431535096040, server=myname.mycompany.com,16201,1431535081143} to
>{3c89ac6db5c278c3d74e3801fd2b0005 state=FAILED_OPEN, ts=1431535096048,
>server=myname.mycompany.com,16201,1431535081143}
>2015-05-13 18:38:16,058 INFO  [AM.ZK.Worker-pool2-t15]
>master.RegionStates:
>Transition {c76be7ccc0d249d9e9f31e6f45a9f7ab state=PENDING_OPEN,
>ts=1431535096035, server=myname.mycompany.com,16201,1431535081143} to
>{c76be7ccc0d249d9e9f31e6f45a9f7ab state=OPENING, ts=1431535096058,
>server=myname.mycompany.com,16201,1431535081143}
>2015-05-13 18:38:16,083 INFO  [AM.ZK.Worker-pool2-t2] master.RegionStates:
>Transition {c76be7ccc0d249d9e9f31e6f45a9f7ab state=OPENING,
>ts=1431535096059, server=myname.mycompany.com,16201,1431535081143} to
>{c76be7ccc0d249d9e9f31e6f45a9f7ab state=CLOSED, ts=1431535096083,
>server=myname.mycompany.com,16201,1431535081143}
>2015-05-13 18:38:16,084 WARN  [AM.ZK.Worker-pool2-t2]
>master.AssignmentManager: Can't move c76be7ccc0d249d9e9f31e6f45a9f7ab,
>there
>is no destination server available.
>2015-05-13 18:38:16,084 INFO  [AM.ZK.Worker-pool2-t2] master.RegionStates:
>Transition {c76be7ccc0d249d9e9f31e6f45a9f7ab state=CLOSED,
>ts=1431535096084,
>server=myname.mycompany.com,16201,1431535081143} to
>{c76be7ccc0d249d9e9f31e6f45a9f7ab state=OFFLINE, ts=1431535096084,
>server=myname.mycompany.com,16201,1431535081143}
>2015-05-13 18:38:16,091 INFO  [AM.ZK.Worker-pool2-t2]
>master.AssignmentManager: Assigning
>dummy2,,1430396515524.c76be7ccc0d249d9e9f31e6f45a9f7ab. to
>myname.mycompany.com,16201,1431535081143
>2015-05-13 18:38:16,091 INFO  [AM.ZK.Worker-pool2-t2] master.RegionStates:
>Transition {c76be7ccc0d249d9e9f31e6f45a9f7ab state=OFFLINE,
>ts=1431535096084, server=myname.mycompany.com,16201,1431535081143} to
>{c76be7ccc0d249d9e9f31e6f45a9f7ab state=PENDING_OPEN, ts=1431535096091,
>server=myname.mycompany.com,16201,1431535081143}
>2015-05-13 18:38:16,114 INFO  [AM.ZK.Worker-pool2-t12]
>master.RegionStates:
>Transition {c76be7ccc0d249d9e9f31e6f45a9f7ab state=PENDING_OPEN,
>ts=1431535096091, server=myname.mycompany.com,16201,1431535081143} to
>{c76be7ccc0d249d9e9f31e6f45a9f7ab state=OPENING, ts=1431535096114,
>server=myname.mycompany.com,16201,1431535081143}
>2015-05-13 18:38:16,123 WARN  [AM.ZK.Worker-pool2-t3] master.RegionStates:
>Failed to open/close c76be7ccc0d249d9e9f31e6f45a9f7ab on
>myname.mycompany.com,16201,1431535081143, set to FAILED_OPEN
>2015-05-13 18:38:16,123 INFO  [AM.ZK.Worker-pool2-t3] master.RegionStates:
>Transition {c76be7ccc0d249d9e9f31e6f45a9f7ab state=OPENING,
>ts=1431535096114, server=myname.mycompany.com,16201,1431535081143} to
>{c76be7ccc0d249d9e9f31e6f45a9f7ab state=FAILED_OPEN, ts=1431535096123,
>server=myname.mycompany.com,16201,1431535081143}
>2015-05-13 18:38:16,327 INFO  [AM.ZK.Worker-pool2-t8] master.RegionStates:
>Transition {332b128bfbcb56e2bb27c367545a4782 state=OPENING,
>ts=1431535094252, server=myname.mycompany.com,16201,1431535081143} to
>{332b128bfbcb56e2bb27c367545a4782 state=OPEN, ts=1431535096327,
>server=myname.mycompany.com,16201,1431535081143}
>2015-05-13 18:38:16,331 INFO  [AM.ZK.Worker-pool2-t8] master.RegionStates:
>Onlined 332b128bfbcb56e2bb27c367545a4782 on
>myname.mycompany.com,16201,1431535081143
>2015-05-13 18:38:16,332 INFO  [AM.ZK.Worker-pool2-t8] master.RegionStates:
>Offlined 332b128bfbcb56e2bb27c367545a4782 from
>myname.mycompany.com,16201,1431532656741
>
>
>
>
>--
>View this message in context:
>http://apache-hbase.679495.n3.nabble.com/Problems-with-Phoenix-and-HBase-t
>p4071362p4071384.html
>Sent from the HBase Developer mailing list archive at Nabble.com.

Re: Problems with Phoenix and HBase

Posted by Asfare <am...@hotmail.com>.
Hi, the shell problem is solved. 

Now the problem is this:
sqlline.py localhost
Setting property: [isolation, TRANSACTION_READ_COMMITTED]
issuing: !connect jdbc:phoenix:localhost none none
org.apache.phoenix.jdbc.PhoenixDriver
Connecting to jdbc:phoenix:localhost
SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
SLF4J: Defaulting to no-operation (NOP) logger implementation
SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further
details.
15/05/13 19:04:11 WARN util.NativeCodeLoader: Unable to load native-hadoop
library for your platform... using builtin-java classes where applicable
------------------------------------------------------------------------
And no more


In the other hand the master log is:
2015-05-13 18:38:16,016 INFO  [AM.ZK.Worker-pool2-t13] master.RegionStates:
Transition {3c89ac6db5c278c3d74e3801fd2b0005 state=OPENING,
ts=1431535095997, server=myname.mycompany.com,16201,1431535081143} to
{3c89ac6db5c278c3d74e3801fd2b0005 state=CLOSED, ts=1431535096016,
server=myname.mycompany.com,16201,1431535081143}
2015-05-13 18:38:16,016 WARN  [AM.ZK.Worker-pool2-t13]
master.AssignmentManager: Can't move 3c89ac6db5c278c3d74e3801fd2b0005, there
is no destination server available.
2015-05-13 18:38:16,017 INFO  [AM.ZK.Worker-pool2-t13] master.RegionStates:
Transition {3c89ac6db5c278c3d74e3801fd2b0005 state=CLOSED, ts=1431535096016,
server=myname.mycompany.com,16201,1431535081143} to
{3c89ac6db5c278c3d74e3801fd2b0005 state=OFFLINE, ts=1431535096017,
server=myname.mycompany.com,16201,1431535081143}
2015-05-13 18:38:16,017 INFO  [AM.ZK.Worker-pool2-t17] master.RegionStates:
Transition {c76be7ccc0d249d9e9f31e6f45a9f7ab state=PENDING_OPEN,
ts=1431535095984, server=myname.mycompany.com,16201,1431535081143} to
{c76be7ccc0d249d9e9f31e6f45a9f7ab state=OPENING, ts=1431535096017,
server=myname.mycompany.com,16201,1431535081143}
2015-05-13 18:38:16,021 INFO  [AM.ZK.Worker-pool2-t13]
master.AssignmentManager: Assigning
dummy,,1430393911021.3c89ac6db5c278c3d74e3801fd2b0005. to
myname.mycompany.com,16201,1431535081143
2015-05-13 18:38:16,022 INFO  [AM.ZK.Worker-pool2-t13] master.RegionStates:
Transition {3c89ac6db5c278c3d74e3801fd2b0005 state=OFFLINE,
ts=1431535096017, server=myname.mycompany.com,16201,1431535081143} to
{3c89ac6db5c278c3d74e3801fd2b0005 state=PENDING_OPEN, ts=1431535096022,
server=myname.mycompany.com,16201,1431535081143}
2015-05-13 18:38:16,026 INFO  [AM.ZK.Worker-pool2-t15] master.RegionStates:
Transition {c76be7ccc0d249d9e9f31e6f45a9f7ab state=OPENING,
ts=1431535096017, server=myname.mycompany.com,16201,1431535081143} to
{c76be7ccc0d249d9e9f31e6f45a9f7ab state=CLOSED, ts=1431535096026,
server=myname.mycompany.com,16201,1431535081143}
2015-05-13 18:38:16,026 WARN  [AM.ZK.Worker-pool2-t15]
master.AssignmentManager: Can't move c76be7ccc0d249d9e9f31e6f45a9f7ab, there
is no destination server available.
2015-05-13 18:38:16,026 INFO  [AM.ZK.Worker-pool2-t15] master.RegionStates:
Transition {c76be7ccc0d249d9e9f31e6f45a9f7ab state=CLOSED, ts=1431535096026,
server=myname.mycompany.com,16201,1431535081143} to
{c76be7ccc0d249d9e9f31e6f45a9f7ab state=OFFLINE, ts=1431535096026,
server=myname.mycompany.com,16201,1431535081143}
2015-05-13 18:38:16,035 INFO  [AM.ZK.Worker-pool2-t15]
master.AssignmentManager: Assigning
dummy2,,1430396515524.c76be7ccc0d249d9e9f31e6f45a9f7ab. to
myname.mycompany.com,16201,1431535081143
2015-05-13 18:38:16,035 INFO  [AM.ZK.Worker-pool2-t15] master.RegionStates:
Transition {c76be7ccc0d249d9e9f31e6f45a9f7ab state=OFFLINE,
ts=1431535096026, server=myname.mycompany.com,16201,1431535081143} to
{c76be7ccc0d249d9e9f31e6f45a9f7ab state=PENDING_OPEN, ts=1431535096035,
server=myname.mycompany.com,16201,1431535081143}
2015-05-13 18:38:16,040 INFO  [AM.ZK.Worker-pool2-t19] master.RegionStates:
Transition {3c89ac6db5c278c3d74e3801fd2b0005 state=PENDING_OPEN,
ts=1431535096022, server=myname.mycompany.com,16201,1431535081143} to
{3c89ac6db5c278c3d74e3801fd2b0005 state=OPENING, ts=1431535096040,
server=myname.mycompany.com,16201,1431535081143}
2015-05-13 18:38:16,048 WARN  [AM.ZK.Worker-pool2-t10] master.RegionStates:
Failed to open/close 3c89ac6db5c278c3d74e3801fd2b0005 on
myname.mycompany.com,16201,1431535081143, set to FAILED_OPEN
2015-05-13 18:38:16,048 INFO  [AM.ZK.Worker-pool2-t10] master.RegionStates:
Transition {3c89ac6db5c278c3d74e3801fd2b0005 state=OPENING,
ts=1431535096040, server=myname.mycompany.com,16201,1431535081143} to
{3c89ac6db5c278c3d74e3801fd2b0005 state=FAILED_OPEN, ts=1431535096048,
server=myname.mycompany.com,16201,1431535081143}
2015-05-13 18:38:16,058 INFO  [AM.ZK.Worker-pool2-t15] master.RegionStates:
Transition {c76be7ccc0d249d9e9f31e6f45a9f7ab state=PENDING_OPEN,
ts=1431535096035, server=myname.mycompany.com,16201,1431535081143} to
{c76be7ccc0d249d9e9f31e6f45a9f7ab state=OPENING, ts=1431535096058,
server=myname.mycompany.com,16201,1431535081143}
2015-05-13 18:38:16,083 INFO  [AM.ZK.Worker-pool2-t2] master.RegionStates:
Transition {c76be7ccc0d249d9e9f31e6f45a9f7ab state=OPENING,
ts=1431535096059, server=myname.mycompany.com,16201,1431535081143} to
{c76be7ccc0d249d9e9f31e6f45a9f7ab state=CLOSED, ts=1431535096083,
server=myname.mycompany.com,16201,1431535081143}
2015-05-13 18:38:16,084 WARN  [AM.ZK.Worker-pool2-t2]
master.AssignmentManager: Can't move c76be7ccc0d249d9e9f31e6f45a9f7ab, there
is no destination server available.
2015-05-13 18:38:16,084 INFO  [AM.ZK.Worker-pool2-t2] master.RegionStates:
Transition {c76be7ccc0d249d9e9f31e6f45a9f7ab state=CLOSED, ts=1431535096084,
server=myname.mycompany.com,16201,1431535081143} to
{c76be7ccc0d249d9e9f31e6f45a9f7ab state=OFFLINE, ts=1431535096084,
server=myname.mycompany.com,16201,1431535081143}
2015-05-13 18:38:16,091 INFO  [AM.ZK.Worker-pool2-t2]
master.AssignmentManager: Assigning
dummy2,,1430396515524.c76be7ccc0d249d9e9f31e6f45a9f7ab. to
myname.mycompany.com,16201,1431535081143
2015-05-13 18:38:16,091 INFO  [AM.ZK.Worker-pool2-t2] master.RegionStates:
Transition {c76be7ccc0d249d9e9f31e6f45a9f7ab state=OFFLINE,
ts=1431535096084, server=myname.mycompany.com,16201,1431535081143} to
{c76be7ccc0d249d9e9f31e6f45a9f7ab state=PENDING_OPEN, ts=1431535096091,
server=myname.mycompany.com,16201,1431535081143}
2015-05-13 18:38:16,114 INFO  [AM.ZK.Worker-pool2-t12] master.RegionStates:
Transition {c76be7ccc0d249d9e9f31e6f45a9f7ab state=PENDING_OPEN,
ts=1431535096091, server=myname.mycompany.com,16201,1431535081143} to
{c76be7ccc0d249d9e9f31e6f45a9f7ab state=OPENING, ts=1431535096114,
server=myname.mycompany.com,16201,1431535081143}
2015-05-13 18:38:16,123 WARN  [AM.ZK.Worker-pool2-t3] master.RegionStates:
Failed to open/close c76be7ccc0d249d9e9f31e6f45a9f7ab on
myname.mycompany.com,16201,1431535081143, set to FAILED_OPEN
2015-05-13 18:38:16,123 INFO  [AM.ZK.Worker-pool2-t3] master.RegionStates:
Transition {c76be7ccc0d249d9e9f31e6f45a9f7ab state=OPENING,
ts=1431535096114, server=myname.mycompany.com,16201,1431535081143} to
{c76be7ccc0d249d9e9f31e6f45a9f7ab state=FAILED_OPEN, ts=1431535096123,
server=myname.mycompany.com,16201,1431535081143}
2015-05-13 18:38:16,327 INFO  [AM.ZK.Worker-pool2-t8] master.RegionStates:
Transition {332b128bfbcb56e2bb27c367545a4782 state=OPENING,
ts=1431535094252, server=myname.mycompany.com,16201,1431535081143} to
{332b128bfbcb56e2bb27c367545a4782 state=OPEN, ts=1431535096327,
server=myname.mycompany.com,16201,1431535081143}
2015-05-13 18:38:16,331 INFO  [AM.ZK.Worker-pool2-t8] master.RegionStates:
Onlined 332b128bfbcb56e2bb27c367545a4782 on
myname.mycompany.com,16201,1431535081143
2015-05-13 18:38:16,332 INFO  [AM.ZK.Worker-pool2-t8] master.RegionStates:
Offlined 332b128bfbcb56e2bb27c367545a4782 from
myname.mycompany.com,16201,1431532656741




--
View this message in context: http://apache-hbase.679495.n3.nabble.com/Problems-with-Phoenix-and-HBase-tp4071362p4071384.html
Sent from the HBase Developer mailing list archive at Nabble.com.

Re: Problems with Phoenix and HBase

Posted by Ted Yu <yu...@gmail.com>.
Putting dev@ to bcc

The question w.r.t. sqlline should be posted to Phoenix user mailing list.

w.r.t. question on hbase shell, can you give us more information ?
release of hbase you use
was there exception from hbase shell when no tables were returned ?
master log snippet when above happened

On Wed, May 13, 2015 at 3:30 AM, Asfare <am...@hotmail.com> wrote:

> Hi!
>
> I'm very new in HBase and newer in Phoenix.
> My mainly problem currently is that:
>
> When I try to lanch sqlline the execution crash and the client can't
> connect
> to the server. Moreover, I think the hbase have another problem, because
> when I try to use the command list in the shell sometimes recognize my
> tables, sometimes not. Can you give me some advices or tips?
>
>
>
> --
> View this message in context:
> http://apache-hbase.679495.n3.nabble.com/Problems-with-Phoenix-and-HBase-tp4071362.html
> Sent from the HBase Developer mailing list archive at Nabble.com.
>

Re: Problems with Phoenix and HBase

Posted by Ted Yu <yu...@gmail.com>.
Putting dev@ to bcc

The question w.r.t. sqlline should be posted to Phoenix user mailing list.

w.r.t. question on hbase shell, can you give us more information ?
release of hbase you use
was there exception from hbase shell when no tables were returned ?
master log snippet when above happened

On Wed, May 13, 2015 at 3:30 AM, Asfare <am...@hotmail.com> wrote:

> Hi!
>
> I'm very new in HBase and newer in Phoenix.
> My mainly problem currently is that:
>
> When I try to lanch sqlline the execution crash and the client can't
> connect
> to the server. Moreover, I think the hbase have another problem, because
> when I try to use the command list in the shell sometimes recognize my
> tables, sometimes not. Can you give me some advices or tips?
>
>
>
> --
> View this message in context:
> http://apache-hbase.679495.n3.nabble.com/Problems-with-Phoenix-and-HBase-tp4071362.html
> Sent from the HBase Developer mailing list archive at Nabble.com.
>