Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

To issue queries against Accumulo using Hive, four parameters must be provided by the Hive configuration:

 

Connection Parameters

accumulo.instance.name

accumulo.zookeepers
accumulo.user.name
accumulo.user.pass

 

For those familiar with Accumulo, these four configurations are the normal configuration values necessary to connect to Accumulo: the Accumulo instance name, the ZooKeeper quorum (comma-separated list of hosts), and Accumulo username and password. The easiest way to provide these values is by using the -hiveconf option to the hive command. It is expected that the Accumulo user provided either has the ability to create new tables, or that the Hive queries will only be accessing existing Accumulo tables.

...

No Format
CREATE TABLE hive_map(key int, value map<string,int>) 
STORED BY 'org.apache.hadoop.hive.accumulo.AccumuloStorageHandler'
WITH SERDEPROPERTIES (
  "accumulo.columns.mapping" = ":rowID,cf:*",
  "accumulo.default.storage" = "binary"
);

...