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
