--! qt:dataset:src1
set hive.fetch.task.conversion=more;

DESCRIBE FUNCTION length;
DESCRIBE FUNCTION EXTENDED length;

CREATE TABLE dest1_n134(len INT);
EXPLAIN FROM src1 INSERT OVERWRITE TABLE dest1_n134 SELECT length(src1.value);
FROM src1 INSERT OVERWRITE TABLE dest1_n134 SELECT length(src1.value);
SELECT dest1_n134.* FROM dest1_n134;
DROP TABLE dest1_n134;

-- Test with non-ascii characters. 
CREATE TABLE dest1_n134(name STRING) STORED AS TEXTFILE;
LOAD DATA LOCAL INPATH '../../data/files/kv4.txt' INTO TABLE dest1_n134;
EXPLAIN SELECT length(dest1_n134.name) FROM dest1_n134;
SELECT length(dest1_n134.name) FROM dest1_n134;