Performing a sqoop import using 'hive-import' into a data type char() or varchar() fails with
17/06/05 14:04:44 INFO mapreduce.Job: Task Id : attempt_1496415095220_0016_m_000002_0, Status : FAILED
Error: java.lang.ClassNotFoundException: org.apache.hadoop.hive.serde2.SerDeException
at java.net.URLClassLoader.findClass(URLClassLoader.java:381)
Working example. Create the Teradata and hive tables as follows:
Terdata> create table td_importme_into_hive (col1 int not null primary key, col2 char(30));
Hive> create table td_import (col1 int, col2 char(30));