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

["Jason Altekruse (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DRILL-745?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14590141#comment-14590141 ] 

Jason Altekruse commented on DRILL-745:
---------------------------------------

The patch looks pretty good, just one comment. Can you move the Avro schema out of the source and into a separate file? We should probably expand testing of these other formats further soon, and this could establish a bad pattern of copying this schema and modifying it. It  will just be a little easier to have it in a file so that it doesn't need all of the escapes on the quotes for the JSON.

> Drill fails to read the schema of avro tables from hive when the schema is in a separate file
> ---------------------------------------------------------------------------------------------
>
>                 Key: DRILL-745
>                 URL: https://issues.apache.org/jira/browse/DRILL-745
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Storage - Hive
>            Reporter: Rahul Challapalli
>            Assignee: Venki Korukanti
>             Fix For: 1.1.0
>
>         Attachments: DRILL-745-1.patch
>
>
> 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          |
> +-------------+------------+-------------+



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)