question Re: Anyone familiar with accumulo word count example? I'm trying to hive accumulo integration example, in Archives of Support Questions (Read Only)

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

vijayainturi — Fri, 15 Jan 2016 05:52:47 GMT

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.

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

elserj — Fri, 15 Jan 2016 05:54:51 GMT

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

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

vijayainturi — Fri, 15 Jan 2016 06:00:27 GMT

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

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

elserj — Fri, 15 Jan 2016 06:03:44 GMT

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

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

vijayainturi — Mon, 18 Jan 2016 08:12:09 GMT

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

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

elserj — Mon, 18 Jan 2016 10:47:36 GMT

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

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

nsabharwal — Mon, 18 Jan 2016 10:55:38 GMT

@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

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

vijayainturi — Tue, 19 Jan 2016 01:56:06 GMT

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

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

elserj — Tue, 19 Jan 2016 02:03:07 GMT

@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

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

vijayainturi — Tue, 19 Jan 2016 02:40:29 GMT

Thanks. It worked