[jira] [Commented] (NIFI-7345) Multiple entity is created in Atlas for one Hive table if table name contains uppercase characters

["ASF subversion and git services (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/NIFI-7345?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17079263#comment-17079263 ] 

ASF subversion and git services commented on NIFI-7345:
-------------------------------------------------------

Commit 08dcd4af14386183d0cd84690772b5ad93f75b9f in nifi's branch refs/heads/master from Peter Turcsanyi
[ https://gitbox.apache.org/repos/asf?p=nifi.git;h=08dcd4a ]

NIFI-7345: Fixed Hive database and table names case insensitivity in Atlas reporting task

Signed-off-by: Pierre Villard <pi...@gmail.com>

This closes #4198.


> Multiple entity is created in Atlas for one Hive table if table name contains uppercase characters
> --------------------------------------------------------------------------------------------------
>
>                 Key: NIFI-7345
>                 URL: https://issues.apache.org/jira/browse/NIFI-7345
>             Project: Apache NiFi
>          Issue Type: Bug
>          Components: Extensions
>    Affects Versions: 1.11.4
>            Reporter: Tamas Fulop
>            Assignee: Peter Turcsanyi
>            Priority: Minor
>
> Both Hive and NiFi create new hive_table entities in Atlas if table name contains uppercase character(s) in NiFi and lineage is reported into the entity that NiFi created. Hive is case insensitive, so it would be nice if Hive table names are treated like that within NiFi as well.
> h5. Steps to reproduce
>  # Create a table in Hive (I did it in Hive CLI) - it doesn't matter if it's uppercase or lowercase, Hive's output will show it lowercase anyway
>  # A new entity in Atlas should be created and the Audits tab on Atlas UI should show that it is created by Hive
>  # Insert something into the Hive table
>  # I created the following flow in NiFi: SelectHiveQL -> LogAttribute - configure SelectHiveQL in a way that the Hive table it uses contains uppercase character(s)
>  # Start the flow
>  # A new hive_table entity in Atlas should be created (the table's name is what is in SelectHiveQL) and the Audits tab should show that it was created by NiFi
> There is no issue if the table name used in NiFi only contains lowercase characters.
>  I could reproduce it using Hive 3 processors as well.



--
This message was sent by Atlassian Jira
(v8.3.4#803005)