I need to distcp hdfs://nn1:port/foo/bar/2016/* and hdfs://nn1:port/foo/bar/2017/* into hdfs://nn2:port/foo/bar/2016/* and hdfs://nn2:port/foo/bar/2017/* in one go..How can we achieve that? If I use distcp hdfs://nn1:port/foo/bar/2016/ \ hdfs://nn1:port/foo/bar/2017 hdfs://nn2:port/foo/bar/ then underlying directoris i.e. 2016 and 2017 are not getting created. I need distcp to create these directories and copy data. ... View more

Geerally when we use --connect option in sqoop we use "jdbc:oracle:thin:@hostname:port/DB_SERVICE_NAME". But can we user DB_SID instead of DB_SERVICE_NAME in connect option? If yes what will be the syntax for that. ... View more

How to use oracle database tns string in Sqoop connect parameter? ... View more

We have a table with partitions as p_date/p_workflow/p_attempt, we have data in p_date as "2016-10-15" which we need to change to "2015-10-15". Query we used is "alter table "table_name" partition (p_date='2016-10-15' ,p_workflow_id='0000450-151026183415051-oozie-oozi-W', p_attempt=0) rename to partition (p_date='2015-10-25' ,p_workflow_id='0000450-151026183415051-oozie-oozi-W', p_attempt=0);" which is yielding error "FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.DDLTask. Unable to rename partition." Hive version is Hive 0.13.0.2.1.3.0-563 ... View more