README.md

Simple CLI client for HMS Metastore.

Installation

mvn clean install -Pdist

You can run tests as well. Just set HMS_HOST environment variable to some HMS instance which is capable of running your requests (non-kerberised one) and run

mvn install

target directory has mega-jars which have all the dependencies.

Alternatively you can use bin/hclient script which use Maven to run the code.

Hclient Usage

usage: hclient list|create|addpart <options> [name:type...]
 -conf <arg>             configuration directory
 -d,--database <arg>     database name (can be regexp for list)
 -D,--drop               drop table if exists
 -H,--host <arg>         HMS Server
 -h,--help               print this info
 -N,--number <arg>       number of instances
 -P,--partitions <arg>   partitions list
 -S,--pattern <arg>      table name pattern for bulk creation
 -showparts              show partitions
 -t,--table <arg>        table name (can be regexp for list)
 -v,--verbose            verbose mode

Examples

$ export HMS_HOST=host.domain.com

List all databases and tables

$ hclinent list
test.foo
test.bar
default.customers
default.impala_parquet_timestamps
default.impala_timestamps
default.sample_07
default.sample_08

List all tables in default database

$ hclient list -d default
default.customers
default.impala_parquet_timestamps
default.impala_timestamps
default.sample_07
default.sample_08
default.web_logs
default.web_logs1

List all tables with name 'impala'

$ hclient list -d default -t '.*impala.*'
default.impala_parquet_timestamps
default.impala_timestamps

List table schemas for impala tables

$ hclient list -d default -t '.*impala.*' -v
default.impala_parquet_timestamps
    ts:     timestamp

default.impala_timestamps
    ts:     timestamp

Create new table

$ hclient create -d test_db -t test_table id:int name
test_db.test_table
        id:     int
        name:   string

Create table with partitions

$ hclient create -d test_db -t test_table1 -P date,country id:int name 
test_db.test_table1
        id:     int
        name:   string
          date: string
          country:      string

Create multiple tables at once

$ hclient create -d test_db -t test_table2 -N 3 id:int name -v
test_db.test_table2_1
        id:     int
        name:   string

test_db.test_table2_2
        id:     int
        name:   string

test_db.test_table2_3
        id:     int
        name:   string