[Hive] LOAD DATA

less than 1 minute read

LOAD DATA

-- load data from local(not HDFS)
load data local inpath'/tmp/data/table_data.txt' into table table2; -- append
load data local inpath'/tmp/data/table_data.txt' overwrite into table table3; -- clear previous data and load new data

-- load data from HDFS
load data inpath'/user/data/file.txt' into table table2;

/*
By default, tables will be created in the default hive metastore path('user/hive/warehouse')
set hive.metastore.warehouse.dir;
/*