Hi, Thanks for replying, I have been trying to see the hive tables from drill using show tables command but not getting any output. Initially I was using derby metastore but now I have configured MySQL metastore. I have given select permission to cloudera user to hive tables still there is no result.
Can you send me the necessary properties which I should include in hive-site.xml for MySQL and derby metastore. Also can we have a Skype call to resolve this issue? This has to be resolved by 10th June 2018. Thanks, Samiksha Kapoor On Jun 4, 2018 11:49 PM, "rahul challapalli" <[email protected]> wrote: > Additionally to what padma said, it would be helpful if you can post the > query that you are trying to execute. Also as a sanity check can you list > the tables present in hive? Run the below commands > > use hive; > show tables; > > On Mon, Jun 4, 2018 at 8:05 AM, Padma Penumarthy <[email protected]> > wrote: > > > Did you verify the permissions ? Check the drillbit log. > > That will give some clues. > > > > Thanks > > Padma > > > > > > > On Jun 3, 2018, at 7:28 AM, Samiksha Kapoor < > [email protected]> > > wrote: > > > > > > Hi Team, > > > > > > I am doing a POC on Apache drill for my organization, I have installed > > > Drill on my Linux environment. However i am constantly facing one issue > > > even after doing so many configurations. When i am trying to view the > > hive > > > tables, its giving no output to me, the query is executing fine without > > any > > > results. > > > > > > Please help me out to fine the resolution so that i can do a successful > > POC > > > for my organization. > > > > > > Looking forward to hear from you. > > > > > > Thanks, > > > Samiksha Kapoor > > > > >
