Hi, I upgraded from 0.12. I saw a message similar from the issue HIVE-9382 : "Retry query with a different approach..." after displaying the results.
Your parameters solve my problem. *-hiveconf hive.fetch.task.conversion=more -hiveconf hive.fetch.task.conversion.threshold=<my table size>* or *-hiveconf hive.fetch.task.conversion=more -hiveconf hive.fetch.task.conversion.threshold=-1* Thank you Gopal, Philippe On Mon, Jan 26, 2015 at 7:13 PM, Gopal V <[email protected]> wrote: > On 1/26/15, 9:18 AM, Philippe Kernévez wrote: > > This degradation is due to this bug (requests are replayed with a full >> scan) : >> https://issues.apache.org/jira/browse/HIVE-9382 >> > > I doubt that is the issue you are hitting, if you're moving from 0.13 to > 0.14. > > You are possibly hitting HIVE-9401. To confirm that, please set the fetch > conversion to "more" and change the threshold parameters for the query > > set hive.fetch.task.conversion.threshold=<size-of-table-in-bytes>; Size of my table (imp2 is an external table, but I have exactly the same behavior with a native table) : hdfs dfs -du /source/imps2 537802181830 /source/imps2 > > > I tried to change the value of "set hive.fetch.task.conversion=none", but >> it doesn't change anything. >> > > That parameter should make performance worse, which is why that's part of > the test-case. > > Cheers, > Gopal > > -- Philippe Kernévez Directeur technique (Suisse), [email protected] +41 79 888 33 32 Retrouvez OCTO sur OCTO Talk : http://blog.octo.com OCTO Technology http://www.octo.com
