Re: Cannot send metadata info from Hive 2.0.1 to Hive metastore on Oracle 12c

2018-05-10 Thread Mich Talebzadeh
upgraded from hive 2.0.1 to hive 2.3.2 and it works now! 0: jdbc:hive2://rhes564:10099/default> create table abc(col1 int); No rows affected (1.21 seconds) 0: jdbc:hive2://rhes564:10099/default> desc abc; +---++--+ | col_name | data_type | comment |

Cannot send metadata info from Hive 2.0.1 to Hive metastore on Oracle 12c

2018-05-10 Thread Mich Talebzadeh
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: