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

Check when you configured Hive on your hadoop cluster which metastore you used? If you have MySQL as a metastore then you are done you can goto meta tables to pull attribute's information.
Sent from my BlackBerry, pls excuse typo

-----Original Message-----
From: sudha sadhasivam <[EMAIL PROTECTED]>
Date: Fri, 19 Oct 2012 03:13:54
To: common-ser-group<[EMAIL PROTECTED]>; hadoop core developer<[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
Cc: hadoop users<[EMAIL PROTECTED]>
Subject: REg - Hive

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

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
<[EMAIL PROTECTED]> 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