hive创建分区表 指定分隔符_hive创建表指定分隔符，不支持多个字符作为分隔符...

hadoop fs -cat /tmp/liuxiaowen/1.txt

000377201207221125^^APPLE IPHONE 4S^^2

132288201210331629^^THINKING IN JAVA^^1

132288201210331629^^THIN ssss^^1111

132288201210331629^^THdd dd ddJAVA^^10

文本文件以两个尖角符作为列分隔符

hive中建表：

create external table tt(times string,

product_name string,

sale_num string

) row format delimited

fields terminated by '^^'

STORED AS TEXTFILE

location 'hdfs://nn/tmp/liuxiaowen/';

hive> select times from tt;

000377201207221125

132288201210331629

132288201210331629

132288201210331629

hive> select product_name from tt; (结果均为空字符)

OK

Time taken: 13.498 seconds

hive> select sale_num from tt;

APPLE IPHONE 4S

THINKING IN JAVA

THIN ssss

THdd dd ddJAVA

本来应该放在product_name中的值&#