hadoop - Apache Hive使用ASCII值作为分隔符创建表

Question

我需要将数据文件加载到配置单元内部表中。该文件以字符Æ作为分隔符。

我尝试提供ASCII值作为分隔符-

create table dbname.tablename (col1 Varchar(500),col2 VARCHAR(500),col3 VARCHAR(500))row format delimited fields terminated by '\306';

create table is success, But data is not loading correctly.

I have tried Dec(198), Hex(C6) and Oct(306) ASCII values for character Æ-

Sample Data :

col1DataÆcol2DataÆcol3Data

load statment :

LOAD DATA LOCAL INPATH '/path/sample.txt' OVERWRITE INTO TABLE TABLE_NAME;

Answer 1

'\198'应该可以工作。您还需要为要加载的数据添加load语句。有关加载语句示例，请参见here。

LOAD DATA LOCAL INPATH '/path/sample.txt' OVERWRITE INTO TABLE TABLE_NAME;