hadoop-common-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From sudha sadhasivam <sudhasadhasi...@yahoo.com>
Subject Re: REg - Hive
Date Mon, 22 Oct 2012 04:14:27 GMT
Yes
We need to find the names of columns (table metadata) that have particular values.
"select * from table where anycolumn like/equal newyork" 
and then see the column definition/name where it occurs.

Kindly let us know whether it is possible
Thanking you
Dr G Sudha
--- On Fri, 10/19/12, Nitin Pawar <nitinpawar432@gmail.com> wrote:

From: Nitin Pawar <nitinpawar432@gmail.com>
Subject: Re: REg - Hive
To: common-dev@hadoop.apache.org
Cc: "common-ser-group" <common-user@hadoop.apache.org>, "hadoop users" <core-user@hadoop.apache.org>
Date: Friday, October 19, 2012, 3:49 PM

do you mean to say you want to say "select * from table where
anycolumn like/equal newyork" ? and then see the column
definition/name where it occurs ?



On Fri, Oct 19, 2012 at 3:43 PM, sudha sadhasivam
<sudhasadhasivam@yahoo.com> wrote:
> Sir
>
> In our system, we need hive query to  retrieve the field name where a particular data
item belongs
> For example, if we have a table having location information, when queried for New York,
the query should retuen the field names where New York occurs like "City", "Administrative
division" etc.
>
> Kindly inform whether it is possible to retrieve meta-data information for a particular
field value in Hive
> Thanking you
> G Sudha



-- 
Nitin Pawar

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message