Did that rewrite work with 10.0.0 and not 10.1.13 or did you move versions and change the connection at the same time? I am unable to determine if this is an issue based on the SQL or an issue based on versions or a combination of both.
The problem is with having fields of type RECORD in your tables from what I have seen so far. I was able to do all sorts of queries on my views after standard sql rewrite. It seems to be problem in tableau connector I guess.
Workaround for me is:
- replace * in your select query to include each field you need.
- rename each subfield in a record type field using 'AS' keyword
This will flatten your record type field but that works for me for now. Give it a try.