README.md

This is the Hortonworks HDP 3.1.0 Release of Hive 3.1 in a Docker container. No security is enabled and external data can be accessed via mounts.

To Build

$ docker build -t hdp_hive:3.1.0 .
$ docker run \
    -d --rm -p 10000:10000 \
    -v var_lib_hive:/var/lib/hive \
    -v ~/Projects/hive_docker/user_hive_data:/user/hive/data \
    hdp_hive:3.1.0

To Connect

jdbc:hive2://localhost:10000/default

Some Commands

-- Will show any directories you mounted
dfs -ls /user/hive/data;
-- Demo
-- Step 1 - Create Table
create table test(id int, c1 string, c2 string) stored as orc tblproperties('transactional'='true');
-- Step 2 - Populate With 100,000 Records
insert into test
select y.pos + 1, x.*
    from (select 'Hello' c1, 'World' c2) x	
    lateral view posexplode(split(space(999999),' ')) y;
-- Step 3 - Some Test Queries
select * from test limit 10;
select count(*) from test;
select min(id) min_id, max(id) max_id from test;