About arunpoy

arunpoy · ‎10-21-2016

Currently we have HDP 2.4 and it has hbase 1.1.2. But we feel Hbase 1.2 will better as few bug were fixed in that version too. I do see even HDP 2.5 has hbase version of 1.1.2. Is there a way i can upgrade hbase to 1.2 that too with ambari. I believe ambari works on the concept of Stacks. Ant thoughts on this?

arunpoy · ‎10-18-2016

Hi @Josh Elser, as a work arouns what i did was copied the phoenix 4.8 jars to the hbase classpath on all the nodes and made it work. IS it a good approach to do 😉 Also as phoenix stores all the version information on the system tables when it gets connected for the first time. Since i have been using phoenix 4.4 earlier and now 4.8 , will it cause any issues for accessign the existing data. Do i need to drop all the tables and create it back?

arunpoy · ‎10-17-2016

Thanks @Josh Elser and @Ankit Singhal. Is there a work around for this, without upgrading it to HDP 2.5 ? As upgrade involves involving lot of teams using the cluster.

arunpoy · ‎10-14-2016

When will the videos of hadoop summit, melbourne be available. I dont see the videos as of now in the hadoop summit youtube channel. Any idea?

arunpoy · ‎10-14-2016

HI @Josh Elser, i tried to do the same thing from my environment, but the results are different. I am using the phoenix utility provided by HDP 2.4. any thoughts on this $ cat booleans.csv true,1 false,0 $ /usr/hdp/2.4.0.0-169/phoenix/bin/psql.py -t BOOLTEST -h PK,TRUTH localhost:2181:/hbase-unsecure booleans.csv 0: jdbc:phoenix:localhost:2181:/hbase-unse> select * from BOOLTEST; +------------------------------------------+------------------------------------------+ | PK | TRUTH | +------------------------------------------+------------------------------------------+ | false | false | | true | false | +------------------------------------------+------------------------------------------+

arunpoy · ‎10-13-2016

I am inserting a csv file using the apache phoenix insert python utility and i have field in the phoenix table which holds a boolean value. In the csv file that value is represented as 1/0 and when it goes into phoenix it should go as true/false. but it is going as false/true. Any thoughts on this. The CSV file used as an import is generated through an ETL from mysql source.

arunpoy · ‎10-12-2016

I am frequently seeing the below message in the region server logs and the particular region server goes down. Is there any particular reason for that 2016-10-12 07:24:51,105 WARN [regionserver/hostname/10.107.107.152:16020] zookeeper.RecoverableZooKeeper: Possibly transient ZooKeeper, quorum=zk1:2181,zk2:2181,zk3:2181, exception=org.apache.zookeeper.KeeperException$SessionExpiredException: KeeperErrorCode = Session expired for /hbase-unsecure/rs/hostname,16020,1475939210143 2016-10-12 07:24:59,105 WARN [regionserver/hostname/10.107.107.152:16020] zookeeper.RecoverableZooKeeper: Possibly transient ZooKeeper, quorum=zk1:2181,zk2:2181,zk3:2181, exception=org.apache.zookeeper.KeeperException$SessionExpiredException: KeeperErrorCode = Session expired for /hbase-unsecure/rs/hostname,16020,1475939210143 2016-10-12 07:24:59,105 ERROR [regionserver/hostname/10.107.107.152:16020] zookeeper.RecoverableZooKeeper: ZooKeeper delete failed after 4 attempts 2016-10-12 07:24:59,105 WARN [regionserver/hostname/10.107.107.152:16020] regionserver.HRegionServer: Failed deleting my ephemeral node org.apache.zookeeper.KeeperException$SessionExpiredException: KeeperErrorCode = Session expired for /hbase-unsecure/rs/hostname,16020,1475939210143 at org.apache.zookeeper.KeeperException.create(KeeperException.java:127) at org.apache.zookeeper.KeeperException.create(KeeperException.java:51) at org.apache.zookeeper.ZooKeeper.delete(ZooKeeper.java:873) at org.apache.hadoop.hbase.zookeeper.RecoverableZooKeeper.delete(RecoverableZooKeeper.java:178) at org.apache.hadoop.hbase.zookeeper.ZKUtil.deleteNode(ZKUtil.java:1221) at org.apache.hadoop.hbase.zookeeper.ZKUtil.deleteNode(ZKUtil.java:1210) at org.apache.hadoop.hbase.regionserver.HRegionServer.deleteMyEphemeralNode(HRegionServer.java:1403) at org.apache.hadoop.hbase.regionserver.HRegionServer.run(HRegionServer.java:1079) at java.lang.Thread.run(Thread.java:745) 2016-10-12 07:24:59,108 INFO [regionserver/hostname/10.107.107.152:16020] regionserver.HRegionServer: stopping server hostname,16020,1475939210143; zookeeper connection closed. 2016-10-12 07:24:59,108 INFO [regionserver/hostname/10.107.107.152:16020] regionserver.HRegionServer: regionserver/hostname/10.107.107.152:16020 exiting 2016-10-12 07:24:59,108 ERROR [main] regionserver.HRegionServerCommandLine: Region server exiting java.lang.RuntimeException: HRegionServer Aborted at org.apache.hadoop.hbase.regionserver.HRegionServerCommandLine.start(HRegionServerCommandLine.java:68) at org.apache.hadoop.hbase.regionserver.HRegionServerCommandLine.run(HRegionServerCommandLine.java:87) at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:76) at org.apache.hadoop.hbase.util.ServerCommandLine.doMain(ServerCommandLine.java:126) at org.apache.hadoop.hbase.regionserver.HRegionServer.main(HRegionServer.java:2651)

arunpoy · ‎09-30-2016

We had a 5 node cluster (2 master and 3 slave nodes). Recently we added 4 more slave nodes. all of this is through ambari. One strange thing we noticed is in all the existing 5 nodes , the /etc/hadoop/conf/slaves and /etc/hbase/conf/regionservers didnt get the entries of the newly added nodes (they have only the 3 slave entries). but the newly added nodes have all the entries for all the 7 hosts. why is it so? I believe this will cause an issue when we restart. start/stop the hbase service. but amabri dashboard shows all 7 slaves and we are able to run jobs on all 7 slaves too.

arunpoy · ‎09-29-2016

can the feature of node labels and yarn queues be used together to get some multi tenancy benefits in the HDP cluster.

arunpoy · ‎09-17-2016

Is there a way to copy hbase( phoenix) tables from one cluster to the other. If so can anyone tell what is the best option?

Online	Offline
Last Visited	‎03-14-2019 05:48 AM

Member Since	‎01-21-2016 11:26 AM
Last Visited	‎03-14-2019 05:48 AM
Posts	290
Kudos received	76

Cloudera Community

Re: Dead region server showing on ambari even afte...

Re: Zeppelin phoenix error

Re: job history not available

Upgrading of individual components through ambari

Re: phoenix upsert boolean values

Re: phoenix upsert boolean values

Hadoop summit Melbourne videos

Re: phoenix upsert boolean values

phoenix upsert boolean values

hbase region server going down

addition of nodes doesnt update the slave and regi...

node labels and queues

hbase table copy from one cluster to other