Which Types of Data Are Supported by FDI Databases?

FDI databases support the following types of data:

• Kafka: string
• MySQL: integer, bigint, number, varchar, char, float, date, timestamp, datetime
• Oracle: integer, bigint, number, varchar, char, float, date, timestamp
• SQL Server: integer, bigint, varchar, char, float, date, datetime
• PostgreSQL: integer, number, varchar, char, float, date, and timestamp
• MongoDB: integer, double, string, boolean, date, long, object, and array
• DIS: integer, JSON, arraystring, boolean, long, double, bigdecimal, and date
• MRS Hive: integer, bigint, string, float, timestamp, varchar, char, and date
• MRS HBase: string

Do not use varchar, char, and date for the MRS Hive database, because data will be truncated once the maximum data source length is reached.