I can think of a few things to check
- does it work with a small table
- make sure the table is not there in the first place (even if you have checked the “Drop existing table”)
- make sure you can access the temporary folder and it is large enough to store the data
- see if you have any ‘funny’ data types that might use special converting (does not look like that but still)
- If you can use Impala loader try that as an alternative
Maybe try again and attach a LOG file to your post.
Then we had a discussion where I suggested using the external table function of Hive to create a table. Basically uploading it to HDFS and then converting it to a ‘regular’ table. Also you could split the data into several parts and address a whole folder so you might be able to get the data through a potentially slow network.