are not allowed to access the
hadoop).
Re
From: Bejoy Ks [mailto:bejoy...@yahoo.com]
Sent: Wednesday, March 14, 2012 7:46 PM
To: user@hive.apache.org
Subject: Re: We cannot insert data to external table right?
Hi Wei
Definitely you can do it. And infact the purpose of external tables is
to
To: user@hive.apache.org
Sent: Wednesday, March 14, 2012 4:04 PM
Subject: Re: We cannot insert data to external table right?
But you can put the data at same place and read through hive (actually no need
to insert data through table)
On Wed, Mar 14, 2012 at 12:04 PM, Lu, Wei wrote:
Hi ,
>
&
> **2)**Insert data to the table
>
> insert overwrite table binary_tbl_local select * from another_tbl_hdfs;***
> *
>
> ** **
>
> But there is still nothing under the local folder. And “select * from
> binary_tbl_local” returns no results.
>
> ** **
>
> So I guess we cannot insert data to external table right?
>
> ** **
>
> Regards,
>
> Wei
>
** **
>
> But there is still nothing under the local folder. And “select * from
> binary_tbl_local” returns no results.
>
> ** **
>
> So I guess we cannot insert data to external table right?
>
> ** **
>
> Regards,
>
> Wei
>
folder. And "select * from
binary_tbl_local" returns no results.
So I guess we cannot insert data to external table right?
Regards,
Wei