hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Carl Steinbach <c...@cloudera.com>
Subject Re: can hive support separate namespace for temp tables?
Date Thu, 21 Apr 2011 05:03:59 GMT
The ability to select across mulitple databases was added in 0.7.0.

On Wed, Apr 20, 2011 at 8:59 PM, Igor Tatarinov <igor@decide.com> wrote:

> I think I tried CREATE db and USE db in the past but it was impossible to
> access tables from another database using the db.table syntax.
> Does that work now?
>
> On Wed, Apr 20, 2011 at 8:25 PM, Erix Yao <yao.erix@gmail.com> wrote:
>
>> I can't find any documentation on the wiki, where's the doc?
>>
>>
>> 2011/4/20 Edward Capriolo <edlinuxguru@gmail.com>
>>
>>> On Wed, Apr 20, 2011 at 6:32 AM, Erix Yao <yao.erix@gmail.com> wrote:
>>> >
>>> > Hi
>>> >     Some times the data analyst need to store the temp result into temp
>>> > tables. But the data analyst forgot the clear the temp tables.
>>> >     As the hive administrator, I suggest make the data analyst work in
>>> a
>>> > separate namespace , and store the temp tables for themselves' only .
>>> >
>>> >     For example, Tim works at the namespace Time, and he can create a
>>> table
>>> > named tmp_table. Jack can also create the same table:tmp_table. but
>>> both
>>> > Time and Jack can see the main data table.
>>> > can hive support this?
>>> >
>>> >
>>> > --
>>> > haitao.yao@Beijing
>>> >
>>> >
>>> >
>>> >
>>> >
>>>
>>> Yes. Hive has support for separate catalogues starting in version 0.6.X
>>>
>>> Edward
>>>
>>
>>
>>
>> --
>> haitao.yao@Beijing
>>
>>
>>
>>
>>
>

Mime
View raw message