@jzhang Thanks for the first answer, It makes sense to increase configured memory size from 512M to 4 GB, I would give a try and monitor the response time. Sorry for not being too clear on 2nd question, Well, I meant to ask, Should we need to take care of tuning jdbc-interpreter configuration if users are executing HIVE queries on Zeppelin notebook to make it fast? If not mistaken, Cluster is setup with Hive using hiveserver2 thrift. So, should we be upgrading this with spark thrift server in order to utilize the sparkContext configuration? ( Sorry for bothering you with such silly questions as I am new to this so keen to know about it.) ... View more

Thank you for the help @jzhang So, what I believe, Zeppelin is configured using yarn-client for spark interpreter, and spark home is set to /usr/hdp/current/spark directory in same host(master). spark interpreter is already in shared mode, although spark.executor.memory is set to 512MB(Default). So what do you think is the actual problem here? And what if users are executing HIVE queries using JDBC interpreter, does it make any difference or will be okay if sparkContext and executors are correctly set? zeppelin-1.pngzeppelin-2.pngzeppelin-3.png I am sharing zeppelin current configuration for reference. ... View more