About araujo

araujo · ‎03-21-2022

@BerniHacker , I noticed that your JDBC URL starts with "jdbc:postgres:". The correct is "jdbc:postgresql:". Could you please make this change and try again? Cheers, André -- Was your question answered? Please take some time to click on "Accept as Solution" below this post. If you find a reply useful, say thanks by clicking on the thumbs up button.

araujo · ‎03-21-2022

@pandu2022 , Where did you configure the customized service name for Impala? Did you configure this since Impala was installed or was it initially using the default name and you later changed it? Cheers, André

araujo · ‎03-21-2022

@AguniCat , Please try restarting the agent with the command below and then try again. systemctl restart cloudera-scm-agent If it fails again, please share the agent log here (using pastebin): /var/log/cloudera-scm-agent/cloudera-scm-agent.log Cheers, André -- Was your question answered? Please take some time to click on "Accept as Solution" below this post. If you find a reply useful, say thanks by clicking on the thumbs up button.

araujo · ‎03-17-2022

Hi @AguniCat , Could you please provide the full stdout and stderr outputs? André

araujo · ‎03-17-2022

Hi @Tra , When you start NiFi in cluster mode (no-standalone), besides configuring ZooKeeper properties in nifi.properties you also need to configure it for State Management in the conf/state-management.xml file. Make sure your zk-provider in that file looks like the example below: <cluster-provider> <id>zk-provider</id> <class>org.apache.nifi.controller.state.providers.zookeeper.ZooKeeperStateProvider</class> <property name="Connect String">nifi-inf-02:2181,nifi-inf-03:2181</property> <property name="Root Node">/nifi</property> <property name="Session Timeout">10 seconds</property> <property name="Access Control">Open</property> </cluster-provider> Cheers, André -- Was your question answered? Please take some time to click on "Accept as Solution" below this post. If you find a reply useful, say thanks by clicking on the thumbs up button.

araujo · ‎03-17-2022

@Ankit88 , For a Java application you need to add the following Kafka property to your producer/consumer configuration: sasl.jaas.config=com.sun.security.auth.module.Krb5LoginModule required useKeyTab=true keyTab="./myuser.keytab" principal="myuser@XYZ.SITE"; Where myuser.keytab is your user's Kerberos keytab. Cheers, André

araujo · ‎03-15-2022

@Nikky , Could you please explain what you need in more details? Could you give us an example? Cheers, André

araujo · ‎03-15-2022

Hi, @abvincita , Please ignore my last post. I did a quick test using dynamic properties arguments and confirmed that it works well, regardless of the content of the attributes. Please give this a try: André -- Was your question answered? Please take some time to click on "Accept as Solution" below this post. If you find a reply useful, say thanks by clicking on the thumbs up button.

araujo · ‎03-15-2022

@abvincita , Yes, if ERROR_DETAIL has double-quotes in it, it will have adverse effects. Does it have single-quotes too? If not, you can try using: '${ERROR_DETAIL}'~'${ERROR_CODE}' Cheers, André -- Was your question answered? Please take some time to click on "Accept as Solution" below this post. If you find a reply useful, say thanks by clicking on the thumbs up button.

araujo · ‎03-15-2022

@JohnnyC , No worries. For the very latest update of the latest product you do need subscription. But there's a trial available for a reasonably new version of CDP 7.1.7: https://www.cloudera.com/downloads/cdp-private-cloud-trial.html Regards, André -- Was your question answered? Please take some time to click on "Accept as Solution" below this post. If you find a reply useful, say thanks by clicking on the thumbs up button.

Online	Offline
Last Visited	‎07-21-2025 10:25 PM

Member Since	‎06-26-2015 11:59 AM
Last Visited	‎07-21-2025 10:25 PM
Posts	515
Kudos received	138

Cloudera Community

Re: Is it possible to use Single User authenticati...

Re: Dynamically Assign an XSD File

Re: "error": "There is no mapped role for the grou...

Re: Read xml file content into an Attribute: How t...

Re: Nifi Lookup CSV values with SQL NULL values

Re: Error when trying to connect to Timescale Clou...

Re: Kerberos Authentication Failure : Catalog Serv...

Re: Increase cloudera CommandPusherThread executio...

Re: Increase cloudera CommandPusherThread executio...

Re: NIFI Cluster Configuration Error

Re: Connecting to on-prem kafka cluster from cloud...

Re: Apache NiFi: How can database query processor ...

Re: Nifi treating newline as argument delimiter de...

Re: Nifi treating newline as argument delimiter de...

Re: What are the latest Hive JDBC drivers for CDP ...