Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-2153

Stats JDBC LIKE queries should escape '_' and '%'

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.8.0
    • Component/s: None
    • Labels:
      None

      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.

        Attachments

        1. HIVE-2153.2.patch
          4 kB
          Ning Zhang
        2. HIVE-2153.patch
          4 kB
          Ning Zhang

          Activity

            People

            • Assignee:
              nzhang Ning Zhang
              Reporter:
              nzhang Ning Zhang
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: