carbondata-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ashwini K (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CARBONDATA-1501) Update Array values
Date Tue, 24 Oct 2017 04:49:00 GMT

    [ 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)

Mime
View raw message