Hive on Tez

2015-06-09 Thread Yunqi Zhang
Hi guys, I’m playing with the code that integrates Hive on Tez, and have couple questions regarding to the resource allocation. To my understanding (correct me if I am wrong), Hive creates a DAG composed of MapVertex and ReduceVertex, where each Vertex will later be translated to task running

Re: please unsubscribe me

2015-06-09 Thread Lefty Leverenz
Aqeel, to unsubscribe please send a message to user-unsubscr...@hive.apache.org as described here: Mailing Lists . Thanks. -- Lefty On Tue, Jun 9, 2015 at 5:59 AM, Aqeel Ahmed wrote: > > > -- > > > > > *Regards,Aqeel Ahmed* > > > >

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 yo

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

Alter table statement for "create table like"-tables

2015-06-09 Thread Julian Keppel
I use Hive Version 1.1.0 in Cloudera CDH 5.4.0. I have created an external table: CREATE EXTERNAL TABLE *tableA* ROW FORMAT SERDE 'org.apache.hadoop.hive.serde2.avro.AvroSerDe' STORED AS INPUTFORMAT 'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat' OUTPUTFORMAT 'org.apache.hado

creating a table based on where column=x

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

please unsubscribe me

2015-06-09 Thread Aqeel Ahmed
-- *Regards,Aqeel Ahmed*