Talend FAQ

talend 


use talend to load data from hdfs to RDBMS, you cannot specify column types. because sqoop will use table schema to judge which type the column is. 
i.e. if a column 'id' in target table Test is number type, then sqoop would treat this column as big decimal in its generated java code, if this column contains String or anything,
then errors will be poped up. but if you define this column as varchar type, then there is no error, as sqoop tream this column as string in java code.


make sure schema and table name are upper case




problems:
1. need use sqoop , show error jre not jdk


solution :
go talend -> window -> preference -> talend ->java intepretor locate it to jdk bin java.exe




2. if there show error that no class found which belong to hadoop lib


solution:
export HADOOP_YARN_HOME, HADOOP_COMMON_HOME, HADOOP_MAPREDUCE_HOME  to hadoop-env.sh


3. there may be some type format error


solution:
the possibility is that your delimiter, some values contains the defined delimiter, then this field will be splited result in wrong values being inserted in wrong fields, error will show