[ https://issues.apache.org/jira/browse/HIVE-17634?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16187229#comment-16187229 ]
Vineet Garg commented on HIVE-17634: ------------------------------------ Yes please regenerate the q files and update the review. I don't know if the above command to regenerate will work or not. I usually use the following (given the list of q files) {noformat} egrep 'TestCliDriver' $1 | perl -pe 's@.*testCliDriver_@@g' | awk '{print $1 ".q"}' | xargs -n 10 | perl -pe 's@ @,@g' | xargs -I{} mvn test -Dtest=TestCliDriver -Dtest.output.overwrite=true -Dqfile={} {noformat} This will regenerate 10 q files at a time. > Estimate the column stats even not retrieve columns from > metastore(hive.stats.fetch.column.stats as false) > ---------------------------------------------------------------------------------------------------------- > > Key: HIVE-17634 > URL: https://issues.apache.org/jira/browse/HIVE-17634 > Project: Hive > Issue Type: Bug > Reporter: liyunzhang_intel > Assignee: liyunzhang_intel > Attachments: HIVE-17634.1.patch, HIVE-17634.patch > > > in > [RelOptHiveTable#updateColStats|https://github.com/apache/hive/blob/master/ql/src/java/org/apache/hadoop/hive/ql/optimizer/calcite/RelOptHiveTable.java#L309], > we set {{fetchColStats}},{{fetchPartStats}} as true when call > {{StatsUtils.collectStatistics}} > {code} > if (!hiveTblMetadata.isPartitioned()) { > // 2.1 Handle the case for unpartitioned table. > try { > Statistics stats = StatsUtils.collectStatistics(hiveConf, null, > hiveTblMetadata, hiveNonPartitionCols, > nonPartColNamesThatRqrStats, > colStatsCached, nonPartColNamesThatRqrStats, true, true); > ... > {code} > This will cause querying columns statistic from metastore even we set > {{hive.stats.fetch.column.stats}} and {{hive.stats.fetch.partition.stats}} as > false in HiveConf. If we these two properties as false, we can not any > column statistics from metastore. Suggest to set the properties from > HiveConf. -- This message was sent by Atlassian JIRA (v6.4.14#64029)