[jira] [Resolved] (DRILL-1168) Describe on table/view gives IllegalArgumentException error

["Venki Korukanti (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-1168?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Venki Korukanti resolved DRILL-1168.
------------------------------------
    Resolution: Duplicate

Drill hive storage plugin is not able understand the type DECIMAL(3,9) as this is new to Hive 0.13. In this case the metastore is of version 0.13, but the Drill hive storage plugin is using 0.12. With DRILL-1347, this issue should be resolved. 

> Describe on table/view gives IllegalArgumentException error
> -----------------------------------------------------------
>
>                 Key: DRILL-1168
>                 URL: https://issues.apache.org/jira/browse/DRILL-1168
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Metadata
>            Reporter: Krystal
>            Assignee: Jason Altekruse
>             Fix For: 0.6.0
>
>
> git.commit.id.abbrev=e5c2da0
> create view student_v as select CAST(student_id AS INTEGER) AS student_id, convert_from(name, 'UTF8') AS name, CAST(age AS INTEGER) AS age, CAST(gpa AS DECIMAL(4, 2)) AS gpa, CAST(studentnum AS BIGINT) AS student_num, CAST(create_time AS TIMESTAMP) AS create_time from student;
> 0: jdbc:drill:schema=dfs1> describe student_v;
> message: "Failure while running fragment. < IllegalArgumentException:[ Error: ',', ':', or ';' expected at position 7 from 'decimal(7,2)' [0:decimal, 7:(, 8:7, 9:,, 10:2, 11:)] ]"



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