You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "wenzhi wang (JIRA)" <ji...@apache.org> on 2013/05/13 04:23:16 UTC
[jira] [Updated] (SQOOP-1037) Cannot import mysql table with into
Hadoop
[ https://issues.apache.org/jira/browse/SQOOP-1037?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
wenzhi wang updated SQOOP-1037:
-------------------------------
Attachment: sqoop_import_error.log
OK, I attached the log. The hadoop I'm using is extracted from package hadoop-1.0.4.tar.gz (md5:dd348c5b802f9b267144a4594c7bdc4d), and sqoop is from package sqoop-1.4.3.bin__hadoop-1.0.0.tar.gz(md5:b0f4ba67f407463e9fd90506aae9f9bf).
> Cannot import mysql table with into Hadoop
> ------------------------------------------
>
> Key: SQOOP-1037
> URL: https://issues.apache.org/jira/browse/SQOOP-1037
> Project: Sqoop
> Issue Type: Bug
> Components: tools
> Affects Versions: 1.4.3
> Environment: bl1253{wenzhiw}/home/wenzhiw>cat /etc/redhat-release
> Scientific Linux SL release 5.3 (Boron)
> bl1253{wenzhiw}/home/wenzhiw>uname -a
> Linux bl1253.cn.alcatel-lucent.com 2.6.18-128.7.1.el5PAE #1 SMP Mon Aug 24 08:41:30 EDT 2009 i686 athlon i386 GNU/Linux
> Reporter: wenzhi wang
> Priority: Critical
> Attachments: sqoop_import_error.log
>
> Original Estimate: 504h
> Remaining Estimate: 504h
>
> Hi,
> I run Sqoop 1.4.3 on Apache Hadoop 1.0.4 and want to import table from mysql, but met below errors. I also searched jira site for this issue, but didn't find any useful info, please help to check. thanks!
> bl1253{wenzhiw}/local/wenzhiw/sqoop2/sqoop-1.4.3.bin__hadoop-0.23/bin>sqoop import --table IMSI --connect jdbc:mysql://135.252.158.250/hlr --username root -P
> Warning: /usr/lib/hbase does not exist! HBase imports will fail.
> Please set $HBASE_HOME to the root of your HBase installation.
> Warning: $HADOOP_HOME is deprecated.
> Enter password:
> 13/05/08 10:20:53 INFO manager.MySQLManager: Preparing to use a MySQL streaming resultset.
> 13/05/08 10:20:53 INFO tool.CodeGenTool: Beginning code generation
> 13/05/08 10:20:54 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `IMSI` AS t LIMIT 1
> 13/05/08 10:20:55 INFO manager.SqlManager: Executing SQL statement: SELECT t.* FROM `IMSI` AS t LIMIT 1
> 13/05/08 10:20:55 ERROR orm.ClassWriter: No parser available for Java type org.apache.hadoop.io.BytesWritable
> 13/05/08 10:20:55 ERROR orm.ClassWriter: No parser available for Java type org.apache.hadoop.io.BytesWritable
> 13/05/08 10:20:55 ERROR orm.ClassWriter: No parser available for Java type org.apache.hadoop.io.BytesWritable
> 13/05/08 10:20:55 ERROR orm.ClassWriter: No parser available for Java type org.apache.hadoop.io.BytesWritable
> 13/05/08 10:20:55 ERROR orm.ClassWriter: No parser available for Java type org.apache.hadoop.io.BytesWritable
> 13/05/08 10:20:55 ERROR orm.ClassWriter: No parser available for Java type org.apache.hadoop.io.BytesWritable
> ...
> Table definition:
> mysql> desc IMSI;
> +-------------------------------+-------------+------+-----+---------+-------+
> | Field | Type | Null | Key | Default | Extra |
> +-------------------------------+-------------+------+-----+---------+-------+
> | mSubIdentificationNumberId | binary(6) | NO | PRI | NULL | |
> | mobileNetworkCodeId | binary(3) | NO | PRI | NULL | |
> | mobileCountryCodeId | binary(3) | NO | PRI | NULL | |
> | mainMSISDN | binary(12) | YES | | NULL | |
> | alertMSISDN | binary(12) | YES | | NULL | |
> | associatedMSISDN | binary(88) | YES | | NULL | |
> | waitingGgsn | binary(4) | YES | | NULL | |
> | sgsnIsdn | binary(10) | YES | | NULL | |
> | sgsnIp | binary(18) | YES | | NULL | |
> | gprsNotReachableReason | tinyint(4) | YES | | NULL | |
> | sgsnLastGlobalUpdateTime | int(11) | YES | | NULL | |
> | localMobileStationIdentity | int(11) | YES | | NULL | |
> | vlrIsdn | binary(10) | YES | | NULL | |
> | mscIsdn | binary(10) | YES | | NULL | |
> | supOfLocRegCount | tinyint(4) | YES | | NULL | |
> | locRegSubsPeriod | smallint(6) | YES | | NULL | |
> | inducedCbocBsg | binary(7) | YES | | NULL | |
> | inducedCboiBsg | binary(7) | YES | | NULL | |
> | inducedCboehBsg | binary(7) | YES | | NULL | |
> | vlrLastGlobalUpdateTime | int(11) | YES | | NULL | |
> | currentMapScreeningProfile | int(11) | YES | | NULL | |
> | smscIsdn | binary(70) | YES | | NULL | |
> | gsmNotReachableReason | tinyint(4) | YES | | NULL | |
> | timeStampWaitingSms | binary(28) | YES | | NULL | |
> | checkSSindicator | tinyint(4) | YES | | NULL | |
> | supOfAutReqCount | tinyint(4) | YES | | NULL | |
> | autReqSubsPeriod | smallint(6) | YES | | NULL | |
> | underTestImsi | bit(1) | YES | | NULL | |
> | cardStatus | bit(1) | YES | | NULL | |
> | roamingCapabilityFlags | bit(1) | YES | | NULL | |
> | sgsnUpdateFlag | bit(1) | YES | | NULL | |
> | gprsEnhancementIndicator | bit(1) | YES | | NULL | |
> | sgsnGenUnsuppFeaturesFlags | bit(3) | YES | | NULL | |
> | gprsCamelPhase | bit(3) | YES | | NULL | |
> | gprsNegocCamelPhases | bit(6) | YES | | NULL | |
> | sgsnRoamingRestriction | bit(5) | YES | | NULL | |
> | gprsNotReachableFlag | bit(1) | YES | | NULL | |
> | roamingRestrictionFlags | bit(11) | YES | | NULL | |
> | vlrUpdateFlag | bit(1) | YES | | NULL | |
> | roamingCharactsFlags | bit(2) | YES | | NULL | |
> | flagCffPlmn | bit(1) | YES | | NULL | |
> | gsmCamelPhase | bit(3) | YES | | NULL | |
> | gsmNegocCamelPhases | bit(12) | YES | | NULL | |
> | odbUnsuppFeaturesFlags | bit(3) | YES | | NULL | |
> | vlrBasServUnsuppFeaturesFlags | bit(4) | YES | | NULL | |
> | vlrGenUnsuppFeaturesFlags | bit(7) | YES | | NULL | |
> | transferOfSmOption | bit(1) | YES | | NULL | |
> | gsmNotReachableSMSFlag | bit(1) | YES | | NULL | |
> | memoryCapacityExceededFlag | bit(1) | YES | | NULL | |
> | autReqSponSent | bit(1) | YES | | NULL | |
> +-------------------------------+-------------+------+-----+---------+-------+
> Thanks,
> Wenzhi
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira