Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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

Solved Go to solution

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

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

Accepted Solutions
Highlighted

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

@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
Highlighted

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

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

Highlighted

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

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

Highlighted

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

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

Highlighted

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

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

Highlighted

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

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

Highlighted

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

@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

Highlighted

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

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

Highlighted

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

@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

Highlighted

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

Thanks. It worked

Don't have an account?
Coming from Hortonworks? Activate your account here