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
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
wrote:
> Sir
>
> In our system, we need hive query to retrieve the field name where a
> par
: Fri, 19 Oct 2012 03:13:54
To: common-ser-group; hadoop core
developer
Reply-To: common-user@hadoop.apache.org
Cc: hadoop users
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 loc
/12, Nitin Pawar wrote:
From: Nitin Pawar
Subject: Re: REg - Hive
To: common-...@hadoop.apache.org
Cc: "common-ser-group" , "hadoop users"
Date: Friday, October 19, 2012, 3:49 PM
do you mean to say you want to say "select * from table where
anycolumn like/equal
Sudha,
On Mon, Oct 1, 2012 at 9:31 AM, sudha sadhasivam
wrote:
> We are doing a project in Hive.
>Given a field / value is it possible to find the corresponding
> headers (meta data).
> For example if we have a table with id, user, work_place,
> residence_place
> given
But it is the same issue as with SQL and relational database : you will do
a full (distributed, in this case) scan. If you want to do full text
search, then you may want to use an alternative solution even though (of
course) you could build your own on Hadoop.
http://en.wikipedia.org/wiki/Full_tex
Sir
I want to retrieve names of fields having a particular value.
How can it be done on a single table and across multiple tables?
G Sudha
--- On Mon, 10/1/12, Harsh J wrote:
From: Harsh J
Subject: Re: doubts reg Hive
To: common-user@hadoop.apache.org
Date: Monday, October 1, 2012, 11:13 AM
