Thank you @Sandeep Nemuri, it's helped me. i found an other explanation which details the probem : https://community.hortonworks.com/questions/178176/hive-creation-of-temp-tables-in-default-database-d.html " The problem seems to be around the default temporary table (at least, it is failing here before anything else). The query you make with the "VALUES" part work like this : - it creates a temporary hive table with the line to be inserted - it then queries that temporary table for inserting the data into the target table From the output I see, the temporary table is created [default/values__tmp__table__3]. But the user does not have "select" permission on it. I guess that a workaround would be to grant "SELECT" on the database "default" but this could bring some security issues for you (since the user will have read permission on all the tables inside "default"). " ... View more

@Sandeep Nemuri Thanks for your response! That did help me resolve the issue. Appreciate your help. Vinod ... View more

Hi, how are you? I even noticed that things do not work out like I imagined, lol! I found the documentation after your first tip, thanks for this. My problem now, is to map my IBM CloudStorage to my Hadoop, this is making me confused, but I'm evolving! ... View more

@Praveen Kumar if you think this answer is helpful, please take a moment to login and click the "accept" on the answer. ... View more

I found a working dirty solution, added the queues as follow: root.bt.bt_user1 root.bt.bt_user2 root.bt.bt_user3 root.opt.opt_user1 root.opt.opt_user2 root.opt.opt_user3 and updated the submission script to match it ... View more

Thank you @Sandeep Nemuri ... View more

@Sandeep Nemuri. Thank you very much. It helped a lot. ... View more

We see it is still not added. Also i am looking for steps to setup Superset as service on HDP 2.6.5 could someone help me with documentation as i am not able to locate in the HDP Documentation? ... View more