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

[#1]

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.

[#2]

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).

[#3]

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

[#4]

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

[#5]

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

[#6]

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

[#7]

@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

[#8]

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."

[#9 · Accepted solution]

@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

[#10]

Thanks. It worked