Redshift View throws "UNION data types mismatch error" when it is datashared but otherwise it works fine

0

We have a view in redshift which does UNION and it does not complain about data type mismatch but when we do a datashare of the view to another cluster and try to do a select , it gives UNION mismatch error. Why is it that the view can handle the data type conversion on it's own but throws error when it is datashared?

질문됨 6달 전265회 조회
1개 답변
0
수락된 답변

This could potentially be a bug 🐛

You should open a Support Ticket for support to take a deeper dive , and for now proceed with explicit typecasting the columns.

profile pictureAWS
답변함 6달 전
  • Thanks. I will check with support. For now we have typecast the columns.

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠