[
https://issues.apache.org/jira/browse/HIVE-4252?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13618935#comment-13618935
]
Ashutosh Chauhan commented on HIVE-4252:
----------------------------------------
It will be good to check if sql standard provides any guideline for string
representation of complex type. Or implementations are free to choose their
own. For example I ran a quick test against postgres for arrays and its
different than what we do.
{code}
CREATE TABLE sal_emp (
name text,
pay_by_quarter integer[]
);
INSERT INTO sal_emp
VALUES ('Bill',
'{10000, 10000, 10000, 10000}');
SELECT * FROM sal_emp;
name | pay_by_quarter
-------+---------------------------
Bill | {10000,10000,10000,10000}
{code}
> hiveserver2 string representation of complex types are inconsistent with cli
> ----------------------------------------------------------------------------
>
> Key: HIVE-4252
> URL: https://issues.apache.org/jira/browse/HIVE-4252
> Project: Hive
> Issue Type: Bug
> Components: HiveServer2
> Affects Versions: 0.11.0
> Reporter: Thejas M Nair
> Assignee: Thejas M Nair
> Attachments: HIVE-4252.1.patch, HIVE-4252.2.patch
>
>
> For example, it prints struct as "[null, null, null]" instead of
> "{\"r\":null,\"s\":null,\"t\":null}"
> And for maps it is printing it as "{k=v}" instead of {\"k\":\"v\"}
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
