zhangzhongzhong的博客

ZY_BINGCHENGJL,0: The OCI function OCIStmtExecute returned status -1. Error code: 24,816, Error message: ORA-24816: Expanded non LONG bind data supplied after actual LONG or LOB column. (CC_OraStatement::executeInsert, file CC_OraStatement.cpp, line 1,94..

源端SQL时间字段修改为FUN_TO_DATE(DATE_FIELD)

以上错误调整工程环境变量如图：扩大

源端日期格式改为varchar2

修改内容如下：

ZY_SHUQIANXJ_V,0: The OCI function OCIStmtFetch2 returned status -1. Error code: 1,455, Error message: ORA-01455: converting column overflows integer datatype. (CC_OraStatement::fetch, file CC_OraStatement.cpp, line 1,599)datastage 列属性，插入列后若不修改列属性可空，将在执行

GY_BINGRENZXX,1: The OCI function OCIStmtExecute returned status 1. Error code: 12899, Error message: ORA-12899: value too large for column "CDR"."GY_BINGRENZXX_NEW"."GUOJIDM" (actual: 4, maximum: 3). varchar2类型源长度大于目标长度Error message: ORA-01861: liter.

While reading data for column HUANZHEXM, the connector received Oracle error code ORA-1406. (CC_OraStatement:Datastage运行报错 是由于中的列比sql实际查出来的小，原来huanzhexm是varchar2（1）

处方记录,0: The OCI function OCIStmtFetch2 returned status -1. Error code: 3,113, Error message: ORA-03113: end-of-file on communication channelProcess ID: 27425Session ID: 4954 Serial number: 1579. (CC_OraStatement::fetch, file CC_OraStatement.cpp, line 1

HIVE中NULL值的处理

full join增量刷新

HIVE 时间操作函数

Hive数据模型和存储

hive修改 表/分区语句

Greenplum数据DML

Hive修改表

HiveQL查询中JOIN语句

Hive四种类型的运算符

hive SQL函数