<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>question Nifi PutCassandraRecord -  How to use conditional updates for serializable writes: {} in Support Questions</title>
    <link>https://community.cloudera.com/t5/Support-Questions/Nifi-PutCassandraRecord-How-to-use-conditional-updates-for/m-p/381019#M244206</link>
    <description>&lt;P&gt;I have a nifi flow to read from 1 table and write to another.&amp;nbsp;&lt;/P&gt;&lt;P&gt;But when it inserts&amp;nbsp; it thows the error:&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;PutCassandraRecord[id=bf945542-ef3f-1b23-0000-0000463e16ae] Unable to write the records into Cassandra table due to com.datastax.driver.core.exceptions.InvalidQueryException: You must use conditional updates for serializable writes
- Caused by: com.datastax.driver.core.exceptions.InvalidQueryException: You must use conditional updates for serializable writes: {}&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mr_jahurley_0-1703019283726.png" style="width: 400px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/39212i9F56E85DE24E517D/image-size/medium?v=v2&amp;amp;px=400" role="button" title="mr_jahurley_0-1703019283726.png" alt="mr_jahurley_0-1703019283726.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;putCassandraRecord processor:&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mr_jahurley_1-1703019372997.png" style="width: 400px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/39213iBDCFA1205CFE7DC9/image-size/medium?v=v2&amp;amp;px=400" role="button" title="mr_jahurley_1-1703019372997.png" alt="mr_jahurley_1-1703019372997.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;I have tried both serial and local_serial, and none, but all give same error.&amp;nbsp;&lt;/P&gt;&lt;P&gt;I am able to run this if i use putCassandraQL but that means i also have to have a&amp;nbsp;&lt;SPAN&gt;EvaluateJsonPath and a&amp;nbsp;ReplaceText&amp;nbsp; to create the insert statement. I am trying to make it more efficient by using the record aware processor. Any help would be appreciated.&amp;nbsp;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Thank you!&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Tue, 19 Dec 2023 21:03:56 GMT</pubDate>
    <dc:creator>mr_jahurley</dc:creator>
    <dc:date>2023-12-19T21:03:56Z</dc:date>
    <item>
      <title>Nifi PutCassandraRecord -  How to use conditional updates for serializable writes: {}</title>
      <link>https://community.cloudera.com/t5/Support-Questions/Nifi-PutCassandraRecord-How-to-use-conditional-updates-for/m-p/381019#M244206</link>
      <description>&lt;P&gt;I have a nifi flow to read from 1 table and write to another.&amp;nbsp;&lt;/P&gt;&lt;P&gt;But when it inserts&amp;nbsp; it thows the error:&amp;nbsp;&lt;/P&gt;&lt;PRE&gt;PutCassandraRecord[id=bf945542-ef3f-1b23-0000-0000463e16ae] Unable to write the records into Cassandra table due to com.datastax.driver.core.exceptions.InvalidQueryException: You must use conditional updates for serializable writes
- Caused by: com.datastax.driver.core.exceptions.InvalidQueryException: You must use conditional updates for serializable writes: {}&lt;/PRE&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mr_jahurley_0-1703019283726.png" style="width: 400px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/39212i9F56E85DE24E517D/image-size/medium?v=v2&amp;amp;px=400" role="button" title="mr_jahurley_0-1703019283726.png" alt="mr_jahurley_0-1703019283726.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;putCassandraRecord processor:&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mr_jahurley_1-1703019372997.png" style="width: 400px;"&gt;&lt;img src="https://community.cloudera.com/t5/image/serverpage/image-id/39213iBDCFA1205CFE7DC9/image-size/medium?v=v2&amp;amp;px=400" role="button" title="mr_jahurley_1-1703019372997.png" alt="mr_jahurley_1-1703019372997.png" /&gt;&lt;/span&gt;&lt;/P&gt;&lt;P&gt;I have tried both serial and local_serial, and none, but all give same error.&amp;nbsp;&lt;/P&gt;&lt;P&gt;I am able to run this if i use putCassandraQL but that means i also have to have a&amp;nbsp;&lt;SPAN&gt;EvaluateJsonPath and a&amp;nbsp;ReplaceText&amp;nbsp; to create the insert statement. I am trying to make it more efficient by using the record aware processor. Any help would be appreciated.&amp;nbsp;&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN&gt;Thank you!&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Tue, 19 Dec 2023 21:03:56 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Support-Questions/Nifi-PutCassandraRecord-How-to-use-conditional-updates-for/m-p/381019#M244206</guid>
      <dc:creator>mr_jahurley</dc:creator>
      <dc:date>2023-12-19T21:03:56Z</dc:date>
    </item>
    <item>
      <title>Re: Nifi PutCassandraRecord -  How to use conditional updates for serializable writes: {}</title>
      <link>https://community.cloudera.com/t5/Support-Questions/Nifi-PutCassandraRecord-How-to-use-conditional-updates-for/m-p/393434#M248454</link>
      <description>&lt;P&gt;Trying to bring this back up to see if anyone has a suggestion? Thank you.&lt;/P&gt;</description>
      <pubDate>Thu, 12 Sep 2024 23:11:08 GMT</pubDate>
      <guid>https://community.cloudera.com/t5/Support-Questions/Nifi-PutCassandraRecord-How-to-use-conditional-updates-for/m-p/393434#M248454</guid>
      <dc:creator>mr_jahurley</dc:creator>
      <dc:date>2024-09-12T23:11:08Z</dc:date>
    </item>
  </channel>
</rss>

