Loading entire content of a txt file into a single column in a Hive table

[#1]

Loading entire content of a txt file into a single column in a Hive table

File_Name	File_content
file1.txt	first line @ end
file2.txt	second line *** "" / n

[#2]

@Pradeep V

What's your expected end result? Would you like file1 to occupy column 1 of a new table and file2 to occupy the second column? If so, you can import each file as a new table into hive and then insert the second file's table into the first file's table using UNION ALL.