By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post

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?

Topics
DatabaseAnalytics
Tags
DatabaseAmazon Redshift
Language
English
rePost-User-4012982
asked a year ago409 views
1 Answer
0
Accepted Answer

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
EXPERT
MilindOke
answered a year ago
  • rePost-User-4012982
    a year ago

    Thanks. I will check with support. For now we have typecast the columns.

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content