Can you give me top 50 min, max and the average. Also did you try the query ? What was the behaviour ? The reason I am asking that if your query is very long using a few number of reducer for example it may imply the skew and so to maximize usage of the cluster one way is too look at surrogate key creation. ... View more

plz run that SELECT snapshot_id, COUNT(*) FROM factsamplevalue GROUP BY snapshot_id SELECT snapshot_id, COUNT(*) FROM DimSnapshot GROUP BY snapshot_id and if you can get an histogram, thanks ... View more

I understand but I would like to know if there is a data skew, telling me the max and the min, avg, perhaps a histogram will help me ... View more

Can you try to INSERT values in one table in Oracle (test) I guess you have GRANT since you have created tables but just to be sure. ... View more

Hello, I can help you to make this query works on your infrastructure. Can you give me the result of the number of element per key (for t.snapshot_id = f.snapshot_id), ie : how many time I will find the same key on both table. Not sure Indexes will help here first. There are several ways to optimize Hive query (like creating surrogate key) but we will check all option / parameter going forward. Kind regards. ... View more

Can you check you have tables created in the Oracle instance ? ... View more

Hello @Joshua Adeleke, I have seen some issues with Oracle and some of our components depending on the version. I will try to gather more information about this case. ... View more

Excellent @Ali Bajwa ... View more