Re: Hive remote databases/tables proposal

2018-05-10 Thread Elliot West
The main problem I see with a SerDe based approach is that this abstraction is not able to expose the needed set of metadata for the target table. While the SerDe can return the schema (via getObjectInspector() I presume), there is no provision for the delivery of available partitions, or table

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:

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 |