I have changed all configuration properties to enable hive streaming, but the following error occurs when the hive Metastore service is running,
18/02/09 12:22:51 error compactor.Initiator: in compactor Catch the exception in the initiator’s main loop and exit MetaException (message: Unable to connect to the transaction database org.postgresql.util.PSQLException: ERROR: relation “compaction_queue” does not exist
Note: I use PostgreSQL for the JDBC Metastore And hive version 2.0.1
Help me solve this error and start using Hive Streaming.
I tried to follow https://cwiki.apache. org/confluence/display/Hive/Streaming+Data+Ingest#StreamingDataIngest-StreamingRequirements to enable hive streaming
I have changed all configuration properties to enable hive streaming, but the hive Metastore service is running The following error occurred,
18/02/09 12:22:51 Error compactor.Initiator: Catch an exception in the main loop of the compactor initiator and exit MetaException(Message: Unable to connect to transaction database org.postgresql.util.PSQLException: ERROR: relation “compaction_queue” does not exist
Note: I use PostgreSQL for JDBC Metastore and hive version 2.0.1
Help me solve this error and start using Hive Streaming.
The definition of this table (and other tables related to ACID tables/stream reception) It can be found in https://github.com/apache/hive/blob/branch-2.0/metastore/scripts/upgrade/postgres/hive-txn-schema-2.0.0.postgres.sql. All of these are streaming Necessary for the transmission to function properly.