hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bill Graham <>
Subject Re: Hive JDBC client and "LOAD LOCAL DATA IN PATH"
Date Mon, 01 Jun 2009 23:18:18 GMT
FYI, I was mistaken re my second issue. The file permissions do seem to be
correct. They are owned by the JDBC user. The first issue re the LOAD DATA
LOCAL INPATH is still valid though.

On Mon, Jun 1, 2009 at 3:19 PM, Bill Graham <> wrote:

> Hi,
> I've been testing the Hive JDBC client and I think I've come a across a few
> bugs, but I wanted to double check my understanding of the expected behavior
> before opening JIRAs. I'm running the hive server on my namenode host and a
> Hive JDBC test on a separate machine, as a different user. In my tests I
> create a table, load data into it, query it and finally drop the table, very
> similar to how the JDBC example does on the Hive wiki.
> All works well except the following:
> - The LOAD DATA LOCAL INPATH 'foo.txt' command causes the hive server to
> look for foo.txt on it's local filesystem, instead receiving the file from
> the JDBC client's filesystem. I'd expect that the functionality would be
> similar to that of the hive shell, where the file is submitted from the
> client.
> - The permissions of the Hive tables created are bound to the user running
> the Hive server, as opposed to the permissions of the JDBC user.
> Are these bugs or features? I suspect if I ran the Hive server on the same
> machine as my JDBC client, things would work as expected. Is that the
> intended usage of the Hive server? One Hive server per JDBC client on each
> client node? I couldn't find much documentation on the Hive server, so it's
> possible I'm using it in ways other than was intented.
> thanks,
> Bill

View raw message