1、将data.txt的数据导入到t2表

  load data local inpath '/home/hadoop/training/data/input/data.txt' into table t2;

2、将/home/hadoop/training/data/input/目录下的所有文件导t3，并且覆盖t3的数据

load data  local inpath '/home/hadoop/training/data/input/' overwrite into table t3;

3、将HDFS中/input/data.txt的数据，导入t3

  load data  inpath '/input/data.txt' overwrite into table t3;

4、将数据导入到分区表

load data local inpath '/home/hadoop/training/data/input/data.txt'  into table partition_table partition(gender='M')