Yes, external Tables are no different that managed tables. The main difference in case of external tables is, if you drop a managed table the data in hdfs is also deleted where as in case of external tables the data is not deleted from hdfs only the entry from metastore is removed.
Regards Bejoy KS Sent from handheld, please excuse typos. -----Original Message----- From: tishan pubudu kanishka dahanayakage <dtishanpub...@gmail.com> Date: Tue, 19 Jun 2012 13:26:49 To: <user@hive.apache.org>; <bejoy...@yahoo.com> Reply-To: user@hive.apache.org Subject: Re: Define field delimiters for output files Hi Bejoy, Thanks. Will an external table also do the same thing? On Tue, Jun 19, 2012 at 12:35 PM, Bejoy KS <bejoy...@yahoo.com> wrote: > ** > Hi Tishan > > AFAIK there is no way to specify the delimiter in INSERT OVERWRITE > command. The delimiter could be specified on table creation only. > > You can get your requirement done my creating an intermediate table . > > 1) Define the intermediate table with the required delimiter of your > choice. > 2) Load data from original table to this intermediate table. > 3) Do the Insert Overwrite to local directory from this table > > > Regards > Bejoy KS > > Sent from handheld, please excuse typos. > ------------------------------ > *From: * tishan pubudu kanishka dahanayakage <dtishanpub...@gmail.com> > *Date: *Tue, 19 Jun 2012 12:17:42 +0530 > *To: *<user@hive.apache.org> > *ReplyTo: * user@hive.apache.org > *Subject: *Define field delimiters for output files > > Hi all, > Is there a way to define the field delimiter for output file when using > the command > INSERT OVERWRITE LOCAL DIRECTORY 'path' > > > -- > Regards, > Tishan > > -- Regards, Tishan
