[no subject]

Hello, I got this error when trying to create a test table with hive FAILED: Error in metadata: MetaException (message: Got exception: java.io.FileNotFoundException File file :/ user / hive / warehouse / test does not exist.) I changed the default directories warhouse

Re:

can you try providing a location 'path_to_file' and create the table again On Wed, Nov 28, 2012 at 2:09 PM, imen Megdiche imen.megdi...@gmail.comwrote: Hello, I got this error when trying to create a test table with hive FAILED: Error in metadata: MetaException (message: Got exception:

Re: Hive - Load file with delimiters

Moving to user@hive.apache.org since this is an Apache Hive related question Hi Ram, Hive doesn't provide a way to do this out of the box. I have seen other people have the same request before (and more, e.g. use of escape characters to embed the enclosing characters, etc.) and have just created

RE: Hive - Load file with delimiters

Plain old tab-separated text is very easy to import to Hive. So I would pre-process the CSV you have now to change it to tab-separated (with no quotes). Chuck Connell Nuance RD Data Team Burlington, MA From: Mark Grover [mailto:grover.markgro...@gmail.com] Sent: Wednesday, November 28, 2012

Re: Hive - Load file with delimiters

Ram, Having comma delimiter in the field is a separate issue on it's own. Barring that, you could use string length and sub string UDFs available in Hive to get rid of the enclosing characters. There is an example of that in the email thread I pointed out earlier. You can see all available Hive

collect_set() with non-primitive types

I have a table defined as: CREATE TABLE foo ( id INT, start_time STRING, name STRING, value STRING, type STRING ) The 'name', 'value' and 'type' fields actually describe another object, and I'd like to turn these into STRUCTs, something like: CREATE TABLE bar ( id INT, start_time

Re: collect_set() with non-primitive types

On Wed, Nov 28, 2012 at 1:29 PM, Brad Cavanagh brad.cavan...@gmail.comwrote: I have a table defined as: CREATE TABLE foo ( id INT, start_time STRING, name STRING, value STRING, type STRING ) The 'name', 'value' and 'type' fields actually describe another object, and I'd like

Compile hive on hadoop 1.0.4

Hi, Is it possible running hive against hadoop 1.0.4? I was checking out the trunk from svn, and running ant clean package fails, looks like it's looking for 0.20.0 libraries. Is there some configuration I can modify? Thanks.