Attempting to create a table in Amazon Redshift with the SAS/ACCESS® Interface to JDBC returns the message, " ERROR: type 'double' does not exist"


When attempting to create a table in Amazon Redshift using SAS/ACCESS Interface to JDBC in SAS® 9.4M8 (TS1M8), you might receive the errors: 

ERROR: Error attempting to CREATE a DBMS table.   

ERROR: Execute error: com.amazon.redshift.util.RedshiftException: ERROR: type "double" does not exist. 

 

This issue occurs if the table contains a type of Double Precision. This error occurs because the Redshift Driver requires POSTGRESQL data types so the column type should be Double Precision. This error did not occur in SAS® 9.4M7 (TS1M7) and earlier because the SAS/ACCESS Interface to JDBC table metadata was gathered using a different method.