Hello Karthick,
This looks like the table is using the default TEXTFILE storage format.
This storage format assumes that newlines are record delimiters.
Unfortunately, this won't work well for data that contains embedded
newlines. The select is probably finding 3 lines and misinterpreting it as
3
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 perfe