[jira] [Commented] (CARBONDATA-1496) Array type : insert into table support

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Commented] (CARBONDATA-1496) Array type : insert into table support

Akash R Nilugal (Jira)

    [ https://issues.apache.org/jira/browse/CARBONDATA-1496?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16216441#comment-16216441 ]

Ashwini K commented on CARBONDATA-1496:
---------------------------------------

issue - insert into is corrupting data during insert

: jdbc:hive2://localhost:10000> insert into testarray select * from array_t2 ;
+---------+--+
| Result  |
+---------+--+
+---------+--+
No rows selected (0.777 seconds)
0: jdbc:hive2://localhost:10000> select * from testarray ;
+-------+-------------------------+--------------+--+
|  f1   |           f2            |      f3      |
+-------+-------------------------+--------------+--+
| NULL  | ["f2\"]                 | [null]       |
| 1     | ["sam\","sam1\"]        | [null,null]  |
| 2     | ["jane\","jane1\"]      | [null,null]  |
| 3     | ["dianne\","dianne1\"]  | [null,null]  |
+-------+-------------------------+--------------+--+
4 rows selected (0.09 seconds)
0: jdbc:hive2://localhost:10000> select * from array_t2 ;
+-------+-----------------------+----------------+--+
|  f1   |          f2           |       f3       |
+-------+-----------------------+----------------+--+
| NULL  | ["f2"]                | ["f3"]         |
| 1     | ["sam","sam1"]        | ["251","251"]  |
| 2     | ["jane","jane1"]      | ["262","262"]  |
| 3     | ["dianne","dianne1"]  | ["273","273"]  |
+-------+-----------------------+----------------+--+


> Array type : insert into table support
> --------------------------------------
>
>                 Key: CARBONDATA-1496
>                 URL: https://issues.apache.org/jira/browse/CARBONDATA-1496
>             Project: CarbonData
>          Issue Type: Sub-task
>          Components: data-load
>            Reporter: Venkata Ramana G
>             Fix For: 1.3.0
>
>
> # Source table data containing Array data needs to convert from spark datatype to string , as carbon takes string as input row



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)