Support Questions
Find answers, ask questions, and share your expertise

Zeppelin %sql queries don't reflect updated hive table

Contributor

I created an external table in Hive that I can then query from Zeppelin using the %sql interpreter (believe this is using spark under the hood).

However if I drop and recreate the table, I made a mistake and the column definition was incorrect in the original table, querying in Hive shows table and data correctly, however the Zeppelin %sql command still shows the old table and data combination even if I logout/login to Zeppelin.

I am wondering if it is some sort of caching problem, I have tried running %sql refresh table <<tablename>> however this doesn't seem to have done anything.

Am using HDP 2.5 with default versions of Hive/Zeppelin.

Thanks in advance for your help.