Re: External tables and existing directory structure

2008-12-01 Thread Johan Oskarsson
s. Thoughts? (just remembered that there's probably an unfilled issue that drop table should not be deleting directories for external tables - but probably does right now ..) -Original Message- From: Josh Ferguson [mailto:[EMAIL PROTECTED] Sent: Friday, November 28, 2008 3:32 PM To:

RE: External tables and existing directory structure

2008-11-28 Thread Joydeep Sen Sarma
r 28, 2008 3:32 PM To: hive-user@hadoop.apache.org Subject: Re: External tables and existing directory structure I think this is a pretty common scenario as this is how I was storing my stuff as well. Would this affect the HiveQL create table statement at all or just implicitly require that it be or

Re: External tables and existing directory structure

2008-11-28 Thread Josh Ferguson
I think this is a pretty common scenario as this is how I was storing my stuff as well. Would this affect the HiveQL create table statement at all or just implicitly require that it be ordered? Josh On Nov 28, 2008, at 3:00 PM, Joydeep Sen Sarma wrote: Hi Johann, Create external table wit

RE: External tables and existing directory structure

2008-11-28 Thread Joydeep Sen Sarma
Hi Johann, Create external table with the 'location' clause set to ur data would be the way to go. However - Hive has it's own directory naming scheme for partitions ('='). So just pointing to a directory with subdirectories would not work. So right now case one would have to move or copy the