Hive表行列分隔符与sqoop对应


CREATE TABLE TEST(
T_ID INT,
T_NAME STRING

ROW FORMAT DELIMITED FIELDS TERMINATED BY '\t'
LINES TERMINATED BY '\n'
STORED AS TEXTFILE
LOCATION '/DATA/TEST';


hive,sqoop分隔符可以按以下表选择:

微信图片_20200424102500.png