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)
