drill-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jack Ingoldsby <jack.ingold...@gmail.com>
Subject ODBC querying issues- Can only see files in Drill Explorer, not with other client
Date Thu, 15 Jun 2017 22:42:47 GMT
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

Mime
  • Unnamed multipart/mixed (inline, None, 0 bytes)
View raw message