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

get_json_object(col,'$.a') is null in where clause didn`t work

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical
    • Resolution: Fixed
    • Affects Version/s: 0.14.0
    • Fix Version/s: 1.3.0, 2.0.0
    • Component/s: Hive
    • Labels:
      None
    • Release Note:
      Enabled to accept quoting of all character backslash qooting mechanism

      Description

      example:
      select attr from raw_kafka_item_dt0 where l_date='2015-09-06' and customer='Czgc_news' and get_json_object(attr,'$.title') is NULL limit 10;
      but in results,title is still not null!

      {"title":"思科Q4收入估$79.2亿 前景阴云笼罩","ItemType":"NewsBase","keywords":"思科Q4收入估\$79.2亿 前景阴云笼罩","random":"1420253511075","callback":"BCore.instances[2].callbacks[1]","user_agent":"Mozilla/5.0 (iPhone; U; CPU iPhone OS 4_2_1 like Mac OS X; en-us) AppleWebKit/533.17.9 (KHTML; like Gecko) Version/5.0.2 Mobile/8C148 Safari/6533.18.5","is_newgid":"false","uuid":"DS.Input:b56c782bcb75035d:00002116:003dcd40:54a75947","ptime":"1.1549997E9"}

      attr is a dict

        Attachments

          Activity

            People

            • Assignee:
              Cazen Cazen Lee
              Reporter:
              Feng Yuan Feng Yuan
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Due:
                Created:
                Updated:
                Resolved: