zimmem zhuang created SQOOP-3312:
------------------------------------
Summary: 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
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)