sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Pavel Benes (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (SQOOP-2387) NPE thrown when sqoop tries to import table with column containing some special character
Date Tue, 02 Jun 2015 15:14:18 GMT

     [ https://issues.apache.org/jira/browse/SQOOP-2387?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Pavel Benes updated SQOOP-2387:
-------------------------------
    Attachment: sqoop.log
                joblog.txt

Sqoop and job logs. 

> NPE thrown when sqoop tries to import table with column containing some special character
> -----------------------------------------------------------------------------------------
>
>                 Key: SQOOP-2387
>                 URL: https://issues.apache.org/jira/browse/SQOOP-2387
>             Project: Sqoop
>          Issue Type: Bug
>          Components: hive-integration
>    Affects Versions: 1.4.5, 1.4.6
>         Environment: HDP 2.2.0.0-2041
>            Reporter: Pavel Benes
>            Priority: Critical
>         Attachments: SQOOP-2387.patch, joblog.txt, sqoop.log
>
>
> This sqoop import:
> sqoop import --connect jdbc:mysql://some.merck.com:1234/dbname --username XXX --password
YYY --table some_table --hcatalog-database some_database --hcatalog-table some_table --hive-partition-key
mg_version --hive-partition-value 2015-05-28-13-18 -m 1 --verbose --fetch-size -2147483648
> fails with with this error:
> 2015-06-01 13:20:39,209 WARN [main] org.apache.hadoop.mapred.YarnChild: Exception running
child : java.lang.NullPointerException
> 	at org.apache.hive.hcatalog.data.schema.HCatSchema.get(HCatSchema.java:105)
> 	at org.apache.sqoop.mapreduce.hcat.SqoopHCatImportHelper.convertToHCatRecord(SqoopHCatImportHelper.java:194)
> 	at org.apache.sqoop.mapreduce.hcat.SqoopHCatImportMapper.map(SqoopHCatImportMapper.java:52)
> 	at org.apache.sqoop.mapreduce.hcat.SqoopHCatImportMapper.map(SqoopHCatImportMapper.java:34)
> 	at org.apache.hadoop.mapreduce.Mapper.run(Mapper.java:145)
> 	at org.apache.hadoop.mapred.MapTask.runNewMapper(MapTask.java:784)
> 	at org.apache.hadoop.mapred.MapTask.run(MapTask.java:341)
> 	at org.apache.hadoop.mapred.YarnChild$2.run(YarnChild.java:163)
> 	at java.security.AccessController.doPrivileged(Native Method)
> 	at javax.security.auth.Subject.doAs(Subject.java:415)
> 	at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1628)
> 	at org.apache.hadoop.mapred.YarnChild.main(YarnChild.java:158)
> It seems that the error is caused by a column name containing a hyphen ('-').  Column
names are converted to java identifiers but later this converted name could not be found in
HCatalog schema.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message