Talend FAQ
来源:互联网 发布:百度提问软件 编辑:程序博客网 时间:2024/05/14 01:59
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
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
0 0
- Talend FAQ
- talend
- talend网址
- Talend Operations
- talend+教程网址
- talend中的传值
- eltproject:org.talend.rcp
- FAQ
- FAQ
- FAQ
- FAQ
- FAQ
- FAQ
- faq
- FAQ
- faq
- FAQ
- FAQ
- 全文检索原理(Luence倒排索引原理) 学Luence必看
- When An SO is closed ,how to cancel it
- Java - IP地址与数字之间互转
- 赚钱很难吗?
- jQuery EasyUI Combobox无法检索中文输入的问题
- Talend FAQ
- Servlet 细节总结
- CSharp_DevExpress_编辑器自定义;
- Android休眠唤醒驱动流程分析
- effective java 笔记(一)
- Lucene入门教程
- 科技博客立身
- Android休眠唤醒机制简介(二)
- 程序员学习资料分享---爱分享的程序员(新浪微博)