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