Member since
10-03-2017
7
Posts
1
Kudos Received
0
Solutions
02-28-2018
08:27 PM
Did you get success on this installation? I am trying to do the same.
... View more
02-28-2018
01:57 PM
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
02-28-2018
01:56 PM
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
02-26-2018
12:13 PM
1 Kudo
After Pivotal ended Hawq distribuition, Apache version is the indicated to install in HDP 2.6.4? Is there any install recomendation?
... View more
Labels:
- Labels:
-
Apache Ambari
10-04-2017
02:32 PM
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