@Brandon Wilson I tried your suggestion it creates the hive table but I get this error:
org.apache.hadoop.hive.ql.metadata.HiveException: Unable to alter table.
and it does not load data into my table. do you have any idea how to solve this?
What is the user account when DF is used to create the external Hive table?
What is the user account when you try to see the table in Hive (& did you use HiveCli or Hive/Beeline or some ODBC tool?)
@vshukla I am logging in as hdfs user on HDP 2.3.2 sandbox
and using the same account to see tables in hive.Yes , I am using hive CLI and even browsed HDFS files through Ambari .Couldnt see any tables created.