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 ?
Hi @alain TSAFACK. Can you provide more details about your environment? Please include the following:
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/