[HIVE-9748] MetastoreDirectSql fails for zero item queries

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 1.0.0
• Component/s: Metastore
• Assignee: Sergey Shelukhin
• Reporter: Gopal Vijayaraghavan
• Created: 21/Feb/15 08:33
• Updated: 24/Sep/15 22:56
• Resolved: 24/Sep/15 22:56

Description

Metastore Direct SQL throws a SQL Exception

2015-02-21 00:29:00,238 WARN  [pool-3-thread-10]: metastore.ObjectStore (ObjectStore.java:handleDirectSqlError(2400)) - Direct SQL failed
MetaException(message:See previous errors; Error executing SQL query "select count("COLUMN_NAME") from "PART_COL_STATS" where "DB_NAME" = ? and "TABLE_NAME" = ?  and "COLUMN_NAME" in () and "PARTITION_NAME" in () group by "PARTITION_NAME"
".)
        at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.executeWithArray(MetaStoreDirectSql.java:1448)
        at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.partsFoundForPartitions(MetaStoreDirectSql.java:1098)
        at org.apache.hadoop.hive.metastore.MetaStoreDirectSql.aggrColStatsForPartitions(MetaStoreDirectSql.java:1081)
        at org.apache.hadoop.hive.metastore.ObjectStore$8.getSqlResult(ObjectStore.java:6100)
        at org.apache.hadoop.hive.metastore.ObjectStore$8.getSqlResult(ObjectStore.java:6096)
        at org.apache.hadoop.hive.metastore.ObjectStore$GetHelper.run(ObjectStore.java:2365)
        at org.apache.hadoop.hive.metastore.ObjectStore.get_aggr_stats_for(ObjectStore.java:6115)

The query to trigger the issue an EXPLAIN query with column + partition stats on.

 explain select count(1) from store_sales where '2014-10-01' =ss_sold_date ;

Issue Links

• duplicates: HIVE-10965 direct SQL for stats fails in 0-column case