[jira] [Created] (HIVE-17259) Hive JDBC does not recognize UNIONTYPE columns

["Pierre Villard (JIRA)" <ji...@apache.org>]

Pierre Villard created HIVE-17259:
-------------------------------------

             Summary: 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)