CHAR data type support

Knowing how Hive supports the CHAR data type compared to other databases is critical during migration.

Table 1. Trailing Whitespace Characters on Various Databases
Data Type	Hive	Oracle	SQL Server	MySQL	Teradata
CHAR	Ignore	Ignore	Ignore	Ignore	Ignore
VARCHAR	Compare	Compare	Configurable	Ignore	Ignore
STRING	Compare	N/A	N/A	N/A	N/A