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分隔符可以按以下表选择:
只是一点学习笔记而已
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分隔符可以按以下表选择: