DROP INDEX index_name {ON [MAPPING] mapping_name | ON TABLE table_name} [IF bool_expr]

        HConnection conn = HConnectionManager.newConnection();
        conn.execute("DROP INDEX fooidx ON MAPPING fooMapping");
        // OR
        conn.execute("DROP INDEX fooidx ON TABLE foo");

        // Or using the API
        conn.dropIndexForMapping("fooidx", "fooMapping");
        // or
        conn.dropIndexForTable("fooidx", "foo");