hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Carl Steinbach <c...@cloudera.com>
Subject Re: Create Table with Line Terminated other than '\n'
Date Fri, 11 Jun 2010 01:31:23 GMT
Hi Shuja,

The grammar for Hive's CREATE TABLE statement is discussed here:
http://wiki.apache.org/hadoop/Hive/LanguageManual/DDL#Create_Table

You need to use the "LINES TERMINATED BY" clause in the CREATE TABLE
statement in order to specify a line terminator other than "\n".

Carl

On Thu, Jun 10, 2010 at 5:39 PM, Shuja Rehman <shujamughal@gmail.com> wrote:

> Hi
> I want to create a table in hive which should have row formated line
> terminated other than '\n'. so i can read xml file as single cell in one row
> and column of table.
> kindly let me know how to do this?
> THanks
>
>
>
> --
> Regards
> Shuja-ur-Rehman Baig
> _________________________________
> MS CS - School of Science and Engineering
> Lahore University of Management Sciences (LUMS)
> Sector U, DHA, Lahore, 54792, Pakistan
> Cell: +92 3214207445
>

Mime
View raw message