Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # dev >> Behavior of Hive 2837: insert into external tables should not be allowed


Copy link to this message
-
Re: Behavior of Hive 2837: insert into external tables should not be allowed
Hi Mark,

I understand your concern w.r.t backward compatibility. But as Ed pointed
out there is a config variable and by default semantic is unchanged so you
can continue to insert into your external table.
I have a question though. Why are you creating all your tables as
"external" tables ? Why not regular tables?

Thanks,
Ashutosh

On Thu, May 31, 2012 at 9:35 PM, Mark Grover <[EMAIL PROTECTED]>wrote:

> Hi folks,
> I have a question regarding HIVE 2837(
> https://issues.apache.org/jira/browse/HIVE-2837) that deals with
> disallowing external table from using insert into queries.
>
> From looking at the JIRA, it seems like it applies to external tables on
> HDFS as well. Technically, insert into should be ok for external tables on
> HDFS (and S3 as well). Seems like a storage file system level thing to
> specify whether insert into is applied and implement it.
>
> Historically, there hasn't been any real difference between creating an
> external table on HDFS vs creating a managed one. However, if we disallow
> insert into on external tables, that would mean that folks with external
> tables on HDFS wouldn't be able to make use of insert into functionality
> even though they should be able to. Do we want to allow insert into on HDFS
> tables regardless of whether they are external or not?
>
> Mark
>