[大数据]HIVE库查询表报错：[Error 10001]: Line 1:14 Table not found无法找到表

hive客户端执行SELECT * FROM mdm_entity_person_id_map where 1=1;报错：

 [SELECT - 0 row(s), 0.000 secs]  [Error Code: 10001, SQL State: 42S02]  Error while compiling statement: FAILED: SemanticException [Error 10001]: Line 1:14 Table not found 'mdm_entity_person_id_map'
... 1 statement(s) executed, 0 row(s) affected, exec/fetch time: 0.000/0.000 sec  [0 successful, 0 warnings, 1 errors]

参考https://stackoverflow.com/questions/31901669/hivefailed-semanticexception-error-10001-line-114-table-not-found-field

添加库表前缀，修改为SELECT * FROM collection.mdm_entity_person_id_map where 1=1;
执行成功。