Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

perform views queries

perform views queries

Rising Star

Hello,

I created Hive views from the ORC tables and when I do a select query on the views they take too much time to return the result . I used example set hive.execution.engine = tez to optimize the view but it does not change .

I would like to win in run time .

Can you help me by offering me another solution please ?

Cordially

1 REPLY 1

Re: perform views queries

Hi @alain TSAFACK. Can you provide more details about your environment? Please include the following:

  1. Dataset sizes
  2. Number of joins
  3. Cluster size
  4. Any partitions or buckets
  5. Worker node specs

Simply turning on Tez and using ORC files is not a guarantee for acceptable performance. Here is an oldie but goodie which may help get you started. http://hortonworks.com/blog/5-ways-make-hive-queries-run-faster/

Don't have an account?
Coming from Hortonworks? Activate your account here