That patch basically throws an error if user specified a non-newline line terminator. Without the patch it will produce unexpected result, successfully.

Sent from my iPhone

On Jun 11, 2010, at 11:23 PM, Amr Awadallah <[email protected]> wrote:

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






Reply via email to