[HIVE-2153] Stats JDBC LIKE queries should escape '_' and '%'

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.8.0
• Assignee: Ning Zhang
• Reporter: Ning Zhang
• Created: 09/May/11 20:23
• Updated: 16/Dec/11 23:56
• Resolved: 10/May/11 06:54

Description

DELETE /* Hive stats aggregation: org.apache.hadoop.hive.ql.stats.jdbc.JDBCStatsAggregator */ FROM PARTITION_STAT_TBL WHERE ID LIKE 'hdfs://dfsnode:9000/tmp/hive-root/hive_2011-05-09_04-30-28_586_4184342157898880918/-ext-10000/ds=2011-05-08/table_name=dim_page_to_user_suggest_assoc/%'

It is a prefix query but the '_' in the ID column should be escaped. The same applies to '%' if they appear in ID.