Unable to insert multi line records in hive

[Techsupport <te...@sardonyx.in>]

Hi folks,

 

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