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?
