Re: Unable to insert multi line records in hive

2023-03-28 Thread Chris Nauroth
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

Unable to insert multi line records in hive

2023-03-10 Thread Techsupport
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