sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Daniel Voros (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-3312) Can not export column data named `value` from hive to mysql
Date Mon, 16 Apr 2018 06:50:00 GMT

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

Mime
View raw message