Support Questions

Find answers, ask questions, and share your expertise

Anyone familiar with accumulo word count example? I'm trying to hive accumulo integration example,

avatar
Contributor

Trying to run hive Accumulo Integration examples, but it is failing while creating the table.

hive -hiveconf accumulo.instance.name=accumulo -hiveconf accumulo.zookeepers=localhost -hiveconf accumulo.user.name=hive -hiveconf accumulo.user.pass=hive WARNING: Use "yarn jar" to launch YARN applications. 2016-01-14 13:53:15,365 WARN - [main:] ~ HiveConf of name hive.hook.dgi.url does not exist (HiveConf:2753) 2016-01-14 13:53:15,368 WARN - [main:] ~ HiveConf of name hive.cluster.name does not exist (HiveConf:2753)

hive> CREATE TABLE accumulo_table(rowid STRING, name STRING, age INT, weight DOUBLE, height INT) > STORED BY 'org.apache.hadoop.hive.accumulo.AccumuloStorageHandler' > WITH SERDEPROPERTIES('accumulo.columns.mapping' = ':rowid,person:name,person:age,person:weight,person:height'); FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeException: Instance name accumulo does not exist in zookeeper. Run "accumulo org.apache.accumulo.server.util.ListInstances" to see a list.

ERROR:

FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. java.lang.RuntimeException: Instance name accumulo does not exist in zookeeper. Run "accumulo org.apache.accumulo.server.util.ListInstances" to see a list.

1 ACCEPTED SOLUTION

avatar
Super Guru

@vijaya inturi

Try stopping the service via curl first.

curl -u admin:admin -i -H 'X-Requested-By: ambari' -X PUT -d '{"RequestInfo": {"context" :"Stop ACCUMULO via REST"}, "Body": {"ServiceInfo": {"state": "INSTALLED"}}}' http://`hostname -f`:8081/api/v1/clusters/cl1/services/ACCUMULO

View solution in original post

9 REPLIES 9

avatar
Super Guru

Double check that your Accumulo instance name is actually "accumulo" as you provided. You can check the Accumulo Monitor page for this information (should be displayed at the top of the web page).

avatar
Contributor

accumulo-from-ambari.png . From ambari Installation is successful

avatar
Super Guru

The default Accumulo instance name is "hdp-accumulo-instance" IIRC. Try that.

avatar
Contributor

Thanks. The accumulo services are not starting, so I'm trying to delete accumulo service from Ambari, but delete was disabled from drop down menu. Any advise?

accumulo-error.png

avatar
Super Guru

I'm not sure. Maybe try creating a new question and tagging it specifically as Ambari.

avatar
Master Mentor
@vijaya inturi

Delete

you can try this

curl --user admin:admin -i -H "X-Requested-By: ambari" -X DELETE http://`hostname -f`:8080/api/v1/clusters/cl1/services/ACCUMULO

1 - admin:admin --> use your cluster username and password

2 - cl1 needs to be replace by your cluster name

3 - make sure ACCUMULO service name is correct

avatar
Contributor

Thanks Neeraj and Josh. Finally this command worked for me after Changing the desired state to 'installed' in hostcomponentdesiredstate,servicedesiredstate and servicecomponentdesiredstate tables for component_name like 'accumulo%'

curl --user admin:admin -i -H "X-Requested-By: ambari" -X DELETE http://`hostname -f`:8081/api/v1/clusters/cl1/services/ACCUMULO

Here is the error I got before updating the tables and after running the command.

HTTP/1.1 500 Internal Server Error Set-Cookie: AMBARISESSIONID=1uk6m8c30gnpp15bco5qkzd2l3;Path=/;HttpOnly Expires: Thu, 01 Jan 1970 00:00:00 GMT Content-Type: text/plain Content-Length: 235 Server: Jetty(8.1.17.v20150415)

{ "status" : 500, "message" : "org.apache.ambari.server.controller.spi.SystemException: An internal system exception occurred: Cannot remove ACCUMULO. Desired state STARTED is not removable. Service must be stopped or disabled."

avatar
Super Guru

@vijaya inturi

Try stopping the service via curl first.

curl -u admin:admin -i -H 'X-Requested-By: ambari' -X PUT -d '{"RequestInfo": {"context" :"Stop ACCUMULO via REST"}, "Body": {"ServiceInfo": {"state": "INSTALLED"}}}' http://`hostname -f`:8081/api/v1/clusters/cl1/services/ACCUMULO

avatar
Contributor

Thanks. It worked