For clarification, I'm using Pojo and operating on a column of this type
public java.util.List<String> fruits
adding the following annotation does not help
@DataTypeHint("ARRAY<STRING NOT NULL>")
On Mon, Nov 2, 2020 at 7:02 AM Aljoscha Krettek <aljos...@apache.org> wrote:
> I believe this is happening because the type system does not recognize
> that list of Strings as anything special but treats it as a black-box type.
>
> @Timo: Would this work with the new type system?
>
> Best,
> Aljoscha
>
> On 02.11.20 06:47, Rex Fenley wrote:
> > Hello,
> >
> > I'm trying to filter the rows of a table by whether or not a value exists
> > in an array column of a table.
> > Simple example:
> > table.where("apple".in($"fruits"))
> >
> > In this example, each row has a "fruits" Array<String> column that could
> > have 1 or many fruit strings which may or may not be "apple".
> >
> > However, I keep receiving the following error when I do something similar
> > to the example above:
> > "IN operator on incompatible types: String and
> GenericType<java.util.List>"
> >
> > Is there any way to accomplish this?
> >
> > Thanks!
> >
>
>
--
Rex Fenley | Software Engineer - Mobile and Backend
Remind.com <https://www.remind.com/> | BLOG <http://blog.remind.com/>
| FOLLOW
US <https://twitter.com/remindhq> | LIKE US
<https://www.facebook.com/remindhq>
