Hadoop/Hive : Loading data from .csv on a remote machine

Question

I am having a csv file that can from a http url. Is there any way I can load it from there :-

This is what I am trying

LOAD DATA INPATH 'http://192.168.56.101:8081/TeamHalf.csv' OVERWRITE INTO TABLE csvdata;

Answer 1

Hive Load command is a follows :

LOAD DATA [LOCAL] INPATH 'filepath' [OVERWRITE] INTO TABLE tablename [PARTITION (partcol1=val1, partcol2=val2 ...)]

1) if LOCAL specified - Loads from local FS filepath

2) if no LOCAL - Loads from HDFS filepath only i.e,: filepath must refer to files within the same filesystem as the table's (or partition's) location

So Load from remote http:path won't work. refer HIVE DML . The possible way is (Staging) to load the data from remote http:path to LocalFS or HDFS , then to Hive Warehouse.