Hello @roshanbi ,   thank you for the clarification. I am not aware of any automated way of doing the translation.  If I was facing with this task, I would dive into the differences between these SQL dialects and if Kudu needs some different design considerations when building up the queries and either to it manually or consider if it takes less effort to build custom automation, then build scripts for the job.   Kind regards: Ferenc ... View more

Hi @roshanbi , thank you for raising this question on the Cloudera Community!   Do I understand correctly that you are storing data in Kudu and you would like to re-use your Oracle functions and use Zeppelin as your notebook?   Please note, Kudu does not have an SQL Engine, hence it does not have JDBC driver available. First, you need to decide what SQL Engine will be used in combination with Kudu. Would it be for instance Impala, Spark, Nifi...?   Once you know what SQL Engine will be used with Kudu, your next question would be how easy is it to translate your Oracle functions into that specific SQL dialect.   Hope it helps! Kind regards: Ferenc ... View more

Hi @SujaP ,   this can happen e.g. when you run out of disk space.   1. Please make sure that the disk have enough space to keep unpacked parcels. 2. Hard stop cloudera-scm-agent service (supervisord) 3. Empty the parcel directories : /opt/cloudera/parcels & opt/cloudera/parcel-cache 4. Start the agent service (#systemctl start cloudera-scm-agent)   Kind regards: Ferenc ... View more

Hello @RajatL ,   please find the information on the currently available API calls in the "CDP API reference".   Hope it helps!   Kind regards: Ferenc ... View more

Hello @cardozogp ,   I am just wondering if you've seen the below documentation regarding the Sqoop - Oracle compatibility: https://support.oracle.com/knowledge/Oracle%20Database%20Products/1510470_1.html#aref_section24 Hope it helps you to move forward with your new requirement!   Kind regards: Ferenc ... View more

Hello @dirkj ,   the answer to your question is in the source code of the INSERT OVERWRITE in a form of comments under FinalizeHdfsInsert.   Please let us know if you need further clarification on it!   Best regards: Ferenc ... View more

您好，请看一看下面的解决办法[1]： "12. Error If npm is executed under the root account, it will change the uid to the current account, or the value of the uid is obtained from the user configuration file, and the default value of uid is nobody. So when you run npm install under the root account, you need to change unsafe-perm Option plus. Solve (and then re-edit): # find ~/.m2/repository/ -name "*.lastUpdated" -exec rm -rf {} \; # mvn -B clean install rpm:rpm -DnewVersion=2.7.3.0.0 -DskipTests -Dpython.ver="python >= 2.6" -Drat.skip=true -X -rf :ambari-admin"   [1] https://www.programmersought.com/article/72684156755/ ... View more

Hello @VadymDemchuk ,   thank you for the deep-analysis. If I understand correctly, the process fails at the hostId. Can you please check on your hosts whether your configuration complies with [1]. Please check the documentation from this section onwards: " Cluster hosts must not use aliases, either in  /etc/hosts  or in configuring DNS. A properly formatted  /etc/hosts  file should be similar to the following example:"   "Null value(s) passed to lookup by non-nullable natural id" is usually thrown because the hosts don't have any resolvable hostnames. All "hostname" values in the list of hosts should also contain the FQDN.   Please let me know if it helped you to alleviate the issue. Thank you: Ferenc   [1] https://docs.cloudera.com/cdp-private-cloud/latest/release-guide/topics/cdpdc-networking-security-requirements.html ... View more

Hello @Tak567 ,   thank you for letting us know you are hitting "Could not start EmbeddedOozieServer! Error message:  Address already in use" exception. It can occur, for example when there are not enough ephemeral ports available on the OS.   Kind regards: Ferenc ... View more

Hello @5sdba ,   thank you for reporting the issue you hit. Can you please specify the CDP version you are using and if you are using CM HA (Cloudera Manager High Availability), please?   Thank you: Ferenc ... View more

Hello @Devink ,   thank you for reaching out to the Community.   I understand that your issue is: Hive on Tez job that is failed because of OutOfMemory issue is reported as successful and you would like to know the reason for it.   Please note if you have a Cloudera Subscription, a Support Case might be a better forum for deep analysis.   Could you please give us some additional information, so we can assist you more efficiently? What is the distribution you are using and what is the version number, please? (e.g. HDP, CDH, CDP) Is the successful-state reported via Hue from an Oozie workflow? What Oozie action did you use to execute the Hive job, please? If it is not via Hue and Oozie, please specify where did you see the application reported as successful.   Please note, Oozie is at the mercy of the status reported back from the job it is running.  There are two ways that Oozie can detect a failure in e.g. a Java action. If an exception is thrown from the  main  method of the class executed by the Java action or  System.exit  is called anywhere in the code, Oozie will treat the action as failed. It will then transition to the Error state configured for the action.   Thank you: Ferenc   ... View more

Hello @Lilit ,   thank you for raising this question. I believe this post will answer your enquiry.   Please let us know if you still need any further information!   Thank you: Ferenc ... View more