Hi, I have a CSV file which contains hunderd thousand rows and about 200+ columns. Some of the columns have free text information, which means it might contain characters like comma, colon, quotes etc with in the column content.
What is the best way to load such CSV file into Hive? Another serious issue, I have stored the file in a location in HDFS and then created an external hive table on it. However, upon running Create external table using HDP Hive View, the original CSV is no longer present in the folder where it is meant to be. Not sure on how HDP processes and where it is stored? My understanding was that EXTERNAL table wouldnt be moved from their original HDFS location? Request someone to help out! Thanks & Regards Vijay -- The contents of this e-mail are confidential and for the exclusive use of the intended recipient. If you receive this e-mail in error please delete it from your system immediately and notify us either by e-mail or telephone. You should not copy, forward or otherwise disclose the content of the e-mail. The views expressed in this communication may not necessarily be the view held by WHISHWORKS.