I uploaded a file into HDFS and then also into hive directory called /user/home/warehouse/sqoop_import.db. I looked into the output of HDFS and it returns the data correctly. See example data below.
However, when I try to run a query on Hive as follows:
hive> use sqoop_import;
hive> show tables;
hive> select * from accounts;
I get the following output:
Any idea why this maybe the case? And how to fix this? I didn’t have this issue until today.