Hello, Maybe the Excel client needs some metadata, and the MongoDB plugin is getting the schema on read (as you read data from your query)
One solution, would be to create a view and use this view into your excel query, see https://drill.apache.org/docs/create-view/ Can you test and let us know? Regards Tug @tgrall On Tuesday, August 18, 2015, Sudip Mukherjee <[email protected]> wrote: > Hi Kristine, > Yes, I am also able to use the example queries. I wanted to see the > columns while trying from excel so that I could selectively choose some. > But it is showing *. > > Thanks, > Sudip > > -----Original Message----- > From: Kristine Hahn [mailto:[email protected] <javascript:;>] > Sent: 18 August 2015 PM 07:28 > To: [email protected] <javascript:;> > Subject: Re: [DRILL] Column display for mongodb > > I can use Drill to query a Mongo table and the column output is fine as > shown in > http://drill.apache.org/docs/mongodb-plugin-for-apache-drill/#example-queries > > Why do mention MS Query? Please try the steps in > http://drill.apache.org/docs/mongodb-plugin-for-apache-drill > < > http://drill.apache.org/docs/mongodb-plugin-for-apache-drill/#example-queries > > > > On Tuesday, August 18, 2015, Sudip Mukherjee <[email protected] > <javascript:;>> > wrote: > > > Hi, > > > > I was trying to use mongodb plugin with apache drill (1.1) using MSQuery. > > I could browse through the collection I have (the sample zipcode > > database) but I was not able get the columns displayed. What could I be > missing here? > > > > Could you please help to troubleshoot? > > > > > > > > > > > > > > > > Thanks, > > > > Sudip > > > > > > ***************************Legal Disclaimer*************************** > > "This communication may contain confidential and privileged material > > for the sole use of the intended recipient. Any unauthorized review, > > use or distribution by others is strictly prohibited. If you have > > received the message by mistake, please advise the sender by reply email > and delete the message. Thank you." > > ********************************************************************** > > > > > > -- > Kristine Hahn > Sr. Technical Writer > 415-497-8107 @krishahn skype:krishahn > > > > ***************************Legal Disclaimer*************************** > "This communication may contain confidential and privileged material for > the > sole use of the intended recipient. Any unauthorized review, use or > distribution > by others is strictly prohibited. If you have received the message by > mistake, > please advise the sender by reply email and delete the message. Thank you." > **********************************************************************
