1 of 1 people found this helpful
Its really difficult to say without seeing the underlying data. I would suggest take sample data from both the sources and put it in an excel workbook and try to join. If you get success with the sample then you're good to go with the original sources. If you're fail in that then there is something wrong in the joining condition.
This is what I could suggest.
I tried taking sample data from both the databases into Excel and what I'am seeing is, the joins are working in excel but not in cross database joins. In Excel I'am getting the values of measure of vertica with hive data but when I'am doing the same thing in databases and putting the same condition it is not showing any data.
Do you have any idea on this?
I don't have much expertise in such database environments. However, if there is any provision to bring Vertica data source table in Hive db then write the join query in hive for validation. If you are able get the result then there is nothing wrong in the query. Another way you can try with blend instead of joining. This is what I could suggest. If still no success then wait for other experts suggestion or check with tableau support team regarding this issue.
Thanks For your reply and I've raised a ticket regarding this issue to Tableau support team let's see what happens.
Thank You So Much Mahfooj