Hi Erik,
Could you please provide full stacktrace from the logs?
Kind regards,
Arina
> On Oct 16, 2019, at 11:00 PM, Erik Anderson <eand...@pobox.com> wrote:
>
> Short version:
>
> SELECT * FROM `INFORMATION_SCHEMA`.`TABLES`;
>
> org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
> IllegalArgumentException: Multiple entries with same key: vessel=JdbcTable
> {vessel} and vessel=JdbcTable {vessel}
>
> Long Version:
>
> 1) Setup a JDBC driver in Drill to Postgres
> 2) Create a public foreign table like below in postgres
>
> public | vessel | foreign table | postgres
> public | vessel_movement | foreign table | postgres
> public | vessel_movement_hist | foreign table | postgres
>
> 3) On windows install the MapR ODBC driver
> https://drill.apache.org/docs/installing-the-driver-on-windows/
>
> 4) Setup an ODBC connection with the MapR
> 5) Now in the ODBC connections, use the "Drill Explorer"
>
> The Drill explorer tries to run the query
> SELECT * FROM `INFORMATION_SCHEMA`.`TABLES`;
>
> This fails with the error
>
> org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR:
> IllegalArgumentException: Multiple entries with same key: vessel=JdbcTable
> {vessel} and vessel=JdbcTable {vessel}
>
> This is the same problem a was also reported here.
> https://stackoverflow.com/questions/47149236/unable-to-query-postgresql-with-apache-drill-1-11-validation-error
>
> This looks like BUG in Drill, not a "use foo.schema" workaround as listed
> above.
>
> We have tried various ?currentSchema=foo in the postgres driver. Nothing
> seems to get rid of the problem. Its Drill+ForeignTable specific.
>
> Has anyone else ran into this?
>
> Erik Anderson
> Bloomberg
