@Gayathri Devi, Can you put the query in quotes and check . --query "select * hgj where date(starttime)=2017-08-08" For incremental, if you provide --last-value it will import only the new or updated data after that date. Read more here https://sqoop.apache.org/docs/1.4.1-incubating/SqoopUserGuide.html#_Incremental_Imports Thanks, Aditya ... View more

@Shravan Kumar, I see that you created tables using hbase shell and trying to access it using phoenix (sqlline.py). When you run using hbase shell, the tables wont be registered in SYSTEM.CATALOG table of phoenix which maintains the table metadata. So you wont be able to see the table in phoenix. If you want to access it via hbase, you can map the hbase table to phoenix . You can create a view in phoenix. To confirm this , you can run the below query /usr/hdp/current/phoenix-client/bin/sqlline.py zookeeper-test-1:2181/hbase-unsecure select distinct(TABLE_NAME) from SYSTEM.CATALOG; ---- > This will not return the table name. One more solution is to create the table via phoenix client . Then you can access it using phoenix and hbase shell. Thanks, Aditya ... View more

@Kevin Nguyen, Assuming the value of "yarn.scheduler.capacity.maximum-am-resource-percent" to be 0.2. Can you try increasing it to 0.3 or 0.4 and check if it works. Yarn -> Configs -> Advanced -> Scheduler -> Capacity Scheduler Thanks, Aditya ... View more

@Michael Bronson, May be Graphite service doesn't need any slaves or clients to be installed. So the stack recommendation will not give any alert and it will proceed to the next step. You can observe the similar behaviour while adding Zeppelin as well. Thanks, Aditya ... View more

@Jorge Florencio, Please check the value of "yarn.resourcemanager.zk-address" in Yarn configs (Yarn -> Config -> Advanced -> Fault tolerance) If it is set to localhost:2181 , then change it to <zk-host>:2181 and try restarting the components. Additionally perform forward and reverse DNS lookup of the hostname where RM is running. Also, for the AUTH_FAILED in zkCli.sh is due to the zookeeper address not being passed in the command. If -server option is not passed, it assumes that zookeeper is running on local which is not the case for you. You can try running ./zkCli.sh -server <zk-host>:2181 Thanks, Aditya ... View more

@Mudassar Hussain, Ambari does not manage /etc/hosts file. You should manually delete the entry from /etc/hosts file. If you want to see if the host is deleted or not , you can call Ambari REST api and check the response curl -k -u {username}:{password} -H "X-Requested-By:ambari" http://{ambari-host}:{ambari-port}/api/v1/hosts If the above call doesn't return the deleted host , then you can confirm that the host is deleted. Thanks, Aditya ... View more