Home | About | Sematext search-lucene.com search-hadoop.com
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB
 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
>>>        
>>
>>      
>
>
>
NEW: Monitor These Apps!
elasticsearch, apache solr, apache hbase, hadoop, redis, casssandra, amazon cloudwatch, mysql, memcached, apache kafka, apache zookeeper, apache storm, ubuntu, centOS, red hat, debian, puppet labs, java, senseiDB