Member since
09-15-2020
210
Posts
16
Kudos Received
6
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
715 | 02-22-2024 02:53 AM | |
359 | 02-21-2024 06:55 AM | |
759 | 02-20-2024 09:20 AM | |
412 | 02-15-2024 08:05 AM | |
1241 | 02-13-2024 11:19 AM |
04-03-2024
04:23 AM
1 Kudo
@s198 You may try and use NIFI, refer below article https://community.cloudera.com/t5/Support-Questions/How-to-copy-files-from-a-remote-linux-box-using-Nifi/m-p/145133
... View more
04-03-2024
03:11 AM
Hi @s198 You can use DistCp command to achieve the same. refer ---> https://hadoop.apache.org/docs/current/hadoop-distcp/DistCp.html
... View more
04-03-2024
02:08 AM
Hi @drgenious First, please test your script outside of Oozie. If it is working outside of Oozie, then it should work from Oozie as well. As for error "No module named impala.dbapi" it could be that there is some version dependency issue with impyla and its related libraries refer ---> https://github.com/cloudera/impyla/issues/227
... View more
04-03-2024
02:03 AM
Hi @yagoaparecidoti The mini dump created shows that role/process is failing due to memory error. You may need to analyse this dmp file to check why the role/process is failing.
... View more
03-28-2024
06:38 AM
Hi @felix_ We will recommend you to use HUE Query Processor which provide same functionality as that of DAS. However if you want to keep using DAS, below information may help you: The LDAP implementations tested by Cloudera are the ones in the below documentation (MS Active Directory, OpenLDAP, or OpenDJ) https://docs.cloudera.com/cdp-private-cloud-base/7.1.6/using-das/topics/das-user-authentication-ldap.html You may use below LDAP Search command to check if the configuration used are correct or not Example, Searching for a specific users (peter): ------------------------------------------------------------- ldapsearch -x -H ldap://sme-2012-ad.support.com:389 -D "test1@SUPPORT.COM" -w hadoop12345! -b "ou=users,OU=hortonworks,dc=support, dc=com" "(&(objectclass=user)(cn=peter))"
... View more
03-20-2024
08:10 AM
Hi @MrBeasr Please check the status of job via Oozie Database: # select count(*) from WF_JOBS where id like '%0043858-220322202819429-oozie-oozi-W%'; If require you may set the status of the job in Database itself: # update wf_jobs set status='FAILED' where id like '%0043858-220322202819429-oozie-oozi-W%';
... View more
02-29-2024
07:59 AM
Hi @mohammad_shamim You need to check DB logs and see if you are able to find any error. Else reach-out to your DB team, they should be best point of contact to help you with DB related problem
... View more
02-29-2024
07:53 AM
HI @kerbero can you provide us the full error trace. It could be due to some dependency issue when using spark2.x
... View more
02-29-2024
07:47 AM
Hi @JoshiRamesh In your query the Question Mark (?) symbol is this a value for deliveryconstructuid. Can you put it in double quotes and check if it works for you Example SELECT * FROM my_table WHERE array_contains(my_array_col, "value1") This query will return all rows from “my_table” where “my_array_col” contains “value1”
... View more
02-29-2024
07:38 AM
Hi @dave22 The table data is stored in a HDFS location, so you may consume information out of it # hdfs dfs -du -s -h /path/to/database/ --> From here you can pick the owner of the path, which should be the username --> sub folders/files are the tables within the database --> The modification date can be used as the last updated date --> size of the table can be picked using below command # hdfs dfs -du -s -h/path/to/database/ Let us know if this helps
... View more