Unfortunately this guide is out of date because the link for Hawk client package is still pointing to Pivotal site which package is End of Availability ("EoA"). https://network.pivotal.io/products/pivotal-hdb So what is the option? ... View more

Unfortunately this guide is out of date because the link for Hawk client package is still pointing to Pivotal site which package is End of Availability ("EoA"). https://network.pivotal.io/products/pivotal-hdb So what is the option? ... View more

Thanks Kumar, I will try this guide. ... View more

I solved the incremental import with dynamic partition in a daily log table. I created a partition by YEAR/MONTH/DAY: # hcat -e "create table history.monitor (idvalitemcol bigint, dataregister string) partitioned by (year string, month string, day string) stored as rcfile;" Load data: # sqoop import --hive-drop-import-delims -m 4 --driver com.ibm.db2.jcc.DB2Driver --connect jdbc:db2://xxxx --username xxxx --password xxxx --query "select idvaltemcol, dataregister, year(dataregister) as year,month(dataregister) as month,day(dataregister) as day from MNT.LOGMONITOR WHERE \$CONDITIONS AND DATAREGISTER = '2016-11-06'" --split-by DATAREGISTER --hcatalog-database historty --hcatalog-table monitor It only works for complete days (the small key of partition). ... View more