Hi Daniel, Can you try select * from ibios3.root.`./tracking/tracking.log`; instead of select * from ibios3.root.`tracking/tracking.log`;
Thanks, Divya On 20 October 2017 at 13:13, Daniel McQuillen <[email protected]> wrote: > Thanks for your help, Padma! > > Just tried the following, per your suggestion: > > select * from ibios3.root.`tracking/tracking.log`; > > Still getting an error (although as I mentioned before I can do a 'show > files;' ok so the credentials must be working): > > "org.apache.drill.common.exceptions.UserRemoteException: VALIDATION > ERROR: > From line 1, column 15 to line 1, column 20: Table > 'ibios3.root.tracking/tracking.log' not found SQL Query null [Error Id: > fbd59cf8-d6ec-4022-b682-9b51d33f8302 on > ip-10-0-0-24.us-west-1.compute.internal:31010] > > > I tried from both the embedded command line and the web interface. Do you > have any other suggestions? Thanks in advance. > > Best Regards, > > Daniel > > > > On Fri, Oct 20, 2017 at 12:25 PM, Padma Penumarthy <[email protected]> > wrote: > > > From your error log, it seems like you may be specifying the table > > incorrectly. > > Instead of 'ibios3.root.tracking/tracking.log’, can you try > > ibios3.root.`tracking/tracking.log` > > > > i.e. for example, select * from ibios3.root.`tracking/tracking.log` > > > > Thanks > > Padma > > > > > > > On Oct 18, 2017, at 7:15 PM, Daniel McQuillen < > > [email protected]> wrote: > > > > > > Hi, > > > > > > Attempting to use Apache Drill to parse Open edX tracking log files I > > have > > > stored on S3. > > > > > > I've successfully set up an S3 connection and I can see my different > > > directories in the target S3 bucket when I type `show files;` in > embedded > > > drill. Hooray! > > > > > > However, I can't seem to do a query. I keep getting a "not found" error > > > > > > SEVERE: org.apache.calcite.runtime.CalciteContextException: From line > 1, > > > column 15 to line 1, column 20: Table 'ibios3.root.tracking/ > > tracking.log' > > > not found > > > > > > The "tracking" subdirectory has a most recent `tracking.log` file as > well > > > as a bunch of gzipped older files, e.g. `tracking-log-20170518-1234. > gz` > > > ... could this be confusing Drill? I've tried querying an individual > file > > > (tracking.log) as well as the directory itself, but not luck. > > > > > > Thanks for any thoughts! > > > > > > > > > - Daniel > > > > >
