Vaibhav Gumashta created HIVE-8544:
--------------------------------------
Summary: Beeline SeparatedValuesOutputFormat (csv/tsv/dsv) wraps
the results with extra double quotes
Key: HIVE-8544
URL: https://issues.apache.org/jira/browse/HIVE-8544
Project: Hive
Issue Type: Bug
Components: CLI, JDBC
Affects Versions: 0.14.0
Reporter: Vaibhav Gumashta
Assignee: Vaibhav Gumashta
Noticed additional double quotes in select * <complex datatypes> output while
running it through HiveServer2/Beeline
Actual
{noformat}
[18,19] "{""col1"":""alice brown"",""col2"":18}" "{""alice brown"":18}"
[18,19] "{""col1"":""alice garcia"",""col2"":18}" "{""alice garcia"":18}"
[18,19] "{""col1"":""alice garcia"",""col2"":18}" "{""alice garcia"":18}"
[18,19] "{""col1"":""alice thompson"",""col2"":18}" "{""alice
thompson"":18}"
[18,19] "{""col1"":""alice xylophone"",""col2"":18}" "{""alice
xylophone"":18}"
[18,19] "{""col1"":""bob hernandez"",""col2"":18}" "{""bob hernandez"":18}"
[18,19] "{""col1"":""bob ichabod"",""col2"":18}" "{""bob ichabod"":18}"
{noformat}
Expected
{noformat}
[18,19] {"col1":"alice brown","col2":18} {"alice brown":18}
[18,19] {"col1":"alice garcia","col2":18} {"alice garcia":18}
[18,19] {"col1":"alice garcia","col2":18} {"alice garcia":18}
[18,19] {"col1":"alice thompson","col2":18} {"alice thompson":18}
[18,19] {"col1":"alice xylophone","col2":18} {"alice xylophone":18}
[18,19] {"col1":"bob hernandez","col2":18} {"bob hernandez":18}
[18,19] {"col1":"bob ichabod","col2":18} {"bob ichabod":18}
{noformat}
Run these queries through HiveServer2 to reproduce the issue:
{noformat}
create table insert_9 (a array<int>, b struct<col1:string,col2:int>, c
map<string, int>);
insert overwrite table insert_9 select array(age, age+1), struct(name, age),
map(name, age) from studenttab10k;
select * from insert_9;
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
