Hi @dennisli ,   I hope You are doing well.   Please confirm one time in below fields value what i commented:- <property> <name>javax.jdo.option.ConnectionDriverName</name> <value>com.mysql.jdbc.Driver</value> //this is metadata db </property> <property> <name>javax.jdo.option.ConnectionUserName</name> <value>hive</value> //this is metadata db username </property> <property> <name>javax.jdo.option.ConnectionPassword</name> <value>mypassword</value> //this is metadatapassword </property> Thanks HadoopHelp   ... View more

Hi @bgooley ,   I want only delete zero size directory i.e empty directory but condition is here ?   *current directory contains some directory data, but some of the directory contains zero size directory in same directory.    I hope You understood now?     here @Michalis has given idea that is matching with my requirements.     Thanks HadoopHelp      ... View more

Thanks @Michalis ,   Your Idea is correct but we need to add jars files as you added in previous ? hadoop jar /opt/cloudera/parcels/CDH-*/jars/search-mr-*-job.jar org.apache.solr.hadoop.HdfsFindTool   Is there any option to find empty directory using HDFS command Directly?     I appreciated with your idea.       Thanks HadoopHelp   ... View more

Dear All .   Below is my data format in pig output file but $1 column contains name :-       name                 dob      gender                 address (LACTE^MIRAM,19659802,F,4395 NOREY AVE^^ATTIC CITY^N9J^09901) (JSON^MAW,19820309,M,COUNTRY CLUB DR^^NORELD^NJ^99225)   but want like below:- firstname  lastname  dob     gender         address (LACTE,MIRAM,19659802,F,4395 NOREY AVE^^ATTIC CITY^N9J^09901) (JSON,MAW,19820309,M,COUNTRY CLUB DR^^NORELD^NJ^99225)         Thanks HadoopHelp ... View more

Thanks @bgooley .   but my situation is like below:- i have dir like:- /user/root/Data/hl71 /user/root/Data/hl72 /user/root/Data/hl73 /user/root/Data/hl74 /user/root/Data/hl75 /user/root/Data/hl76 /user/root/Data/hl77 /user/root/Data/hl78 /user/root/Data/hl79 .............................. .............................. but inside /user/root/Data/* multiple dir conatins zero size and as well data dir also.so as per your responce :- (hdfs dfs -rmdir /tmp/emptydir) this will remove all dir from  /user/root/Data/*     Note:-only want want delete zero size dir ,not want to delete data conatains dir.       so help with some other idea.       Thanks HadoopHelp ... View more

how to delete zero size directory from hdfs path.         thanks HadoopHelp ... View more

Dear All.   I have a table in hive but it taking more time due to huge data available in that table... so plz guide me which tools will help me to get data under a second/mili..second  tools like:- Drill or Presto?   plz help.......           Thanks HadoopHelp ... View more

Dear All. I have table in sql server that column contain random unique number there is no any primary key but we want to perform incremental append or lastmodified operation using sqoop so please help me. Note:-This is Critical Issue. ... View more

Dear All. I am facing the issue with Oozie while runing simple job with HUE GUI. getting below error Please help me!   error:-   "traceback": [ [ "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/core/handlers/base.py", 112, "get_response", "response = wrapped_callback(request, *callback_args, **callback_kwargs)" ], [ "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/build/env/lib/python2.7/site-packages/Django-1.6.10-py2.7.egg/django/db/transaction.py", 371, "inner", "return func(*args, **kwargs)" ], [ "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/apps/oozie/src/oozie/decorators.py", 113, "decorate", "return view_func(request, *args, **kwargs)" ], [ "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/apps/oozie/src/oozie/decorators.py", 75, "decorate", "return view_func(request, *args, **kwargs)" ], [ "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/apps/oozie/src/oozie/views/editor2.py", 373, "submit_workflow", "return _submit_workflow_helper(request, workflow, submit_action=reverse('oozie:editor_submit_workflow', kwargs={'doc_id': workflow.id}))" ], [ "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/apps/oozie/src/oozie/views/editor2.py", 428, "_submit_workflow_helper", "'is_oozie_mail_enabled': _is_oozie_mail_enabled(request.user)" ], [ "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/apps/oozie/src/oozie/views/editor2.py", 435, "_is_oozie_mail_enabled", "oozie_conf = api.get_configuration()" ], [ "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/desktop/libs/liboozie/src/liboozie/oozie_api.py", 319, "get_configuration", "resp = self._root.get('admin/configuration', params)" ], [ "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/desktop/core/src/desktop/lib/rest/resource.py", 100, "get", "return self.invoke(\"GET\", relpath, params, headers=headers, allow_redirects=True, clear_cookies=clear_cookies)" ], [ "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/desktop/core/src/desktop/lib/rest/resource.py", 80, "invoke", "clear_cookies=clear_cookies)" ], [ "/opt/cloudera/parcels/CDH-5.11.1-1.cdh5.11.1.p0.4/lib/hue/desktop/core/src/desktop/lib/rest/http_client.py", 196, "execute", "raise self._exc_class(ex)" ] ] }       Thanks HadoopHelp ... View more

Hi. i got solution for same. please map hostfile in local machine with cluster nodes.it will work without any issue.       Thanks HadoopHelp ... View more

Hi. I find the solution for same. just uninstall hive odbc driver and reinstall driver and then you try to connect with odbc and put the all cluster inforamation what you have.it will work.       Thanks HadoopHelp ... View more

Hey Guys . same issure facing plz help someone for same.       Thanks HadoopHelp ... View more