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

• Type: Bug
• Status: Open
• Priority: Critical
• Resolution: Unresolved
• Affects Version/s: 1.4.6
• Component/s: tools
• Assignee: Unassigned
• Reporter: zimmem zhuang
• Created: 15/Apr/18 13:40
• Updated: 16/Apr/18 06:49

Description

the hive table 

CREATE TABLE if not exists `test_table`(
`id` bigint, 
`value` double)
STORED AS parquet

the mysql table

CREATE TABLE if not exists `test_table`(
`id` bigint, 
`value` double);

the export command

 

sqoop export --connect "${jdbc_connect_url}" --username test --password *** --table test_table --columns id,value --hcatalog-database default --hcatalog-table test_table

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.