Hive external table: Exception:java.io.IOException:Not a data file:44:43

[#1]

Hi Team,

I have loaded Kafka data file in HDFS location in avro json format, and now

1- created Hive External table with 2 partitions (p_consume_dt string, p_consume_hr). 

2- ran - Msck repair table <tablename>;

3- Validated LOCATION by command- Show create table <tablename> Everything is OK till now. but when I execute SELECT * FROM <tablename> 

it throws error

java Exception:java.io.IOException:Not a data file:44:43

Please help..

[#2]

@Mars001  I see you are using EXTERNAL jdbc driver. COuld you please try with beeline and provide below if this fails:

 1. query and queryID

 2. hiveserver2 logs

 3. Output of

    show create table <tablename>;