[
https://issues.apache.org/jira/browse/SQOOP-1771?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14220381#comment-14220381
]
Jarek Jarcec Cecho commented on SQOOP-1771:
-------------------------------------------
I've quickly tried "defaults" on real Hive cluster and got the following result:
* Key is separate from value by {{0x03}}
* Multiple Key-value pairs are separate by {{0x02}}
Here is the script that I've executed:
{code}
hive> create table m(m map<String, String>);
hive> INSERT OVERWRITE TABLE m SELECT map("A", "B", "C", "D") from sqoop.text2
limit 1;
shell$ hadoop dfs -cat /user/hive/warehouse/m/* | hexdump -C
DEPRECATED: Use of this script to execute hdfs command is deprecated.
Instead use the hdfs command for it.
00000000 43 03 44 02 41 03 42 0a |C.D.A.B.|
00000008
{code}
> Investigation FORMAT of the Array/NestedArray/ Set/ Map in Postgres and HIVE.
> -----------------------------------------------------------------------------
>
> Key: SQOOP-1771
> URL: https://issues.apache.org/jira/browse/SQOOP-1771
> Project: Sqoop
> Issue Type: Sub-task
> Components: sqoop2-framework
> Reporter: Veena Basavaraj
> Fix For: 1.99.5
>
>
> update this wiki, which is missing details on the complex types
> https://cwiki.apache.org/confluence/display/SQOOP/Sqoop2+Intermediate+representation#Sqoop2Intermediaterepresentation-Intermediateformatrepresentationproposal
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
