Uploading CSV for Impala
/user/hadoop/Gc_4 must be a directory. So you need to create a directory, for example, /user/hadoop/Gc_4. Then you upload your Gc_4 to it. So the file path is /user/hadoop/Gc_4/Gc_4. After that, you can use LOCATION to specify the directory path /user/hadoop/Gc_4.
LOCATION must be a directory. This requirement is same in Hive and Impala.
It's not the answer but a workaround.
In most cases I have seen that the table uploaded but the "status" was not successful. Also if you have stored the data with the help of Hive which gives you more control then "Don't forget to REFRESH the metadata on Impala UI." .Very Important.