[DRILL-745] Drill fails to read the schema of avro tables from hive when the schema is in a separate file

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.1.0
• Component/s: Storage - Hive
• Assignee: Venki Korukanti
• Reporter: Rahul Kumar Challapalli
• Created: 14/May/14 20:37
• Updated: 17/Jun/15 21:32
• Resolved: 17/Jun/15 21:32

Description

Follow the below steps to reproduce the issue :

1. hadoop fs -copyFromLocal doctors.avsc /drill/
2. run the hive queries from doctors.ddl
3. From drill, the describe command fails to get the schema for doctors_fileschema table. It gives the below information :

0: jdbc:drill:schema=dfs> describe doctors_fileschema;
----------------------------------

COLUMN_NAME

DATA_TYPE

IS_NULLABLE

----------------------------------

error_error_error_error_error_error_error	VARCHAR	NO
cannot_determine_schema	VARCHAR	NO
check	VARCHAR	NO
schema	VARCHAR	NO
url	VARCHAR	NO
and	VARCHAR	NO
literal	VARCHAR	NO

----------------------------------