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.



      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.