Remote JDBC connection to Hive on EMR

1. SSH tunneling :

ssh -o ServerAliveInterval=10 -N -L 10000:localhost:10000 username@masternode


for automating this tunning
we can use autossh

2. use local url which will use above tunnel:

jdbc:hive2://localhost:10000/default