[ https://issues.apache.org/jira/browse/HIVE-17259?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16213449#comment-16213449 ]
Ashutosh Chauhan commented on HIVE-17259: ----------------------------------------- [~pvillard] Can you please attach a patch here so our unit tests can run on it? See: https://cwiki.apache.org/confluence/display/Hive/Hive+PreCommit+Patch+Testing > Hive JDBC does not recognize UNIONTYPE columns > ---------------------------------------------- > > Key: HIVE-17259 > URL: https://issues.apache.org/jira/browse/HIVE-17259 > Project: Hive > Issue Type: Bug > Components: Beeline, JDBC > Environment: Hive 1.2.1000.2.6.1.0-129 > Beeline version 1.2.1000.2.6.1.0-129 by Apache Hive > Reporter: Pierre Villard > Assignee: Pierre Villard > > Hive JDBC does not recognize UNIONTYPE columns. > I've an external table backed by an avro schema containing a union type field. > {noformat} > "name" : "value", > "type" : [ "int", "string", "null" ] > {noformat} > When describing the table I've: > {noformat} > describe test_table; > +-------------------+---------------------------------------------------------------+----------+--+ > | col_name | data_type > | comment | > +-------------------+---------------------------------------------------------------+----------+--+ > | description | string > | | > | name | string > | | > | value | uniontype<int,string,void> > | | > +-------------------+---------------------------------------------------------------+----------+--+ > {noformat} > When doing a select query over the data using the Hive CLI, it works: > {noformat} > hive> select value from test_table; > OK > {0:10} > {0:10} > {0:9} > {0:9} > ... > {noformat} > But when using beeline, it fails: > {noformat} > 0: jdbc:hive2://....> select * from test_table; > Error: Unrecognized column type: UNIONTYPE (state=,code=0) > {noformat} > By applying the patch provided with this JIRA, the command succeeds and > return the expected output. -- This message was sent by Atlassian JIRA (v6.4.14#64029)