You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@carbondata.apache.org by "Ashwini K (JIRA)" <ji...@apache.org> on 2017/10/24 04:49:00 UTC
[jira] [Commented] (CARBONDATA-1501) Update Array values
[ 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)