Search code examples
oracleamazon-redshiftsqldatatypes

Oracle FLOAT equivalent in Redshift


I'm moving my data from Oracle to Redshift.

What is the best option for Oracle FLOAT data type in Redshift.

The column data type that I have is FLOAT(64).


Solution

  • http://docs.aws.amazon.com/redshift/latest/dg/c_Supported_data_types.html

    http://docs.aws.amazon.com/redshift/latest/dg/r_Numeric_types201.html

    FLOAT is 8 bytes, which is 64 bits...