DocsHortonworks Data Platform

 

 6. New Feature:CHAR Data Type Support

Hive 0.13 supports the CHAR data type, which greatly simplifies the process of migrating data from other databases.

[Note]Note

Hive 0.13 ignores trailing whitespace characters for the CHAR data type.

The following table describes how several databases treat trailing whitespaces for the CHAR, VARCHAR, and STRING data types:

 

Table 3.5. Trailing Whitespace Characters on Various Databases

Data TypeHiveOracleSQL ServerMySQLTeradata
CHARIgnoreIgnoreIgnoreIgnoreIgnore
VARCHARCompareCompareConfigurableIgnoreIgnore
STRINGCompareN/AN/AN/AN/A


Legal notices
loading table of contents...