Re: can hive support separate namespace for temp tables?

2011-04-20 Thread Carl Steinbach
The ability to select across mulitple databases was added in 0.7.0. On Wed, Apr 20, 2011 at 8:59 PM, Igor Tatarinov 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

Re: can hive support separate namespace for temp tables?

2011-04-20 Thread Igor Tatarinov
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 wrote: > I can't find any documentation on the wiki, where's the doc? > > > 2011/4/20 Edward Capr

Re: can hive support separate namespace for temp tables?

2011-04-20 Thread Erix Yao
I can't find any documentation on the wiki, where's the doc? 2011/4/20 Edward Capriolo > On Wed, Apr 20, 2011 at 6:32 AM, Erix Yao 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. > >

Re: FileNotFoundException when creating table, following GettingStarted guide

2011-04-20 Thread Karl Ostmo
Turns out this was a simple issue of permissions. To fix it, I first created a group called "hive" on my system. Then I added myself to that group: kostmo@leetbook:~$ sudo usermod -aG hive kostmo Then I changed the group ownership of the warehouse directory: kostmo@leetbook:~$ sudo /home/kostmo/

FileNotFoundException when creating table, following GettingStarted guide

2011-04-20 Thread Karl Ostmo
Hello, I am encountering the exact issue that a user posted about last month (with no response): http://mail-archives.apache.org/mod_mbox/hive-dev/201103.mbox/%3caanlktimf6cr4v3-x+memr9po7dkmlwv23jf38x2+k...@mail.gmail.com%3E#archives I have been working my way through the Hive GettingStarted guid

Re: can hive support separate namespace for temp tables?

2011-04-20 Thread Edward Capriolo
On Wed, Apr 20, 2011 at 6:32 AM, Erix Yao 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 s

can hive support separate namespace for temp tables?

2011-04-20 Thread Erix Yao
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,