Mailing-List: contact user-help@hive.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user@hive.apache.org
Received-SPF: pass (athena.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:Message-ID:Date:From:Reply-To:Subject:To:MIME-Version:Content-Type;
  b=moj6MBgtGgDLCxIcw7GBK7ocO/rqgfQlitxLsSuOvkiUm1MNCzIGEs6jTIeiKQph4NYTQ4Jf/NFdzQ80RrdyQz7fvWUjH0ndOYnjnW34LnxO9azmrzCvbWbkKXp6LMkSpRNoW9lq1AjrOUZ1pLOg0CUkRJS9WRt6apxC0UGktc4=;
Message-ID: <1374775682.51675.YahooMailNeo@web122405.mail.ne1.yahoo.com>
Date: Thu, 25 Jul 2013 11:08:02 -0700 (PDT)
From: R J <rj201244@yahoo.com>
Reply-To: R J <rj201244@yahoo.com>
Subject: Parse MAP viarable Keys in HIVE
To: "user@hive.apache.org" <user@hive.apache.org>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="-2030432097-266829463-1374775682=:51675"

---2030432097-266829463-1374775682=:51675
Content-Type: text/plain; charset=us-ascii

Hi All,

I have a table in Apache Hive and I am interested in a specific field of the table. Table name: Table1 and field name f1. The field f1 is of type MAP<string, string>.

The table is huge. How could I find the distinct key values of the MAP variable f1 above?

I tried:
$hive -e "select distinct map_keys(f1) from Table1;"
$hive -e "select k from Table1 LATERAL VIEW explode(f1) et as k,v;"

Each of the above returned syntax error. Could you please help.

If the existing values for a few fields of the table ate:
<x, y>
<x, p>
<m, n>
<empty>
<m, m>
<p, q>

I want the return to be:
x
m
p

Thanks a lot. 
---2030432097-266829463-1374775682=:51675
Content-Type: text/html; charset=us-ascii

<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:12pt"><div>Hi All,</div><div><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;">I have a table in Apache Hive and I am interested in a specific field of the table. Table name: Table1 and field name f1. The field f1 is of type MAP&lt;string, string&gt;.<br><br>The table is huge. How could I find the distinct key values of the MAP variable f1 above?<br><br>I tried:<br>$hive -e "select distinct map_keys(f1) from Table1;"<br>$hive -e "select k from Table1 LATERAL VIEW explode(f1) et as k,v;"<br><br>Each of the above returned syntax error. Could you please help.<br><br>If the existing values for a few fields of the table ate:<br>&lt;x, y&gt;<br>&lt;x, p&gt;<br>&lt;m, n&gt;<br>&lt;empty&gt;<br>&lt;m, m&gt;<br>&lt;p, q&gt;<br><br>I
 want the return to be:<br>x<br>m<br>p<br><br>Thanks a lot. <br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div><div style="color: rgb(0, 0, 0); font-size: 16px; font-family: times new roman,new york,times,serif; background-color: transparent; font-style: normal;"><br></div></div></body></html>
---2030432097-266829463-1374775682=:51675--