Start a new topic
Answered

Issue to use SQLtoParameter Component with HBase

Hello,


When I try to execute my HBase query with SQLtoParameter component I have a Null poniter error.


Here is my query : 


Here is the issue occurs :



Best Answer

Hello,


This behavior occurs with HBase because it's not an "Rdbms" technology. 


As a result, xDI's SqlToParameters action is unable to automatically define the connection.


One solution is to set the SQL_CONNECTION property on the SqlToParameters action to specify the connection. 

To do this, you need to add an SQL_CONNECTION parameter to the action and provide the value %connection{$metadata_name}%.


For example:


1 Comment

Answer

Hello,


This behavior occurs with HBase because it's not an "Rdbms" technology. 


As a result, xDI's SqlToParameters action is unable to automatically define the connection.


One solution is to set the SQL_CONNECTION property on the SqlToParameters action to specify the connection. 

To do this, you need to add an SQL_CONNECTION parameter to the action and provide the value %connection{$metadata_name}%.


For example:


Login to post a comment