drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rahul challapalli <challapallira...@gmail.com>
Subject Re: Error on sql query on mongodb
Date Fri, 08 Jul 2016 15:23:57 GMT
Chetan,

Can you post the sample query you are running? Drill inferred a particular
column type to be "NullableVarChar". However for a particular record it
encountered a float. So is there a schema change in any one of the columns?

- Rahul

On Fri, Jul 8, 2016 at 5:07 AM, Chetan Jayaram <chetanjayaram271@gmail.com>
wrote:

> Dear Drill Support,
>
> I recently installed Apache Drill on my laptop and tried connecting to an
> existing mongodb collection.
>
>
> i completed the steps listed out in
> https://drill.apache.org/docs/mongodb-plugin-for-apache-drill/
>
> everything worked well , in sense i can see the collections etc. but when i
> execute a SQL query on the collection i get the below error message:
>
> Query Failed: An Error
> Occurredorg.apache.drill.common.exceptions.UserRemoteException:
> SYSTEM ERROR: IllegalArgumentException: You tried to write a Float8 type
> when you are using a ValueWriter of type NullableVarCharWriterImpl.
> Fragment 0:0 [Error Id: 3069c00b-bc4d-40b5-aab3-b28aae9dce3b on
> BNGECO-L-99768.asia-pac.shell.com:31010]
>
>
>
> kindly help.
>
> regards
> Chetan
>

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