Re: Can we define external table Fields enclosed in "

[Tim Robertson]

I believe so.  From the tutorial [1] :

   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'


HTH,
Tim

[1] https://cwiki.apache.org/confluence/display/Hive/Tutorial



On Tue, Apr 17, 2012 at 11:20 PM, Gopi Kodumur <gkodu...@yahoo.com> wrote:

> Is it possible to specify enclosed by character " for fields , while
> defining external table
>
> Thanks
> Gopi
>
>