[
https://issues.apache.org/jira/browse/CARBONDATA-1501?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16216300#comment-16216300 ]
Ashwini K commented on CARBONDATA-1501:
---------------------------------------
Issue : When we update Array data type , it corrupts the other fields with additional delimiters . Below is the snapshot before and after update statement -
0: jdbc:hive2://localhost:10000> LOAD DATA local INPATH '/rand.csv' INTO table testarray options ('DELIMITER'=',', 'QUOTECHAR'='"', 'FILEHEADER'='f1,f2,f3','COMPLEX_DELIMITER_LEVEL_1'='#','COMPLEX_DELIMITER_LEVEL_2'='$');
+---------+--+
| Result |
+---------+--+
+---------+--+
No rows selected (0.811 seconds)
0: jdbc:hive2://localhost:10000> select * from testarray ;
+-------+-----------------------+------------+--+
| f1 | f2 | f3 |
+-------+-----------------------+------------+--+
| NULL | ["f2"] | [null] |
| 1 | ["sam","sam1"] | [251,251] |
| 2 | ["jane","jane1"] | [262,262] |
| 3 | ["dianne","dianne1"] | [273,273] |
+-------+-----------------------+------------+--+
4 rows selected (0.124 seconds)
0: jdbc:hive2://localhost:10000> update testarray set (f3) = ('252\\$253') where (f1)=(1) ;
+---------+--+
| Result |
+---------+--+
+---------+--+
No rows selected (0.78 seconds)
0: jdbc:hive2://localhost:10000> select * from testarray ;
+-------+-----------------------+-------------+--+
| f1 | f2 | f3 |
+-------+-----------------------+-------------+--+
| 1 | ["sam\","sam1\"] | [null,253] |
| NULL | ["f2"] | [null] |
| 2 | ["jane","jane1"] | [262,262] |
| 3 | ["dianne","dianne1"] | [273,273] |
> Update Array values
> -------------------
>
> Key: CARBONDATA-1501
> URL:
https://issues.apache.org/jira/browse/CARBONDATA-1501> Project: CarbonData
> Issue Type: Sub-task
> Components: core, spark-integration
> Reporter: Venkata Ramana G
> Priority: Minor
> Fix For: 1.3.0
>
>
> Update Array values.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
Locked
