Hi,
Running Hive 2.0.1 on Oracle 12c, it seems that Hive cannot perform insert
metadata info into metadata table "HIVEUSER"."TBLS"
When I try to create a simple table in Hive. It sends null values to Oracle
metastore.
0: jdbc:hive2://rhes564:10099/default> use test2;
0: jdbc:hive2://rhes564:10099/default> create table michboy(col1 int, col2
varchar(30));
ERROR : FAILED: Execution Error, return code 1 from
org.apache.hadoop.hive.ql.exec.DDLTask.
MetaException(message:javax.jdo.JDODataStoreException: Insert of object
"org.apache.hadoop.hive.metastore.model.MTable@6b511a66" using statement
"INSERT INTO TBLS
*(TBL_ID,CREATE_TIME,DB_ID,LAST_ACCESS_TIME,OWNER,RETENTION,SD_ID,TBL_NAME,TBL_TYPE,VIEW_EXPANDED_TEXT,VIEW_ORIGINAL_TEXT)
VALUES (?,?,?,?,?,?,?,?,?,?,?)" failed : ORA-01400: cannot insert NULL into
("HIVEUSER"."TBLS"."IS_REWRITE_ENABLED")*
java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert
NULL into ("HIVEUSER"."TBLS"."IS_REWRITE_ENABLED")
Any ideas what can cause this?
The version of Hive in Oracle hive metadata is:
select * from version;
VER_ID, SCHEMA_VERSION, VERSION_COMMENT
1 2.0.0 Hive release version 2.0.0
Thanks
Dr Mich Talebzadeh
LinkedIn *
https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw
<https://www.linkedin.com/profile/view?id=AAEAAAAWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw>*
http://talebzadehmich.wordpress.com
*Disclaimer:* Use it at your own risk. Any and all responsibility for any
loss, damage or destruction of data or any other property which may arise
from relying on this email's technical content is explicitly disclaimed.
The author will in no case be liable for any monetary damages arising from
such loss, damage or destruction.
