Unable to insert multi line records in hive

[Techsupport]

Hi to all,

 

I have used the following script to insert

 

insert into employee values (1,'Alex','123 street

Tamilnadu

India');

 

But the selection result like the following,

 

1,'Alex','123 street'

null,null,null

null,null,null

 

If I insert the record in a single line, It was inserted perfectly

 

insert into employee values (1,'Alex','123 street Tamilnadu India');

 

How to solve this ?

 

 

Thanks,

Karthick Ramu