Java dsl does not seem to support `SELECT DISTINCT RAW` statements

Java SDK
1

Hi,

We’re currently moving some of our text based N1QL queries to the query builder for better flexibility.

One of those queries uses a SELECT DISTINCT RAW statement.

In the dsl I can see that both SELECT DISTINCT and SELECT RAW are supported but I can’t manage to find how to combine DISTINCT and RAW in one select statement.

Is it even currently possible with the dsl ?

Thanks

2

Hi @anton.36ve,

This is not possible out of the box with the current query builder. Created JCBC-1251 to track this.

Thanks.

1 Like
3

has select distinct raw been fixed? My application team is using this in a subselect:
SELECT RAW ARRAY_DISTINCT(ARRAY_AGG(t2.Computer))
Which seems a little convoluted.