8 Replies Latest reply on Mar 2, 2018 11:23 AM by arvindgarg

    Type Mismatch on Join

    Brian Fornelius

      Hi all.

       

      I am trying to join a Redshift Custom SQL to a MySQL Database and am running into a type mismatch.

       

      On connecting the field in MySQL shows it as a 'Number (decimal) the Custom SQL displays it as Number (whole).   Even if I try to change the field type is still remains mismatched and the only think that looks different is the default.

       

      MySQL

      RedShift Custom SQL

      How do I change one of the other so that they will match.   I read that you can create a calculation or something but I'm not sure how to even go about doing that.

       

      Thanks,

      --B