Thankyou so much.
From: Devopam Mittra [mailto:devo...@gmail.com]
Sent: Tuesday, June 09, 2015 12:25 PM
To: user@hive.apache.org
Subject: Re: creating a table based on where column=x
Please evaluate using unix file operations to simply select what you want from
the csv and use that extract in
Please evaluate using unix file operations to simply select what you want
from the csv and use that extract in your external table.
A simple grep command should do the trick I suppose, but you will need to
test it out to suit your needs.
Hope it helps.
regards
Devopam
On Tue, Jun 9, 2015 at 9:50
Does a view not work for you?
You create your external table as you described and a view which looks like
the 2nd table.
Abe
On Tue, Jun 9, 2015 at 9:44 AM, Gary Clark wrote:
> Hello,
>
>
>
> I would like to create a table based on a selection in hive. Currently I
> am creating a table based