Return-Path: X-Original-To: apmail-sqoop-dev-archive@www.apache.org Delivered-To: apmail-sqoop-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id BEEEB1859C for ; Tue, 2 Jun 2015 15:14:18 +0000 (UTC) Received: (qmail 5833 invoked by uid 500); 2 Jun 2015 15:14:18 -0000 Delivered-To: apmail-sqoop-dev-archive@sqoop.apache.org Received: (qmail 5797 invoked by uid 500); 2 Jun 2015 15:14:18 -0000 Mailing-List: contact dev-help@sqoop.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@sqoop.apache.org Delivered-To: mailing list dev@sqoop.apache.org Received: (qmail 5786 invoked by uid 99); 2 Jun 2015 15:14:18 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 02 Jun 2015 15:14:18 +0000 Date: Tue, 2 Jun 2015 15:14:18 +0000 (UTC) From: "Pavel Benes (JIRA)" To: dev@sqoop.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (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 X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ 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)