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 <sudhasadhasi...@yahoo.com> Date: Fri, 19 Oct 2012 03:13:54 To: common-ser-group<common-u...@hadoop.apache.org>; hadoop core developer<common-dev@hadoop.apache.org> Reply-To: common-u...@hadoop.apache.org Cc: hadoop users<core-u...@hadoop.apache.org> 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