（本文档仅供参考）
问题
Excel导入模板导入数据到星环数据库时会有如下报错内容，该如何解决呢？
ERROR service(smartbi.daq.DataAcquisitionServlet:133) - excelimport
smartbi.SmartbiException: 校验星环表类型错误
at smartbi.daq.dbchecker.XinghuanDbChecker.doCheck(XinghuanDbChecker.java:84) ~[classes/:?]
at ...(...) ~[?:?]
at smartbi.log.PreparedStatementWarp.executeQuery(PreparedStatementWarp.java:323) ~[smartbi-Common.jar:?]
Caused by: java.sql.SQLException: COMPILE FAILED: Internal error HiveAccessControlException: [Error 20388] Permission denied: Principal [name=***, type=USER] does not have following privileges for operation SHOW_CREATETABLE [[SELECT with grant] on Object [type=TABLE_OR_VIEW, name=***]]
at org.apache.hive.jdbc.Utils.verifySuccess(Utils.java:286) ~[inceptor-driver.jar:0.12.0-transwarp-tdh460]
at org.apache.hive.jdbc.Utils.verifySuccessWithInfo(Utils.java:270) ~[inceptor-driver.jar:0.12.0-transwarp-tdh460]
at org.apache.hive.jdbc.HiveStatement.execute(HiveStatement.java:399) ~[inceptor-driver.jar:0.12.0-transwarp-tdh460]
at org.apache.hive.jdbc.HiveStatement.executeQuery(HiveStatement.java:568) ~[inceptor-driver.jar:0.12.0-transwarp-tdh460]
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) ~[commons-dbcp-1.4.jar:1.4]
at org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208) ~[commons-dbcp-1.4.jar:1.4]
问题原因
如excel导入模板导入到星环数据库中报错，对于星环数据库，只有Hyperbase/ES/Transaction Orc类型的数据库表才支持insert ……values的语法，为优化提示，会在后台逻辑中执行“show create table”查询对应表结构的建表语句，以判断当前的数据表类型是否是Excel导入模板支持导入的。从当前报错信息判断是由于当前数据源连接的用户没有该语句的执行权限，需联系DBA对对应用户增加该show语句的执行权限。
