Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Create Table with Line Terminated other than '\n'


Copy link to this message
-
Re: Create Table with Line Terminated other than '\n'
Zheng, I thought that was fixed per you work here, no?

https://issues.apache.org/jira/browse/HIVE-302

Then what did you fix?

-- amr

On 6/10/2010 10:22 PM, Zheng Shao wrote:
> Also, changing "LINES TERMINATED BY" probably won't work, because
> hadoop's TextInputFormat does not allow line terminators other than
> "\n".
>
> Zheng
>
> On Thu, Jun 10, 2010 at 6:31 PM, Carl Steinbach<[EMAIL PROTECTED]>  wrote:
>    
>> 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<[EMAIL PROTECTED]>  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
>>>        
>>
>>      
>
>
>