[GitHub] ayushi2810 opened a new issue #6435: postgresql syntax error while Initializing cached lookups on coordinator for first time

[GitBox <gi...@apache.org>]

ayushi2810 opened a new issue #6435: postgresql syntax error while Initializing cached lookups on coordinator for first time
URL: https://github.com/apache/incubator-druid/issues/6435
 
 
   I am trying to setup lookups on a cluster wide druid .
   Have included "druid-lookups-cached-global" in my load list.
   
   As mentioned in the doc, I tried to post an empty json object {} to /druid/coordinator/v1/lookups/config to initialize the configuration.
   
   my command: curl -X 'POST' -d @blank.json http://localhost:8081/druid/coordinator/v1/lookups/config/
   
   {localhost is my coordinator node in distributed environment.My blank.json contains : {}}
   
   I get the following on posting an empty json:
   
   Caused by: org.skife.jdbi.v2.exceptions.UnableToExecuteStatementException: org.postgresql.util.PSQLException: ERROR: syntax error at or near "UPDATE"
     Position: 18 [statement:"BEGIN;
   LOCK TABLE druid_config IN SHARE ROW EXCLUSIVE MODE;
   WITH upsert AS (UPDATE druid_config SET payload=:value WHERE name=:key RETURNING *)
       INSERT INTO druid_config (name, payload) SELECT :key, :value WHERE NOT EXISTS (SELECT * FROM upsert)
   ;COMMIT;", located:"BEGIN;
   LOCK TABLE druid_config IN SHARE ROW EXCLUSIVE MODE;
   WITH upsert AS (UPDATE druid_config SET payload=:value WHERE name=:key RETURNING *)
       INSERT INTO druid_config (name, payload) SELECT :key, :value WHERE NOT EXISTS (SELECT * FROM upsert)
   ;COMMIT;", rewritten:"BEGIN;
   LOCK TABLE druid_config IN SHARE ROW EXCLUSIVE MODE;
   WITH upsert AS (UPDATE druid_config SET payload=? WHERE name=? RETURNING *)
       INSERT INTO druid_config (name, payload) SELECT ?, ? WHERE NOT EXISTS (SELECT * FROM upsert)
   ;COMMIT;", arguments:{ positional:{}, named:{value:[123, 125],key:'lookupsConfig'}, finder:[]}]
   
   
   Please help !
   

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@druid.apache.org
For additional commands, e-mail: commits-help@druid.apache.org