SAP Knowledge Base Article - Preview

3237057 - Error while compiling statement: FAILED: SemanticException [Error 10011]: Line 8:14 Invalid function 'FunctionName' error message appears when running a query which contains a custom function created at the db level in Information Design Tool

Symptom

  • Error while compiling statement: FAILED: SemanticException [Error 10011]: Line 8:14 Invalid function 'FunctionName':17:16, org.apache.hive.service.cli.operation.Operation:toSQLException:Operation.java:329 error message appears when running a query which contains a customized function created at the database level in Information Design Tool.
  • The issue started to occur after the Hive server 1 database upgrade to Hive server 2.
  • In the database logs it's seen the query points to the default schema, however in IDT both the qualifier and owner set to the schema where the function created.
  • At the hive server the RELOAD function has performed, but the same error occurs.
  • When running a simple SQL containing the custom function in IDT at connection layer, the same error is seen.
  • Running the same SQL at database level, it runs properly.


Read more...

Environment

  • SAP BusinessObjects Business Intelligence Platform 4.2
  • SAP BusinessObjects Business Intelligence Platform 4.3
  • Web Intelligence
  • Information Design Tool
  • Hive CDH

Product

SAP BusinessObjects Business Intelligence platform 4.2 ; SAP BusinessObjects Business Intelligence platform 4.3

Keywords

invalid function hive cdh idt webi bi jdbc 4.2 4.3 custom , KBA , BI-BIP-IDT-CX , Connection Layer , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.