backtick handling in Hive SQL parsing

[noobxiaohai]

Describe the bug
There seems to be an issue with backtick handling in Hive SQL parsing. My code contains backticks which work fine in Hive, but causes errors when being parsed by SQLLineage's frontend.

SQL
Paste the SQL text here. For example:

select  `desc` as description
    from t

To Reproduce
Note here we refer to SQL provided in prior step as stored in a file named test.sql

from sqllineage.runner import LineageRunner

test_sql_str = """
select  'desc' as description
    from t
"""
result = LineageRunner(test_sql_str, dialect="hive")
result.draw()

here is hive result

• else: whatever other ways to reproduce this bug.

Expected behavior
it shouldbe parsed right.

Python version (available via python --version)

• 3.11

SQLLineage version (available via sqllineage --version):

• 1.4.7

Additional context
I repalce the ` by ', and it works

[Bennylave]

@reata can you assign this to me?

[reata]

@reata can you assign this to me?

Let's triage first to see if this is frontend issue. I suspect LineageRunner can generate the table lineage and column lineage correctly in Python.

[Bennylave]

@reata I tested by running

sqllineage -e "SELECT ``desc`` as description FROM test" from the CLI and it indeed it works.

Statements(#): 1
Source Tables:
    <default>.test
Target Tables:

@noobxiaohai have you tried running this from the terminal?