Hive thrift service takes 15 minutes to refresh a database connection

Description

When testing an EMR restart, it was noticed that the Create Feed Partition will take 15 to 16 minutes to successfully process the first flow. It is thought that the hive connection has a default timeout in either the data source or perhaps the validation query that is set to 15 minutes.

If there is a location where a smaller timeout can be set then we should expose a nifi property in the service controller to allow setting a lower timeout.

Activity

Show:
Tim Harsch
March 29, 2017, 7:20 PM

It may be that we need to set some session timeouts
http://www.ericlin.me/how-to-configue-session-timeout-in-hive

Done

Assignee

Tim Harsch

Reporter

Tim Harsch

Labels

None

Reviewer

None

Components

Sprint

None

Fix versions

Priority

Medium