Hello @Dominika Bialek thanks for the reponse. that was the issue. After adding S3 location, the issue resolved ... View more

Thank you for the response. I did it using creating the temp hive table ... View more

One option is to delete existing external table and create new table that includes new column. Since this is Hive metadata operation, your data files wont be touched. Downside is that you will have to execute alter table command to redefine partitions on new table. ... View more

Good to hear it is fixed. In future, have a look at this list of causes of this exception which commonly surface in Hadoop. in the core Hadoop networking we automatically add a link to that page and more diagnostics (e.g. destination hostname:port) to socket exceptions...maybe I should see if somehow we can wrap the exceptions coming up from the ASF libraries too. ... View more

thanks for your reply. that help ... View more