Hello Team,   First thing, are you able to connect to HS2 from any of the edge node? If that is connecting successfully, could you share the same to ensure we form the right connection string here.   Also, could you attach the trace logs here and HS2 logs parallelly at the same as well. ... View more

Hello @marccasajus    Yes, this has been documented internally as a BUG (OPSAPS-53043) and is currently not fixed.     Also, it looks you have already applied the changes which would address this. ... View more

Hello @Sample    If we don't have hadoop ecosystem, hive and impala would not exist in first place.   If you have hive on one side(basically hadoop ecosystem) and mysql on other end. Now if you want to import data into hive from mysql, you will have to make use of sqoop to perform the same and vice-versa.   Let me know if the above answers all your questions. ... View more

Hello @saamurai    Thanks for the confirmation.   Cheers! Was your question answered? Make sure to mark the answer as the accepted solution. If you find a reply useful, say thanks by clicking on the thumbs up button. ... View more

Hello @saamurai    We have separate drivers for Impala and hive and I am not sure why you intent on using hive driver for Impala.   We do connect to Impala from edge nodes via beeline which is jdbc but the sole purpose is to perform some tests whether connectivity works fine or not. We do not recommend to use beeline for Impala as we have impala-shell designed for the same.   Cloudera recommends to use specific drivers along with version compatibility for each components. ... View more

Hello @ryu    There is no such path as best path but obviously not /tmp location.   You can create some path under /user/external_tables and further create the tables here. Again it totally depends upon you how you are designing and your use case. ... View more

Hello @bb9900m    The use case in your scenario is make use of Load balancer. You can make user of external Load Balancer and balance the impala coordinators behind the Load balancer.   This way, you will have the Load balancer Ip exposed to the client(Virtual IP) which further will balance the load based upon the load balancing mechanism set.   Attaching the link and sample configuration for your reference.   https://docs.cloudera.com/runtime/7.2.6/impala-manage/topics/impala-load-balancer-configure.html   When it comes to SSL, make sure you have the LB hostname added as SAN names on all the impala certificates.   Let me know if you have issues in any of the points above. ... View more