Re: Hive Table Creation failure on Postgres

Ping to see if there is a jira filed around the same or if there is a config driven way to make metastore know what is the underlying schema created by different persistent stores On Fri, Jun 10, 2016 at 11:33 AM, Siddhi Mehta wrote: > Right so mysql and oracle both set the column to 256 bytes.

Re: Hive Table Creation failure on Postgres

Right so mysql and oracle both set the column to 256 bytes. Any postgres users who have seen the issue. HIVE-4921 jira talks about upgrading comments column to 4000 for 3 tables. Is than inconsistenty/bug with postgres schema creation script or i

Re: Hive Table Creation failure on Postgres

Well I know that the script works fine for Oracle (both base and transactional). Ok this is what this table is in Oracle. That column is 256 bytes. [image: Inline images 2] HTH Dr Mich Talebzadeh LinkedIn * https://www.linkedin.com/profile/view?id=AAEWh2gBxianrbJd6zP6AcPCCdOABUrV8Pw

Hive Table Creation failure on Postgres

Hello Everyone, We are using postgres for hive persistent store. We are making use of the schematool to create hive schema and our hive configs have table and column validation enabled. While trying to create a simple hive table we ran into the following error. Error: Error while processing sta