You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Vaibhav Gumashta (JIRA)" <ji...@apache.org> on 2014/10/21 22:21:34 UTC
[jira] [Created] (HIVE-8544) Beeline SeparatedValuesOutputFormat
(csv/tsv/dsv) wraps the results with extra double quotes
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)