I have a file with below data with 4 columns, out of it 1st column (TEXT1) is only column have data separated by comma (,) and remaining columns has no values/data.
Now, when I tried to upload the table using ambari hive view, I observed as below in preview table.
data of column 1 is spitted and is moved to other three columns because I am using field delimiter as comma (,)
instead I would like to upload the table like below:
can some one suggest me how can I achieve this.
attached the screen shot of the settings (field delimiter, escape character, quote character, Is first row header)
I think you can use regex to load data .