We are trying to ingest a csv file using pentaho kettle to a phoenix table and dont see any errors after the job execution. But the table is not showing the newly added data. Nothing on the logs too. Whereas if i commit a mistake in the upsert syntax, i do see the error. Alternatively if we use squirrel client to upsert data, it is showing success and data is in table. Any thoughts or clue. Do we need to look at any setting in the pentaho side or phoenix side. ... View more

ambari metrics collector got stopped on our machine. when we try to restart in ambari , it is failing. but when i check the processes on the machine, they are running. Also i get ambari alerts as Metrics Collector - Auto-Restart Status Metrics Collector has been auto-started 2 times since 2016-07-29 00:12:30. I do see the following error in the logs : 6:50:24,047 ERROR [main] ZooKeeperWatcher:652 - hconnection-0x5a7005d-0x156315434410005, quorum=localhost:61181, baseZNode=/ams-hbase-unsecure Received unexpected KeeperException, re-throwing exception org.apache.zookeeper.KeeperException$ConnectionLossException: KeeperErrorCode = ConnectionLoss for /ams-hbase-unsecure at org.apache.zookeeper.KeeperException.create(KeeperException.java:99) at org.apache.zookeeper.KeeperException.create(KeeperException.java:51) at org.apache.zookeeper.ZooKeeper.exists(ZooKeeper.java:1045) at org.apache.hadoop.hbase.zookeeper.RecoverableZooKeeper.exists(RecoverableZooKeeper.java:221) at org.apache.hadoop.hbase.zookeeper.ZKUtil.checkExists(ZKUtil.java:417) Opening socket connection to server localhost/127.0.0.1:61181. Will not attempt to authenticate using SASL (unknown error) even i tried reinstalling metrics collector. but it is not working. any thoughts on how to fix this. I have seen a few posts in the forum, already but none helps ... View more

We are primarily using the phoenix interface to access hbase (created tables, store and delete data). what is the best way to back up phoenix tables. Is there a way of doing it automatically in ambari or is anyone following a practice for this. ... View more

I have a requirement where i will have a 5 node permanaent cluster. ( 2 master nodes and 3 slave nodes). Hbase will be running on it. so this portion of the cluster is permanent. I have a MR load which is not frequent (once in a week). for that i need to provision additional 20 slave nodes. Once the job is complete, i need to tear off these nodes. The data on HDFS on the slave nodes can be deleted , once the job finishes. What could be the best possible way to bring the slave nodes quickly and make it as a part of the cluster. Though cloudbreak is available, our organization has no experience on it and dont want to take the risk. AWs is our cloud service provider and what is the best way to fulfill our requirement. Will the concept of AMI's in AWS be of any help in this case ... View more

I need to delete records on a phoenix table based on the join with another phoenix table. Is it possible? If so can anyone provide the syntax. i dont see a direct way of doing this ... View more