Hi team, I found that the

hive

plugin fails to ingest tables with table names starting with underscore (),_ such as

crm_.__test

. Upon drilling down, it is because pyhive’s

_get_table_columns()

doesn’t escape such table names with backtick (`), as can be seen here https://github.com/dropbox/PyHive/blob/master/pyhive/sqlalchemy_hive.py#L283 The DESCRIBE query for above case in Hive should be

describe `crm._test`;

instead of

describe crm._test;

I’m looking into this