Re: HIVE: How to Load CSV File?

[Amogh Vasekar]

Hi,
You can create an external table pointing to data already on hdfs and 
specifying the delimiter-
CREATE EXTERNAL TABLE page_view_stg(viewTime INT, userid BIGINT,
                    page_url STRING, referrer_url STRING,
                    ip STRING COMMENT 'IP Address of the User',
                    country STRING COMMENT 'country of origination')
    COMMENT 'This is the staging page view table'
    ROW FORMAT DELIMITED FIELDS TERMINATED BY '44' LINES TERMINATED BY '12'
    STORED AS TEXTFILE
    LOCATION '/user/data/staging/page_view';

http://wiki.apache.org/hadoop/Hive/Tutorial#Creating_Tables   for more

HTH,
Amogh


On 7/26/10 1:02 PM, "vaibhav negi" <sssssssena...@gmail.com> wrote:

Hi,

Is there some way to load csv file into hive?

Vaibhav Negi