RE: Want to Add New Column in Avro Schema

2016-03-23 Thread Lunagariya, Dhaval
Thanks guys. Just updated the .avsc and it’s done. No need to recreated the table again. Regards, Dhaval From: Maulik Gandhi [mailto:mmg...@gmail.com] Sent: Wednesday, March 23, 2016 7:05 PM To: user Cc: er.dcpa...@gmail.com Subject: Re: Want to Add New Column in Avro Schema Create table DDL

Re: Want to Add New Column in Avro Schema

2016-03-23 Thread Maulik Gandhi
ble? > > > > *From: *"Lunagariya, Dhaval" <dhaval.lunagar...@citi.com> > *Reply-To: *"user@avro.apache.org" <user@avro.apache.org> > *Date: *Wednesday, March 23, 2016 at 8:17 AM > *To: *"user@avro.apache.org" <user@avro.apache.org>

Re: Want to Add New Column in Avro Schema

2016-03-23 Thread Maulik Gandhi
> > LOCATION 'hdfs:///data/hive/TEST' > > TBLPROPERTIES ('avro.schema.url'='hdfs:///user/Test.avsc'); > > > > Thanks, > > Dhaval > > > > *From:* Aaron.Dossett [mailto:aaron.doss...@target.com > <aaron.doss...@target.com>] > *Sent:* Wednesday, March 2

Re: Want to Add New Column in Avro Schema

2016-03-23 Thread Aaron . Dossett
al From: Aaron.Dossett [mailto:aaron.doss...@target.com] Sent: Wednesday, March 23, 2016 6:50 PM To: user@avro.apache.org<mailto:user@avro.apache.org> Cc: 'er.dcpa...@gmail.com<mailto:'er.dcpa...@gmail.com>' Subject: Re: Want to Add New Column in Avro Schema You shouldn't have to drop the table, ju

RE: Want to Add New Column in Avro Schema

2016-03-23 Thread Lunagariya, Dhaval
' Subject: Re: Want to Add New Column in Avro Schema You shouldn't have to drop the table, just update the .avsc. Can you share the DDL you use to create the table? From: "Lunagariya, Dhaval" <dhaval.lunagar...@citi.com<mailto:dhaval.lunagar...@citi.com>> Reply-To: "user@

RE: Want to Add New Column in Avro Schema

2016-03-23 Thread Lunagariya, Dhaval
6:36 PM To: user@avro.apache.org Cc: 'er.dcpa...@gmail.com' Subject: Re: Want to Add New Column in Avro Schema If you create the external table by reference to the .avsc file (TBLPROPERTIES ( 'avro.schema.url'='hdfs://foo.avsc')) the all you have to do is update that avsc file in a compatible way