Hi , Can you attach the screenshot of the sqoop command that you are running with an exception ?, It seems to be you are running it from MySql command line can you exit from there and run it through normal terminal session. ... View more

Hi, Not sure why it is not available, I have a tried to attach the  oozie-ext-2.2 file that i have downloaded before but am not able to attach the zip files here, any chance if you have a subscription to cloudera go ahead a request a oozie-ext-2.2 file. ... View more

Hi, Can you try with below command: select * from bucketing_table tablesample(bucket n out of y on clustered_criteria_column);   n => nth bucket y => total no. of buckets ... View more

Hi, Looks like there is no such command for it. ... View more

Hello, seems to be you cannot change the originally created files with an EC policy to regular files with replication factor. The only way to do that is to re-write the files with EC policy so that they will then get created with default replication factor of 3.   Please go through the below document for more details: https://hadoop.apache.org/docs/current/hadoop-project-dist/hadoop-hdfs/HDFSErasureCoding.html ... View more

Hi,   Under replicated blocks mean these are the blocks that haven't meet their target replication for the file they belong to. Can you use below script to fix this and see if this helps:   su - <$hdfs_user>   bash-4.1$ hdfs fsck / | grep 'Under replicated' | awk -F':' '{print $1}' >> /tmp/under_replicated_files   -bash-4.1$ for hdfsfile in `cat /tmp/under_replicated_files`; do echo "Fixing $hdfsfile :" ;  hadoop fs -setrep 3 $hdfsfile; done   Please check this below cloudera community article for the details: https://community.cloudera.com/t5/Community-Articles/Fix-Under-replicated-blocks-in-HDFS-manually/ta-p/244746     ... View more

Hi,   Can you just cat on the below path to get the version number: ""cat /etc/yum.repos.d/cloudera-manager.repo""   ... View more

Hi, It seems like your host from where you are running Sqoop command is not able to connect on the machine where your mysql is installed.   Kindly run the below command to check the connectivity. ## telnet <hostname> 3306   Note:- Hostname is the host where you have installed mysql database.   In the sqoop command i can see you have provided "localhost" double check it is the one where mysql database is installed.   Below is the command to get the full hostname of the host. ## hostname -f ... View more