First create a table partition by warehouseid: CREATE TABLE `robot`(`robot_id` int, `robot_time` bigint, `linear_velocity` double, `track_side_error` int) partitioned by (warehouseid STRING) row format delimited fields terminated by '\t' lines terminated by '\n' stored as textfile
Then load a file to this table: load data inpath '/user/root/wanglei/one' into table wanglei_test.robot partition (warehouseid = 'one'); A MapReduce job submitted, but after the job completed, it shows: Loading data to table wanglei_test.robot partition (warehouseid=null) But i have specified the warehouseid to one. When i select the table, the warehouseid column is __HIVE_DEFAULT_PARTITION__ Thanks, Lei wangl...@geekplus.com.cn
