You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@drill.apache.org by Ioannis Katrimpouzas <io...@recup.de> on 2023/04/18 12:24:01 UTC

Combine http with SQL query

Hi,

I am trying to combine a query with http data and sql data but the query fails.



I would appreciate any help that you could provide me.





SELECT users.id as somee FROM myplugin.`db-1`.`s_user` as users

LEFT JOIN customersweclapp.customer as customers  ON users.id = customers.id

WHERE users.id = 5993



With the following error.

org.apache.drill.common.exceptions.UserRemoteException: DATA_READ ERROR: Failure while attempting to read from database. Sql: SELECT * FROM `db-1`.`s_user` Fragment: 5:0