[HIVE-22070] metadata discovery shows no tables if database name has underscore (_)

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 3.0.0
• Component/s: Authorization

Environment

HDP 3.1, Denodo 7, Informatica EDC 10.2.2, 

Ranger authentication for Hive enabled.

• Assignee: Unassigned
• Reporter: Luo Donghua
• Created: 01/Aug/19 15:08
• Updated: 06/Aug/19 03:40

Description

We discovered follow behaviors:

connect to hive database using beeline is okay, and able to list table using "show tables" command

when we connect to JDBC drivers from Denodo or informatica EDC, we can't browse the table list if database name has  underscore ("_"), for example abc_mart

after create new database with name like abcmart, it works fine for denodo/informatica EDC