[
https://issues.apache.org/jira/browse/SQOOP-2387?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14933738#comment-14933738
]
Hudson commented on SQOOP-2387:
-------------------------------
FAILURE: Integrated in Sqoop-hadoop20 #1017 (See
[https://builds.apache.org/job/Sqoop-hadoop20/1017/])
SQOOP-2387: Sqoop should support importing from table with column names
containing some special character (jarcec:
https://git-wip-us.apache.org/repos/asf?p=sqoop.git&a=commit&h=6987d290fed6c5b6abed27ea13db258cde2565dd)
* src/test/org/apache/sqoop/hcat/HCatalogTestUtils.java
* src/docs/user/import.txt
* src/java/org/apache/sqoop/manager/HsqldbManager.java
* src/java/org/apache/sqoop/avro/AvroUtil.java
* src/java/org/apache/sqoop/mapreduce/hcat/SqoopHCatUtilities.java
* src/test/com/cloudera/sqoop/TestIncrementalImport.java
* src/java/org/apache/sqoop/mapreduce/hcat/SqoopHCatImportHelper.java
* src/test/com/cloudera/sqoop/TestAvroImport.java
* src/java/org/apache/sqoop/orm/ClassWriter.java
* src/test/com/cloudera/sqoop/TestParquetImport.java
* src/test/org/apache/sqoop/hcat/HCatalogImportTest.java
* build.xml
* src/test/com/cloudera/sqoop/testutil/BaseSqoopTestCase.java
> Sqoop should support importing from table with column names 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
> Assignee: Venkat Ranganathan
> Priority: Critical
> Fix For: 1.4.7
>
> Attachments: SQOOP-2387.1.patch, SQOOP-2387.2.patch,
> SQOOP-2387.patch, SQOOP-2387.patch, joblog.txt, sqoop.log
>
>
> This sqoop import:
> {code}
> 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
> {code}
> fails with with this error:
> {code}
> 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)
> {code}
> 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)
