通过mapr drill odbc驱动程序读取配置单元表时出现ms powerbi错误

kq4fsx7k  于 2021-06-26  发布在  Hive
关注(0)|答案(1)|浏览(252)

我在尝试通过mapr drill odbc驱动程序将配置单元表中的数据读取到microsoft powerbi桌面工具时遇到此错误:-

DataSource.Error: ODBC: ERROR [HY000] [MapR][Drill] (1040) Drill failed to execute the query: 
from `hive.database`.`demo_table`
[30027]Query execution error. Details:[ 
PARSE ERROR: Encountered "from" at line 2, column 1.
Was expecting one of:
    "ALTER" ...
    "SET" ...
    "RESET" ...
    "WITH" ...
    "+" ...
    "-" ...
    <UNSIGNED_INTEGER_LITERAL> ...
    <DECIMAL_NUMERIC_LITERAL> ...
    <APPROX_NUMERIC_LITERAL> ...
    <BINARY_STRING_LITERAL> ...
    <PREFIXED_STRING_LITERAL> ...
    <QUOTED_STRING> ...
    <UNICODE_STRING_LITERAL> ...
    "TRUE" ...
    "FALSE" ...
    "UNKNOWN" ...
    "NULL" ...
    <LBRACE_D> ...
    <LBRACE_T> ...
    <LBRACE_TS> ...
    "DATE" ...
    "TIME" ...
    "TIMESTAMP" ...
    "INTERVAL" ...
    "?" ...
    "CAST" ...
    "EXTRACT" ...
    "POSITION" ...
    "CONVERT" ...
    "TRANSLATE" ...
    "OVERLAY" ...
    "FLOOR" ...
    "CEIL" ...
    "CEILING" ...
    "SUBSTRING" ...
    "TRIM" ...
    <LBRACE_FN> ...
    "MULTISET" ...
    "ARRAY" ...
    "SPECIFIC" ...
    <IDENTIFIER> ...
    <QUOTED_IDENTIFIER> ...
    <BACK_QUOTED_IDENTIFIER> ...
    <BRACKET_QUOTED_IDENTIFIER> ...
    <UNICODE_QUOTED_IDENTIFIER> ...
    "ABS" ...
    "AVG" ...
    "CARDINALITY" ...
    "CHAR_LENGTH" ...
    "CHARACTER_LENGTH" ...
    "COALESCE" ...
    "COLLECT" ...
    "COVAR_POP" ...
    "COVAR_SAMP" ...
    "CUME_DIST" ...
    "COUNT" ...
    "CURRENT_DATE" ...
    "CURRENT_TIME" ...
    "CURRENT_TIMESTAMP" ...
    "DENSE_RANK" ...
    "ELEMENT" ...
    "EXP" ...
    "FIRST_VALUE" ...
    "FUSION" ...
    "GROUPING" ...
    "LAST_VALUE" ...
    "LN" ...
    "LOCALTIME" ...
    "LOCALTIMESTAMP" ...
    "LOWER" ...
    "MAX" ...
    "MIN" ...
    "MOD" ...
    "NULLIF" ...
    "OCTET_LENGTH" ...
    "PERCENT_RANK" ...
    "POWER" ...
    "RANK" ...
    "REGR_SXX" ...
    "REGR_SYY" ...
    "ROW_NUMBER" ...
    "SQRT" ...
    "STDDEV_POP" ...
    "STDDEV_SAMP" ...
    "SUM" ...
    "UPPER" ...
    "VAR_POP" ...
    "VAR_SAMP" ...
    "CURRENT_CATALOG" ...
    "CURRENT_DEFAULT_TRANSFORM_GROUP" ...
    "CURRENT_PATH" ...
    "CURRENT_ROLE" ...
    "CURRENT_SCHEMA" ...
    "CURRENT_USER" ...
    "SESSION_USER" ...
    "SYSTEM_USER" ...
    "USER" ...
    "NEW" ...
    "CASE" ...
    "NEXT" ...
    "CURRENT" ...
    "CURSOR" ...
    "ROW" ...
    "NOT" ...
    "EXISTS" ...
    "(" ...
    "SELECT" ...
    "VALUES" ...
    "TABLE" ...
    "EXPLAIN" ...
    "INSERT" ...
    "UPSERT" ...
    "DELETE" ...
    "UPDATE" ...
    "MERGE" ...
    "CALL" ...
    "SHOW" ...
    "DESCRIBE" ...
    "USE" ...
    "CREATE" ...
    "DROP" ...
    "REFRESH" ...

while parsing SQL query:

from `hive.database`.`demo_table`
^

[Error Id: 9688f8e6-3ce6-42e1-8ef8-94931f511822 on sandbox.hortonworks.com:31010]
]
Details:
    DataSourceKind=Odbc
    DataSourcePath=dsn=MapR ODBC Driver for Drill DSN
    OdbcErrors=Table
4urapxun

4urapxun1#

对不起,我找到解决办法了。值得注意的是,microsoftpowerbi不接受模式和表名称中的特殊字符。

相关问题