Page History

...

• HiveServer2 web
  • Accessed on browser at http://localhost:10002/
• Beeline:

    docker exec -it hiveserver2 beeline -u 'jdbc:hive2://hiveserver2:10000/'
    # If beeline is installed on host machine, HiveServer2 can be simply reached via:
    beeline -u 'jdbc:hive2://localhost:10000/'
  

• Run some queries

    show tables;
    create table hive_example(a string, b int) partitioned by(c int);
    alter table hive_example add partition(c=1);
    insert into hive_example partition(c=1) values('a', 1), ('a', 2),('b',3);
    select count(distinct a) from hive_example;
    select sum(b) from hive_example;