Sqoop ERROR tool.ImportTool: Imported Failed: There is no column found in the target table
来源:互联网 发布:关于农副产品的软件 编辑:程序博客网 时间:2024/03/29 09:19
Sqoop从oracle中导入数据到hive时,若在导入表不属于指定用户, 则在导入的表名前需要添加大写的所属用户的用户名
如:
sqoop import --hive-import --connect "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xx.xxx.xx.xxx)(PORT=1521)))(LOAD_BALANCE=yes)(CONNECT_DATA=(SERVICE_NAME=cass)))" --table TPLAN_GROUPS --hive-table TM_PLAN_GROUPS --username aaa --password 123456
报错信息如下:
ERROR tool.ImportTool: Imported Failed: There is no column found in the target table cas.TPLAN_GROUPS. Please ensure that your table name is correct.
将原–table参数改为 CAS.TPLAN_GROUPS
即:
sqoop import --hive-import --connect "jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xx.xxx.xx.xxx)(PORT=1521)))(LOAD_BALANCE=yes)(CONNECT_DATA=(SERVICE_NAME=cass)))" --table CAS.TPLAN_GROUPS --hive-table TM_PLAN_GROUPS --username aaa --password 123456
阅读全文
0 0
- Sqoop ERROR tool.ImportTool: Imported Failed: There is no column found in the target table
- sqoop ERROR tool.ImportTool: Error during import: Import job failed!
- there is no examin menu in the top tool bar
- Sqoop异常解决ERROR tool.ImportTool: Encountered IOException running import job: java.io.IOException: No
- sqoop.Sqoop: Got exception running Sqoop: java.lang.IllegalArgumentException: There is no column fou
- ERROR tool.ImportTool: Import failed: java.io.IOException: Hive does not support the SQL type for co
- sqoop执行报错ERROR tool.ImportTool: Encountered IOException running import job: java.io.FileNotFoundExce
- There is no source found
- error:There is no SDK with the name or...
- IOS error "There is no SDK with the or path...."
- SQL Server Error Messages - Msg 1776 : There are no primary or candidate keys in the referenced Table
- The First Column in a Table Is Always Left-Aligned
- [ERROR] The goal you specified requires a project to execute but there is no POM in this directory
- [ERROR] The goal you specified requires a project to execute but there is no POM in this directory
- FAILED: SemanticException [Error 10044]: Line 1:23 Cannot insert into target table because column...
- error : Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in
- sqoop 导入oracle 报错 Imported Failed : Attempted to generate class with no columns问题解决办法
- Error itms-90167 no .app bundles found in the package
- Eclipse编写spring(4.3.9)+springMVC(4.3.9)+Mybatis(3.4.1)/Hibernate(4.3.11)+mysql(5.7)+log4j2项目
- 关于U8,U9中采购订单直接转PDF文件,然后直接发送给相应供应商的解决方案
- 基于Cocos2d-x学习OpenGL ES 2.0系列——OpenGL ES渲染之Shader准备(7)
- SpringMVC中使用Interceptor处理器拦截器
- mysql格式化日期
- Sqoop ERROR tool.ImportTool: Imported Failed: There is no column found in the target table
- ThreadLocal
- Codeforces 266B
- android 事件分发
- c++中的explicit关键字及隐式类型转换
- 初学四旋翼之光流定点
- Rabbitmq priority 优先级
- Tsung:开源多协议分布式负载&压力测试工具
- 静态变量/非静态变量的区别