Hi, Sorry to bump this, but I just asked by one of my sales guys if I could get this working for a customer meeting in a couple of hours where an inability to query S3 via Apache Drill ODBC or JDBC is a dealbreaker.
If anyone has any thoughts would be greatly appreciated. Possibly an Amazon token might find its way to you... Regards, Jack On Thu, Jun 15, 2017 at 6:42 PM, Jack Ingoldsby <jack.ingold...@gmail.com> wrote: > Hi, > > I'm using Windows embedded to connect to S3, but am having querying using > ODBC > > The ODBC connection works (connection string below) > CastAnyToVarchar=true;Catalog=s3citibike;Schema=default; > HandshakeTimeout=5;QueryTimeout=180;TimestampTZDisplayTimezone= > local;NumberOfPrefetchBuffers=5;StringColumnLength=1024; > ConvertToCast=false > > Using Drill Explorer (direct to Drillbit), I can see the files in > s3citibike.default, and view the data (see attached image) but for some > reason I cannot see my files when using ODBC with another client such as > Excel. > > > > I can query using sqline, for example the bellow returns the dataset > > SELECT * FROM `s3citibike`.`default`.`./201307-citibike-tripdata.csv` > LIMIT 100; > > I'm kind of guessing I'm just not specifying the folder path correctly, > but I've been looking around for a while, tried Catalog = DRILL, schema = > s3citibike.default, no avail. > > > I'd try the drill-jdbc-all-1.10.0.jar JDBC driver for my client, but > understand it doesn't work with embedded Windows > > Can anyone see where I'm going wrong? > > Thanks and regards, > Jack > > >