Re: Load CSV to hive

2014-09-04 Thread Kim Chew
First, you need to give your csv file a header. For example, col1,col2,col3,...etc. 70268503,"2012-09-28 15:00:59",0,",01","18,01",,1," 2012-10-01 17:01:11",0,, Then create the table with, CREATE TABLE IF NOT EXISTS foo ( col1 INT, col2 STRING, col3 INT ... ) ROW

Re: Load CSV to hive

2014-09-04 Thread Peyman Mohajerian
you could use: https://github.com/ogrodnek/csv-serde That what i have done in the past, but with the latest version of Hive there might be other options available too. On Thu, Sep 4, 2014 at 12:43 PM, Ricardo Pompeu Ferreras < ricardo.ferre...@gmail.com> wrote: > Hi, > > How I create a table wit

Load CSV to hive

2014-09-04 Thread Ricardo Pompeu Ferreras
Hi, How I create a table with this structure ? The separte are , comma, There are fields with "xx" date and "yyy" with value. 70268503,"2012-09-28 15:00:59",0,",01","18,01",,1,"2012-10-01 17:01:11",0,, help please -- Ricardo SP, Brasil

Re: External table

2014-09-04 Thread Vinod Singh
Yes Thanks, Vinod 04-09-2014 6:30 am को, "CHEBARO Abdallah" ने लिखा: > Hello, > > > > Is it possible to create an external table and point it to a file instead > of a directory? > > > > thanks > > *** > > This e-mail contains information for the intended recipient on

External table

2014-09-04 Thread CHEBARO Abdallah
Hello, Is it possible to create an external table and point it to a file instead of a directory? thanks *** This e-mail contains information for the intended recipient only. It may contain proprietary material or confidential information. If you are not the intende

RE: Hive columns

2014-09-04 Thread CHEBARO Abdallah
thanks From: Nitin Pawar [mailto:nitinpawar...@gmail.com] Sent: Thursday, September 04, 2014 4:23 PM To: user@hive.apache.org Subject: Re: Hive columns it means you will need to define atleast one column in hive or build your fileformat which can handle reading the files and giving data back to

Re: Hive columns

2014-09-04 Thread Nitin Pawar
it means you will need to define atleast one column in hive or build your fileformat which can handle reading the files and giving data back to hive when i say atleast one column, by default hive uses "\n" as record terminator that means you can define an entire row as a column and then process it

RE: Hive columns

2014-09-04 Thread CHEBARO Abdallah
Can you please specify what this means? From: Nitin Pawar [mailto:nitinpawar...@gmail.com] Sent: Thursday, September 04, 2014 4:00 PM To: user@hive.apache.org Subject: Re: Hive columns If those are text files you can create the table with single column and then process them line by line On Thu,

Re: Hive columns

2014-09-04 Thread Nitin Pawar
If those are text files you can create the table with single column and then process them line by line On Thu, Sep 4, 2014 at 6:13 PM, CHEBARO Abdallah wrote: > Hello, > > > > Is it possible to create an external table without specifying the columns? > > > > In fact, I am creating an external

Hive columns

2014-09-04 Thread CHEBARO Abdallah
Hello, Is it possible to create an external table without specifying the columns? In fact, I am creating an external table that points to a directory that contains 3 text file, and each text file has different number of columns. Thanks *** This e-mail contains infor