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 <nitinpawar...@gmail.com> wrote: From: Nitin Pawar <nitinpawar...@gmail.com> Subject: Re: REg - Hive To: common-...@hadoop.apache.org Cc: "common-ser-group" <common-user@hadoop.apache.org>, "hadoop users" <core-u...@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 <sudhasadhasi...@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
