Re: CREATE EXTERNAL TABLE Fails on Some Directories

2013-02-15 Thread bejoy_ks
Sent from remote device, Please excuse typos -Original Message- From: Joseph D Antoni Date: Fri, 15 Feb 2013 08:55:50 To: user@hive.apache.org Reply-To: user@hive.apache.org Subject: Re: CREATE EXTERNAL TABLE Fails on Some Directories Not sure--I just truncated the file list from the ls-

Re: CREATE EXTERNAL TABLE Fails on Some Directories

2013-02-15 Thread Joseph D Antoni
: Friday, February 15, 2013 11:50 AM Subject: Re: CREATE EXTERNAL TABLE Fails on Some Directories Something's odd about this output; why is there no / in front of 715? I always get the full path when I run a -ls command. I would expect either: /715/file.csv or /user//715/file.csv Or is that

Re: CREATE EXTERNAL TABLE Fails on Some Directories

2013-02-15 Thread Dean Wampler
the directory--wasn't clear on that.. > > Joey > > > > -- > *From:* Dean Wampler > *To:* user@hive.apache.org; Joseph D Antoni > *Sent:* Friday, February 15, 2013 11:37 AM > *Subject:* Re: CREATE EXTERNAL TABLE Fails on Some Directories > > You confirmed that 715 is an

Re: CREATE EXTERNAL TABLE Fails on Some Directories

2013-02-15 Thread Joseph D Antoni
To: user@hive.apache.org; Joseph D Antoni Sent: Friday, February 15, 2013 11:37 AM Subject: Re: CREATE EXTERNAL TABLE Fails on Some Directories You confirmed that 715 is an actual directory? It didn't become a file by accident? By the way, you don't need to include the file name in t

Re: CREATE EXTERNAL TABLE Fails on Some Directories

2013-02-15 Thread Dean Wampler
You confirmed that 715 is an actual directory? It didn't become a file by accident? By the way, you don't need to include the file name in the LOCATION. It will read all the files in the directory. dean On Fri, Feb 15, 2013 at 10:29 AM, Joseph D Antoni wrote: > I'm trying to create a series of