Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hadoop >> mail # dev >> REg - Hive

Copy link to this message
Re: REg - Hive
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
> 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