Streaming does not work

Question

I am trying to enable hive streams by following
https://cwiki.apache.org/confluence/display/Hive/Streaming+Data+Ingest#StreamingDataIngest-StreamingRequirements

I changed all configuration properties to enable streaming using hive, but the bush metadata service works with the error below,

18/02/09 12:22:51 ERROR compactor.Initiator: Caught an exception in the main loop of compactor initiator, exiting MetaException(message:Unable to connect to transaction database org.postgresql.util.PSQLException: ERROR: relation "compaction_queue" does not exist

Note. I am using PostgreSQL for JDBC metadata and bush version 2.0.1.

Help me solve this error and get started with the Hive thread.

Answer 1

( , ACID-/ ) https://github.com/apache/hive/blob/branch-2.0/metastore/scripts/upgrade/postgres/hive-txn-schema-2.0.0.postgres.sql. .