| --! qt:dataset:src1 |
| set hive.stats.column.autogather=false; |
| SET hive.vectorized.execution.enabled=true; |
| set hive.fetch.task.conversion=none; |
| |
| DESCRIBE FUNCTION character_length; |
| DESCRIBE FUNCTION EXTENDED character_length; |
| |
| DESCRIBE FUNCTION char_length; |
| DESCRIBE FUNCTION EXTENDED char_length; |
| |
| CREATE TABLE dest1_n59(len INT); |
| EXPLAIN FROM src1 INSERT OVERWRITE TABLE dest1_n59 SELECT character_length(src1.value); |
| FROM src1 INSERT OVERWRITE TABLE dest1_n59 SELECT character_length(src1.value); |
| -- SORT_BEFORE_DIFF |
| SELECT dest1_n59.* FROM dest1_n59; |
| DROP TABLE dest1_n59; |
| |
| -- Test with non-ascii characters. |
| CREATE TABLE dest1_n59(name STRING) STORED AS TEXTFILE; |
| LOAD DATA LOCAL INPATH '../../data/files/kv4.txt' INTO TABLE dest1_n59; |
| INSERT INTO dest1_n59 VALUES(NULL); |
| CREATE TABLE dest2_n13 STORED AS ORC AS SELECT * FROM dest1_n59; |
| |
| EXPLAIN SELECT character_length(dest2_n13.name) FROM dest2_n13; |
| -- SORT_BEFORE_DIFF |
| SELECT character_length(dest2_n13.name) FROM dest2_n13; |
| |
| EXPLAIN SELECT char_length(dest2_n13.name) FROM dest2_n13; |
| -- SORT_BEFORE_DIFF |
| SELECT char_length(dest2_n13.name) FROM dest2_n13; |
| DROP TABLE dest1_n59; |
| DROP TABLE dest2_n13; |