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)

Reply via email to