RE: creating a table based on where column=x

2015-06-09 Thread Gary Clark
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

Re: creating a table based on where column=x

2015-06-09 Thread Devopam Mittra
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

Re: creating a table based on where column=x

2015-06-09 Thread Abe Weinograd
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