[
https://issues.apache.org/jira/browse/NIFI-3093?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15994349#comment-15994349
]
ASF GitHub Bot commented on NIFI-3093:
--------------------------------------
Github user patricker commented on the issue:
https://github.com/apache/nifi/pull/1281
@mattyb149 I've completed the changes. I added support for
GenerateTableFetch, though Hive being hive it's not all that fast...
There is one quirk, and I feel it should be documented but I'm not sure
where. When using QueryDatabaseAdapter with Hive you need to qualify your max
value column with the table name. This is because Hive always qualifies the
column names in the ResultSet. Also, as a result of this, you'll need to
Normalize the column names.
With GenerateTableFetch, since it pulls back the max value through a query
and aliases the column name, I don't think the above issue is a problem.
ExecuteSQL should work without any special changes, just remember to select
a Database Adapter when testing HIVE, this didn't used to be an available
option.
> HIVE Support for QueryDatabaseTable
> -----------------------------------
>
> Key: NIFI-3093
> URL: https://issues.apache.org/jira/browse/NIFI-3093
> Project: Apache NiFi
> Issue Type: Improvement
> Components: Core Framework
> Reporter: Peter Wicks
> Assignee: Peter Wicks
>
> Update Query Database Table so that it can pull data from HIVE tables.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
