Mailing-List: contact dev-help@sqoop.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@sqoop.apache.org
Date: Tue, 2 Jun 2015 15:04:18 +0000 (UTC)
From: "Pavel Benes (JIRA)" <jira@apache.org>
To: dev@sqoop.apache.org
Message-ID: <JIRA.12834619.1433257406000.94359.1433257458236@Atlassian.JIRA>
In-Reply-To: <JIRA.12834619.1433257406000@Atlassian.JIRA>
References: <JIRA.12834619.1433257406000@Atlassian.JIRA>
 <JIRA.12834619.1433257406562@arcas>
Subject: [jira] [Created] (SQOOP-2387) NPE thrown when sqoop tries to import
 table with column containing some special character
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Pavel Benes created SQOOP-2387:
----------------------------------

             Summary: 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.6, 1.4.5
         Environment: HDP 2.2.0.0-2041
            Reporter: Pavel Benes
            Priority: Critical


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)