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
