Error while Running SQl Query

sj0071992
sj0071992 Partner, Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Dataiku DSS Developer, Neuron 2022, Neuron 2023 Posts: 131 Neuron

Hi Team,

error.PNG

i am experiencing one error while running my sql query and unable to find the root cause for the same.

attaching the screenshot for the reference.

Could you please help here

Thanks in advance

Answers

  • Alexandru
    Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,225 Dataiker

    Hi @sj0071992
    ,

    The error "Unable to interpret the update count in command completion tag: INSERT 0 3247470694" may indicate you are trying to insert a larger number of rows than what the JDBC driver can handle.

    Are you using Redshift/Postgres?
    What DSS version are you on exactly, and what driver version?
    Also, if you are seeing this and using Redshift you may want to consider using fast-path instead: https://doc.dataiku.com/dss/latest/connecting/sql/redshift.html#writing-data-into-redshift

    If you need further assistance on it may be best to open a support ticket and share the job diagnostics.

Setup Info
    Tags
      Help me…