Return-Path: X-Original-To: apmail-hive-issues-archive@minotaur.apache.org Delivered-To: apmail-hive-issues-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 49F501725D for ; Thu, 17 Sep 2015 18:32:07 +0000 (UTC) Received: (qmail 69127 invoked by uid 500); 17 Sep 2015 18:32:05 -0000 Delivered-To: apmail-hive-issues-archive@hive.apache.org Received: (qmail 68917 invoked by uid 500); 17 Sep 2015 18:32:05 -0000 Mailing-List: contact issues-help@hive.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@hive.apache.org Delivered-To: mailing list issues@hive.apache.org Received: (qmail 68798 invoked by uid 99); 17 Sep 2015 18:32:05 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 17 Sep 2015 18:32:05 +0000 Date: Thu, 17 Sep 2015 18:32:04 +0000 (UTC) From: "Ashutosh Chauhan (JIRA)" To: issues@hive.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (HIVE-11825) get_json_object(col,'$.a') is null in where clause didn`t work MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/HIVE-11825?page=3Dcom.atlassian= .jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D1480= 3377#comment-14803377 ]=20 Ashutosh Chauhan commented on HIVE-11825: ----------------------------------------- Although its not standard JSON, I think we can allow this since parser can = handle this. +1 > get_json_object(col,'$.a') is null in where clause didn`t work > -------------------------------------------------------------- > > Key: HIVE-11825 > URL: https://issues.apache.org/jira/browse/HIVE-11825 > Project: Hive > Issue Type: Bug > Components: Hive > Affects Versions: 0.14.0 > Reporter: Feng Yuan > Assignee: Cazen Lee > Priority: Critical > Fix For: 0.14.1 > > Attachments: HIVE-11825.patch > > > example: > select attr from raw_kafka_item_dt0 where l_date=3D'2015-09-06' and custo= mer=3D'Czgc_news' and get_json_object(attr,'$.title') is NULL limit 10; > but in results,title is still not null! > {"title":"=E6=80=9D=E7=A7=91Q4=E6=94=B6=E5=85=A5=E4=BC=B0$79.2=E4=BA=BF = =E5=89=8D=E6=99=AF=E9=98=B4=E4=BA=91=E7=AC=BC=E7=BD=A9","ItemType":"NewsBas= e","keywords":"=E6=80=9D=E7=A7=91Q4=E6=94=B6=E5=85=A5=E4=BC=B0\$79.2=E4=BA= =BF =E5=89=8D=E6=99=AF=E9=98=B4=E4=BA=91=E7=AC=BC=E7=BD=A9","random":"14202= 53511075","callback":"BCore.instances[2].callbacks[1]","user_agent":"Mozill= a/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:54a7594= 7","ptime":"1.1549997E9"}=20 > attr is a dict -- This message was sent by Atlassian JIRA (v6.3.4#6332)