Jagruti Varia created HIVE-12012:
------------------------------------
Summary: select query on json table with map type column fails
Key: HIVE-12012
URL: https://issues.apache.org/jira/browse/HIVE-12012
Project: Hive
Issue Type: Bug
Reporter: Jagruti Varia
Assignee: Jason Dere
select query on json table throws this error if table contains map type column:
{noformat}
Failed with exception
java.io.IOException:org.apache.hadoop.hive.serde2.SerDeException:
org.codehaus.jackson.JsonParseException: Current token (FIELD_NAME) not
numeric, can not use numeric value accessors
at [Source: java.io.ByteArrayInputStream@295f79b; line: 1, column: 26]
{noformat}
steps to reproduce the issue:
{noformat}
hive> create table c_complex(a array<string>,b map<string,int>) row format
serde 'org.apache.hive.hcatalog.data.JsonSerDe';
OK
Time taken: 0.319 seconds
hive> insert into table c_complex select array('aaa'),map('aaa',1) from
studenttab10k limit 2;
Query ID = hrt_qa_20150826183232_47deb33a-19c0-4d2b-a92f-726659eb9413
Total jobs = 1
Launching Job 1 out of 1
Status: Running (Executing on YARN cluster with App id
application_1440603993714_0010)
--------------------------------------------------------------------------------
VERTICES STATUS TOTAL COMPLETED RUNNING PENDING FAILED KILLED
--------------------------------------------------------------------------------
Map 1 .......... SUCCEEDED 1 1 0 0 0 0
Reducer 2 ...... SUCCEEDED 1 1 0 0 0 0
--------------------------------------------------------------------------------
VERTICES: 02/02 [==========================>>] 100% ELAPSED TIME: 11.75 s
--------------------------------------------------------------------------------
Loading data to table default.c_complex
Table default.c_complex stats: [numFiles=1, numRows=2, totalSize=56,
rawDataSize=0]
OK
Time taken: 13.706 seconds
hive> select * from c_complex;
OK
Failed with exception
java.io.IOException:org.apache.hadoop.hive.serde2.SerDeException:
org.codehaus.jackson.JsonParseException: Current token (FIELD_NAME) not
numeric, can not use numeric value accessors
at [Source: java.io.ByteArrayInputStream@295f79b; line: 1, column: 26]
Time taken: 0.115 seconds
hive> select count(*) from c_complex;
OK
2
Time taken: 0.205 seconds, Fetched: 1 row(s)
{noformat}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
