@cnormile In case of a disaster if dr becomes primary what needs to be changed? Is there any document elaborating this? What happens if we schedule this for off peak and the primary fails in peak hours. will that data be lost? ... View more

@Nilesh Did it worked? ... View more

@Kaliyug Antagonist Good question. Try this is your sqoop argument: --map-column-java id=NVARCHAR,value=VARCHAR There is another option while creating hive tables from sqoop: --map-column-hive id=NVARCHAR,value=VARCHAR(n) **Choose your n. Thanks ... View more

@simran kaur Please do the following and let me know if it works: 1. Copy /usr/share/java/mysql-connector-java.jar to /user/oozie/share/lib/lib_{20160430195631}/sqoop 2. Restart all oozie components. 4. Change --export-dir to --warehouse-dir in the workflow 3. Check the permission on /user/hive/warehouse/sbl. If possible point it to /tmp for testing. Rerun the oozie workflow. Please let us know if this works. Thanks ... View more

@Kaliyug Antagonist You should use varchar as much as possible. Because 1. Silent truncate in string. 2. String by default maps to varchar (32762). For smaller columns this might lead to performance issue. Thanks ... View more

@piotr pruski Nice question. Would help a lot of people in the community. Thank you. ... View more

Hi, @mpandit You can check the following post: https://community.hortonworks.com/questions/28500/best-practices-for-securing-data-ingestion-through.html#answer-28579 It will provide you with more insights. Thanks ... View more