After exporting the results of a query to an output file, you may not be able to import the file back into the same definition of the accessed table. This is because the query may contain aggregates that will produce values beyond the boundaries of the original data types. In order to load the output file, you may need to create a new table with the appropriate data types for the values to be imported.

The following table shows the required data type conversions when using the binary format.

Data Type Conversions (Binary Format)
Operation	Column Data Type	Results Data Type
SUM	Tinyint Smallint Mediumint Int Bigint	BigInt
SUM	Float Double	Double
SUM	Decimal(N,M)	Decimal(18, M)
AVG	Tinyint Smallint Mediumint Int Bigint Float Double Decimal(N,M)	Double
COUNT	Tinyint Smallint Mediumint Int Bigint Float Double Decimal(N,M)	Decimal(18, 0)