@Rajkumar Singh:Anything? ... View more

@Sindhu: Got it. But, I do not want the data moved out of warehouse dir /target-dir.Is there a solution for that? or I need to do it separately without the hive import option to keep it in hdfs ?Also, the link suggests using hcatalog: http://grokbase.com/t/sqoop/user/143waxddrr/jira-commented-sqoop-1293-hive-import-causes-target-dir-and-warehouse-dir-to-not-be-respected-nor-delete-target-dir .Is it really a solution to the problem? ... View more

I believe it is because of the --hive-import argument? I could remove that but I have to use --hive-overwrite argument and I can't use it unless I use --hive-import. @Sindhu . So, how do I use --hive-overwrite while using warehouse-dir /target-dir? ... View more

Why would it ignore the argument? I tried it with target-dir as well and that did not work either @Sindhu ... View more

@Sindhu You are right. It shows table location as hdfs://FQDN:8020/user/hive/warehouse/magentodb.db/TABLENAME ... View more

so if I replace --warehouse-dir with --target-dir , it would permanently store files in target-dir location and then I can have my tables mapped to this location as external table? @Dileep Kumar Chiguruvada ... View more

Awesome.Thank you! ... View more

@slachterman Hi, Thank you for your response, How exactly do I use hive for data cleaning purpose?Could you please give an example? I have not really touched spark so far so do you think spark is the way to go only for introducing the data cleaning layer in the system? I have heard all the good stuff about spark but would like to know if this would be a stuitable use case for it? ... View more