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