| CREATE EXTERNAL TABLE tbl_chinese_chars(a int, b string, c string); |
| INSERT INTO tbl_chinese_chars values(1,'上海','徐汇'),(2,'北京','海淀'); |
| |
| CREATE EXTERNAL TABLE tbl_chinese_chars_multidelimitserde (col1 varchar(100), col2 varchar(100)) |
| ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.MultiDelimitSerDe' |
| WITH SERDEPROPERTIES ('field.delim'='|~|', 'serialization.encoding'='UTF-8') |
| STORED AS TEXTFILE; |
| INSERT INTO TABLE tbl_chinese_chars_multidelimitserde values('测试1','测试2'); |
| |
| |
| set hive.fetch.task.conversion=more; |
| EXPLAIN SELECT * FROM default.tbl_chinese_chars where b='北京'; |
| SELECT * FROM default.tbl_chinese_chars where b='北京'; |
| |
| set hive.fetch.task.conversion=none; |
| EXPLAIN SELECT * FROM default.tbl_chinese_chars where b='北京'; |
| SELECT * FROM default.tbl_chinese_chars where b='北京'; |
| |
| |
| set hive.fetch.task.conversion=more; |
| SELECT * FROM default.tbl_chinese_chars_multidelimitserde; |
| EXPLAIN SELECT * FROM default.tbl_chinese_chars_multidelimitserde where col1 = '测试1'; |
| SELECT * FROM default.tbl_chinese_chars_multidelimitserde where col1 = '测试1'; |
| |
| |
| set hive.fetch.task.conversion=none; |
| SELECT * FROM default.tbl_chinese_chars_multidelimitserde; |
| EXPLAIN SELECT * FROM default.tbl_chinese_chars_multidelimitserde where col1 = '测试1'; |
| SELECT * FROM default.tbl_chinese_chars_multidelimitserde where col1 = '测试1'; |