@saichand varanasi For next run, you need to modify last-value to last-value returned from first run. See https://sqoop.apache.org/docs/1.4.0-incubating/SqoopUserGuide.html#id1764421 section 7.2.7 on how to do incremental imports. You can use a sqoop job or Oozie that can automate this process. ... View more

@Sunella Zag It looks like alerts resource doesn't allow filtering of fields. Only fields=* seems to be working. Specifying any fields results in default fields. http://ambari_server:8080/api/v1/clusters/appslogs/alerts?Alert/state.in(WARNING,CRITICAL,UNKNOWN)&Alert/maintenance_state=OFF&fields=Alert/state,Alert/host,Alert/text For services resource, I was able to specify a list of fields and get only required fields in my response. http://ambari_server:8080/api/v1/clusters/hdp_dev/services/HDFS?fields=alerts_summary so this seems to be a problem only with alert resource. ... View more

SAP HANA driver doesn't accept Schema name in table parameter. Need to pass schemaname as part of connection parameter. sqoop import --connect "jdbc:sap://<server>:30015/?currentschema=ABC"--driver "com.sap.db.jdbc.Driver"--username admin --password ****--table TABLE1 -m 1 ... View more