Get "[Hortonworks][HiveODBC] (80) Syntax or semantic analysis error..." error using Database Browser
説明
Get the following error when connected to Hive and using Database Browser and other functionality. Editor is working fine.
[Hortonworks][HiveODBC] (80) Syntax or semantic analysis error thrown in server while execurint query. Error message from server: Error while compiling statement: FAILED: ParseException line 1:28 cannot recognize input near '.' '<Object_name>' '<EOF>' in table source
原因
Connection to Hive is through ODBC connection.
対策
Connect to Hive using native method. In the new connection window, there is a selection for Hive in the drop down field. Connect to Hive this way, instead of through ODBC.
