sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "zimmem zhuang (JIRA)" <j...@apache.org>
Subject [jira] [Created] (SQOOP-3312) Can not export column data named `value` from hive to mysql
Date Sun, 15 Apr 2018 13:41:00 GMT
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)

Mime
View raw message