http://www.datastax.com/support-forums/topic/errordbmarshalexception-97-is-not-recognized-as-a-valid-typeimporting-data-from-mysql-to-cassandra Software, Support, and Training for Apache Cassandra en-US Tue, 21 May 2013 22:16:23 +0000 http://bbpress.org/?v=1.0.3 q http://www.datastax.com/support-forums/search.php http://www.datastax.com/support-forums/topic/errordbmarshalexception-97-is-not-recognized-as-a-valid-typeimporting-data-from-mysql-to-cassandra#post-4977 Fri, 03 Aug 2012 08:38:19 +0000 rajeshkumar 4977@http://www.datastax.com/support-forums/ <p>Hi Everyone,<br /> I am trying to import data into cassandra column family from mysql and i am getting the following error.</p> <p>ERROR sqoop.Sqoop: Got exception running Sqoop: org.apache.cassandra.db.marshal.MarshalException: 97 is not recognized as a valid type<br /> org.apache.cassandra.db.marshal.MarshalException: 97 is not recognized as a valid type<br /> at com.datastax.bdp.util.CompositeUtil.deserialize(CompositeUtil.java:93)<br /> at com.datastax.bdp.hadoop.cfs.CassandraFileSystemThriftStore.retrieveINode(CassandraFileSystemThriftStore.java:585)<br /> at com.datastax.bdp.hadoop.cfs.CassandraFileSystemThriftStore.retrieveINode(CassandraFileSystemThriftStore.java:563)<br /> at com.datastax.bdp.hadoop.cfs.CassandraFileSystem.getFileStatus(CassandraFileSystem.java:520)<br /> at org.apache.hadoop.fs.FileSystem.exists(FileSystem.java:768)<br /> at org.apache.hadoop.mapreduce.JobSubmissionFiles.getStagingDir(JobSubmissionFiles.java:103)<br /> at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:856)<br /> at org.apache.hadoop.mapred.JobClient$2.run(JobClient.java:850)<br /> at java.security.AccessController.doPrivileged(Native Method)<br /> at javax.security.auth.Subject.doAs(Subject.java:396)<br /> at org.apache.hadoop.security.UserGroupInformation.doAs(UserGroupInformation.java:1093)<br /> at org.apache.hadoop.mapred.JobClient.submitJobInternal(JobClient.java:850)<br /> at org.apache.hadoop.mapreduce.Job.submit(Job.java:500)<br /> at org.apache.hadoop.mapreduce.Job.waitForCompletion(Job.java:530)<br /> at org.apache.sqoop.mapreduce.ImportJobBase.runJob(ImportJobBase.java:119)<br /> at org.apache.sqoop.mapreduce.ImportJobBase.runImport(ImportJobBase.java:179)<br /> at org.apache.sqoop.manager.SqlManager.importTable(SqlManager.java:423)<br /> at org.apache.sqoop.manager.MySQLManager.importTable(MySQLManager.java:97)<br /> at org.apache.sqoop.tool.ImportTool.importTable(ImportTool.java:380)<br /> at org.apache.sqoop.tool.ImportTool.run(ImportTool.java:453)<br /> at org.apache.sqoop.Sqoop.run(Sqoop.java:145)<br /> at org.apache.hadoop.util.ToolRunner.run(ToolRunner.java:65)<br /> at org.apache.sqoop.Sqoop.runSqoop(Sqoop.java:181)<br /> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:220)<br /> at org.apache.sqoop.Sqoop.runTool(Sqoop.java:229)<br /> at org.apache.sqoop.Sqoop.main(Sqoop.java:238)<br /> at com.cloudera.sqoop.Sqoop.main(Sqoop.java:57)</p> <p>Could anyone help me solve this issue.</p> <p>Thanks<br /> Rajesh Kumar </p>