Sorry Jacques, one last question for now - whats the best way for me to get setup for (1)? Is calcite forked within the drill repo or do I need to pull both projects locally and statically deploy jars from my fork of calcite to test in drill? Or can I test calcite in isolation?
Cheers. On 7 November 2015 at 16:46, Kieran Benton <[email protected]> wrote: > Ok so after a bit of faffing I've made some progress! > > I had a later version of the storage driver than you had in your pom.xml > but that turned out to not matter. The problem was to do with how I was > accessing the schema. It seems like for postgres at least I need to go > through <storage name>.public to get to my tables - which is a bit odd > (since thats not what you'd do directly) but at least it works. > > Now I have a couple of additional issues: > > 1. Uuid columns in postgres arent supported - I'll look to contribute code > to add support for this if its within my ability. > > 2. I've added views to convert the uuid columns to postgres 'text' data > types - but those aren't usable within JOINs in Drill. Is that something > you plan on fixing? I can cast to VARCHAR(?) but its a bit annoying and I > bet thats not very good for performance? > > 3. I'm having trouble following the instructions on > https://drill.apache.org/docs/using-the-jdbc-driver/ to get the JDBC > client up and running. I think the instructions might be out of date? It > references having your client use the driver from inside /jars > named drill-jdbc-all-<version>.jar but that no longer exists? Theres > just drill-jdbc-<version>.jar and drill-jdbc-storage-<version>.jar. Trying > either of those fails in my client (0xDBE) with: > > [image: Inline images 1] > > Difficult to debug that any further - have you seen that behaviour? > > Cheers, > Kieran > > > > On 7 November 2015 at 01:22, Jacques Nadeau <[email protected]> wrote: > >> I'm not sure what the problem is. I was able to query successfully on my >> local machine using the same pattern. >> >> Here is my configuration so you can see if there is something different. >> >> >> https://github.com/jacques-n/drill/commit/8bd3289b0f5abbcabf33820297e7701d1da76ca0 >> >> Do you see anything different between my Postgres configuration (see the >> bootstrap-storage-plugins.json) or maybe the version of the Postgres >> driver >> (see pom.xml). My test is running against an Amazon RDS Postgres Instance >> (postgres 9.4) >> > >
