>From the Cloudera documentation *Text table considerations:*
Text data files can contain values that are longer than allowed by the VARCHAR(n) length limit. Any extra trailing characters are ignored when Impala processes those values during a query Will Trafodion behave the same way? Having the maximum limit for the individual column provides the flexibility and optimal resource utilization. However, having the limit in number of bytes for String and number of characters for Varchar could be quite confusing for the user. Selva *From:* Hans Zeller [mailto:[email protected]] *Sent:* Wednesday, May 25, 2016 6:12 PM *To:* [email protected] *Subject:* Hive STRING and VARCHAR types Hi, Here is a question on Hive data types. Ming is about to add support for Hive VARCHAR data types, in addition to the existing STRING type, but we hit a question we wanted to pose to the user community. Here is a proposed type mapping from Hive to Trafodion: *Hive type* *Trafodion type* *Max # of chars* *Size in bytes* *Existing/new* *Comments* STRING VARCHAR(n BYTES) n/4 to n n existing n is determined by the HIVE_MAX_STRING_LENGTH CQD VARCHAR(m) VARCHAR(m) m 4*m proposed Is it ok if we treat STRING and VARCHAR differently? Thanks, Ming and Hans
