hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "charles.zhangjc@qq.com" <charles.zhan...@qq.com>
Subject problem about converting select queries to a single FETCH task
Date Thu, 28 Sep 2017 16:49:40 GMT
Hi,
    The properties are as follows. The problem is the input data size of my table is greater
than value of property hive.fetch.task.conversion.threshold, but the query is still converted
to a single fetch task. What's wrong ?

    hive.fetch.task.conversion=more
    hive.fetch.task.conversion.threshold=1073741824
    hive.limit.optimize.enable=true
    hive.limit.optimize.fetch.max=50000
    hive.limit.optimize.limit.file=10

    The execution plan for my select query is:




charles.zhangjc@qq.com
Mime
View raw message