Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

putSql exception

Solved Go to solution
Highlighted

putSql exception

New Contributor

Hi,

I tried to insert some data in postgresql db using PUTSQL processor.

Below example of sql statement in putSql properties:

 

INSERT INTO myTable(date_response, success, code, payload_response) values ('${now()}', '${status:toNumber()}', '${code:toNumber()}', ${payload});

 

 The problem is when this insert is executed, i have this error:

org.postgresql.util.PSQLException: ERROR: column "zxlbavuzvmlvm2x6vedsemrdstzjrnnnzxlbavuzvmlvm2x6swpvz2v5qwlhv1f" does not exist.

What happen ? .... the payload_response column name is replace by the value of my flow file attribute ${payload}. Why ? any hints ?

1 ACCEPTED SOLUTION

Accepted Solutions

Re: putSql exception

Cloudera Employee

I'm on mobile but could it be that you are not wrapping it around the single quotes?

View solution in original post

2 REPLIES 2

Re: putSql exception

Cloudera Employee

I'm on mobile but could it be that you are not wrapping it around the single quotes?

View solution in original post

Highlighted

Re: putSql exception

New Contributor

thanks, i forgot simple quote .. i'm stupid

Don't have an account?
Coming from Hortonworks? Activate your account here