Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hadoop >> mail # user >> Re: REg - Hive


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

From: Nitin Pawar <[EMAIL PROTECTED]>
Subject: Re: REg - Hive
To: [EMAIL PROTECTED]
Cc: "common-ser-group" <[EMAIL PROTECTED]>, "hadoop users" <[EMAIL PROTECTED]>
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
<[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
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB