Member since
09-02-2016
523
Posts
89
Kudos Received
42
Solutions
My Accepted Solutions
Title | Views | Posted |
---|---|---|
2035 | 08-28-2018 02:00 AM | |
1713 | 07-31-2018 06:55 AM | |
4512 | 07-26-2018 03:02 AM | |
1952 | 07-19-2018 02:30 AM | |
5188 | 05-21-2018 03:42 AM |
04-28-2017
07:59 AM
@Freakabhi If your business allows to replace Ctrl+M with something else then I would suggest two steps 1. Understand the regexp_replace function ex: regexp_replace(col2, '<the char that you want to replce>', '') 2. Use --query option instead of --table option in sqoop So you have to use the following method to replace Ctrl+M with something else in your sqoop script --query "select col1, regexp_replace(col2, '<the char that you want to replce>', '') from db.table"
... View more
04-28-2017
07:44 AM
@ShilpaSinha I am also kind of agree with @Fawze because there will be multiple options for the same issue I've suggested to add addition node in my 2nd update as the total capacity of your cluster is very less (not even 1 TB). So if it is affordable for you better add additional node, also consider the suggestion from @Fawze to compress the files As mentioned already you don't need to follow "either this or other option", you can try all the possible options to keep your environment better
... View more
04-27-2017
07:12 AM
1 Kudo
@ShilpaSinha It seems in your case, you have to 1. add additional disk/node 2. try rebalance after that 3. changing the threshold to a reasonable value. Because this threshold will help you to fix the issue before it breaks
... View more
04-24-2017
01:18 PM
1 Kudo
@ClouderaMQVM Might be... I am not sure about the suitable version for your environment If you are planning to get another version of mysql-connector then 1. Do not remove/delete the old version of mysql-connector 2. Downaload the new version of mysql-connector, Unzip/untar, move it to /usr/share/java 3. Delete only the link referring to the old version and Create a new link referring to the new version 4. Restart the hive service via CM For more details http://www.cloudera.com/documentation/enterprise/5-7-x/topics/cm_ig_mysql.html
... View more
04-24-2017
08:45 AM
1 Kudo
@jpayne1 If an user created a table and loaded data into it and another user drop the table then only table will be droped but underlined data will exists Ex: UseCase 1: 1. Login as User A and create a table tab1 and load data into it 2. Drop the table tab1. Now table will be droped and files from HDFS path will be removed UseCase 2: 1. Login as User A and create a table tab1 and load data into it 2. Logout from User A and login as User B 3. Drop the table tab1. Now table will be droped but files from HDFS path will remain exists
... View more
04-23-2017
08:50 PM
1 Kudo
@ClouderaMQVM Make sure you have mysql-connector-java.jar By default it is available under /usr/share/java
... View more
04-22-2017
11:09 AM
@ShilpaSinha You can try any one or two or all the options 1. CM -> HDFS -> Actions -> Rebalance 2. a. CM -> HDFS -> WebUI -> Namenode WebUI -> It will open a new page -> Datanodes menu -> Check the blocks count under each node b. CM -> HDFS -> Configuration -> DataNode Block Count Thresholds -> Increase the block count threshold and it should be greater than step a 3. Deleted files from HDFS will be moved to trash and it will be automatically deleted, so make sure auto delete is working fine if not Purge the trash directory. Also delete some unwanted files from hosts to save some disk space.
... View more
04-21-2017
07:28 AM
@onsbt As mentioned already, please create a new topic for new issue as it may mislead others Also please check the full answer and reply, so that you will get desired answer
... View more
04-21-2017
07:22 AM
1 Kudo
@helpdk Have you tried this? select col1, col2 from HumanResources.Employee
... View more
04-21-2017
07:14 AM
@onsbt The default path is /opt/hadoop/dfs/nn You can confirm this by Cloudera manager -> HDFS -> Configuration -> search for "dfs.namenode.name.dir"
... View more