hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Somasundara, Ashwin" <Ashwin.HolenarasipurSomasund...@fmr.com>
Subject Hive Table Stats collection (Analyze)
Date Thu, 28 Sep 2017 20:15:47 GMT
Hello - I am trying to run the analyze command on a partitioned table in Hive. The data is
stored on S3 in ORC format. The stats collections starts and ends/fails with this message
-

2017-09-28T20:10:20,582 ERROR [a6c56bb3-89b6-454c-a74b-516cef3aa2ad main([])]: exec.ColumnStatsTask
(ColumnStatsTask.java:execute(414)) - Failed to run column stats task
org.apache.hadoop.hive.ql.metadata.HiveException: NoSuchObjectException(message:Partition
for which stats is gathered doesn't exist.)

How do I get around this? This is the command I trying to run -

hive> ANALYZE TABLE <tabe_name> partition(<DATE COLUMN>) COMPUTE STATISTICS
FOR COLUMNS;

This command works when I remove the "FOR COLUMNS" clause. Any ideas why/how to get this working?



Mime
View raw message