[jira] [Commented] (SQOOP-3312) Can not export column data named `value` from hive to mysql

["Daniel Voros (JIRA)" <ji...@apache.org>]

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

Daniel Voros commented on SQOOP-3312:
-------------------------------------

[~zimmem] I think this is the same as SQOOP-3038, that was fixed in 1.4.7. Could you please check if you see the issue with 1.4.7?

> Can not export column data named `value` from hive to mysql
> -----------------------------------------------------------
>
>                 Key: SQOOP-3312
>                 URL: https://issues.apache.org/jira/browse/SQOOP-3312
>             Project: Sqoop
>          Issue Type: Bug
>          Components: tools
>    Affects Versions: 1.4.6
>            Reporter: zimmem zhuang
>            Priority: Critical
>
> the hive table 
> {code:java}
> CREATE TABLE if not exists `test_table`(
> `id` bigint, 
> `value` double)
> STORED AS parquet
> {code}
> the mysql table
> {code:java}
> CREATE TABLE if not exists `test_table`(
> `id` bigint, 
> `value` double);
> {code}
> the export command
>  
> {code:java}
> sqoop export --connect "${jdbc_connect_url}" --username test --password *** --table test_table --columns id,value --hcatalog-database default --hcatalog-table test_table
> {code}
> The `value` column will null  after running the command above. But if I change the column name to `value_x` (both hive and mysql), it works corretly.
>  



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)