I just want to understand what is the expected behavior? 1) show tables works only using hive interpreter 2) %sql allow access directly to hive tables 3) %sql does not show tables when running "show tables"
Is that correct? this is what is happening on my configuration. BTW, When using %SQL to access a hive table is that runs spark behind the scene? should I expect different performance when using spark code directly on hdfs files ves spark SQL through hive tables? Eran On Mon, Jun 29, 2015 at 12:36 AM Vadla, Karthik <karthik.va...@intel.com> wrote: > Thank you Eran, I did help me. > > Now I’m able to see all databases. > > > > Regards > > Karthik > > > > *From:* IT CTO [mailto:goi....@gmail.com] > *Sent:* Saturday, June 27, 2015 11:22 PM > *To:* users@zeppelin.incubator.apache.org > *Subject:* Re: Not able to see hive metastore in Zeppelin > > > > Can you access these databases? e.g. use %hive to list the DB and then use > %sql to select from them? > > I have the same behavior > > Eran > > > > On Sun, Jun 28, 2015 at 8:21 AM Vadla, Karthik <karthik.va...@intel.com> > wrote: > > Hi All, > > > > Recently I have imported new databases into my hive meta store on cluster. > > When I use %sql interpreter with below commands. I’m not able to see newly > imported databases. > > > > Command used: > > > > *%sql* > > > > *show databases* > > > > It shows only default databases not the newly imported databases. But when > I use hive command from command line > > > > *$hive –e “show databases”* > > > > It shows all the newly imported databases too. > > > > > > Do anyone have clue on this, why I’m not able to see with zeppelin > > Appreciate your help. > > > > Thanks > > Karthik Vadla > >
