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 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 PM, Abe Weinograd <a...@flonet.com<mailto:a...@flonet.com>> wrote: 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 <gcl...@neces.com<mailto:gcl...@neces.com>> wrote: Hello, I would like to create a table based on a selection in hive. Currently I am creating a table based on a location which contains the source csv files and then deriving other tables from that table. I.e: create EXTERNAL TABLE initialtable (deployment_id tinyint, A bigint, sample_date string, charge smallint, discharge smallint) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' LOCATION '/user/hue/data'; CREATE TABLE derivedtable AS SELECT * FROM initialtable WHERE deployment_id='22’; I would just like to create a table where the deployment_id is 22 and not have to create the initial table. If someone can shed some light on how to do this I would appreciate it. The only example I have seen seem to follow the above? Thanks, Gary C -- Devopam Mittra Life and Relations are not binary