@Aymen Rahal The issue is due to 'Connection refused on the default ssh port'. Verify the following: 1. Check the ssh port under file /etc/ssh/sshd_config, if not set try setting to 22. 2. Try running ssh to the host from terminal. ... View more

@Aymen Rahal Can you click on 'Failed' and share the error shown? ... View more

@SUDHIR KUMAR The issue seems to be Namenode not able to reach the Data nodes: "File /tmp/hadoop-yarn/staging/hadoop /.staging/job_1520083308767_0005/job.splitmetainfo could only be written to 0 of the 1 minReplic ation nodes. There are 3 datanode(s) running and 3 node(s) are excluded in this operation. " Check the Namenode's reachability to Data nodes using "hdfs dfsadmin -report" ... View more

@rama I guess the issue here is due to incorrect mapping between the substr return type and the value being compared. I verified similar scenario and below are the details: hive> desc flight_details; OK flightnum string tailnum string uniquecarrier string origin string dest string Time taken: 0.295 seconds, Fetched: 5 row(s) hive> select * from flight_details where substr(tailnum,2,3)>=500 limit 10; OK 1018 N828UA UA OAK ORD 1020 N567UA UA IAD BOS 1020 N561UA UA IAD BOS 1020 N554UA UA IAD BOS 1020 N535UA UA IAD BOS 1020 N571UA UA IAD BOS 1020 N530UA UA IAD BOS 1020 N553UA UA IAD BOS 1020 N525UA UA IAD BOS 1020 N585UA UA IAD BOS ... View more

@Ashnee Sharma Try below parameters and then run select count(*): set hive.compute.query.using.stats=true; set hive.stats.fetch.column.stats=true; set hive.stats.fetch.partition.stats=true; set hive.fetch.task.conversion=more ... View more

@Ashnee SharmaFor INTERNAL tables, Hive manages the lifecycle of the table and data. When a Hive table is created, a corresponding Phoenix table is also created. Once the Hive table is dropped, the Phoenix table is also deleted. For EXTERNAL tables, Hive works with an existing Phoenix table and manages only Hive metadata. Dropping an EXTERNAL table from Hive deletes only Hive metadata but does not delete the Phoenix table. Refer https://phoenix.apache.org/hive_storage_handler.html ... View more

@Ashnee Sharma Usually, it should be GA in next major release, but cannot confirm on that. ... View more

@Ashnee Sharma Hive Phoenix handler is not a supported feature in HDP 2.5.x versions. This feature is available as Tech Preview feature starting HDP 2.6.2. Below is the document with list of TP features in HDP 2.6.2: https://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.6.2/bk_release-notes/content/tech_previews.html ... View more