What is more, when partition was created before by loading file locally,
when I try to load file to this existing partition from remote machine,
it WORKS, why? Problem is with creating new partition?
Adding partition, before loading file, by alter table ... add partition
doesn't help, partiton is created, but error is the same, 'get_partition
failed'
Aleksander Siewierski / Gadu-Gadu wrote:
Edward Capriolo wrote:
Our main goal is to load partitioned data from remote hosts into
hadoop hive. Maybe you are reaching that goal in another way?
You can not load data VIA hive like this.
LOAD DATA LOCAL INPATH 'XX' attempts to load data from the node
launching hive.
If your client is the CLI this works, as the CLI is running on the
same node with the data.
If your client is though the hive-service the file would have to be
located on the machine running the hive-service, not your current host.
Edward
Problem is not with location of data files, LOAD works without defining
partition where data should be located. If you define partition, there
is error: get_partition failed: unknown result.
--
Aleksander Siewierski
