N Campbell created HIVE-9536: -------------------------------- Summary: precision of a string concatenation becomes huge precision Key: HIVE-9536 URL: https://issues.apache.org/jira/browse/HIVE-9536 Project: Hive Issue Type: Bug Components: SQL Reporter: N Campbell
where CCHAR is CHAR(32) and CVCHAR is VARCHAR(32) select concat ( cchar, cchar ) from t returns a result set where the precision of the projected column is 64 meanwhile the following becomes 2147483647. select concat('1234567890' , cchar) from t meanwhile the following returns 64 select concat(lower(cchar), cchar) from t create table if not exists TCHAR ( RNUM int , CCHAR char(32 ) ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' STORED AS TEXTFILE ; create table if not exists TVCHAR ( RNUM int , CVCHAR varchar(32 ) ) ROW FORMAT DELIMITED FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' STORED AS TEXTFILE ; -- This message was sent by Atlassian JIRA (v6.3.4#6332)