The CreateElasticsearchBackedHiveTable currently does not specify location when creating the table. Since creating a category also does not specify a LOCATION with the CREATE DATABASE command, Hive creates a default location e.g. 'hdfs://<namenode_hostname>:8020/user/hive/warehouse/<categoryname>.db/<feedname>'. In the case of the S3 template this can be a problem if the HDFS namenode gets renamed, or in the case of EMR where nodes are redefined with each new cluster.
In EMR case these steps will cause the error shown below:
1. Create a Category
2. Create a Feed for that category
3. Run a feed input through the feed so that one time initialization section of resuable flow is performed.
4. Stop EMR cluster, start EMR and reconfigure to new EMR
5. Create a new Feed using the above category
The following error will appear in Nifi logs and hiverserver2.log on cluster:
Work Around: It may be possible to drop the database created for the category and specify one with an S3 location before creating any feeds for the category.