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 Plain View
Hadoop >> mail # dev >> REg - Hive


+
sudha sadhasivam 2012-10-19, 10:13
+
Manish Bhoge 2012-10-19, 10:25
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
<[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