related question is it possible to call `IN ID SET` inside ` Apache Pinot #troubleshooting

related question: is it possible to call `IN_ID_SE...

xtrntr

01/06/2022, 12:04 PM

related question: is it possible to call

IN_ID_SET

inside

IN_SUBQUERY

? i’ve tried, but i seem to keep running into sql quoting issues:

Copy code

Was expecting one of:\n    \")\" ...\n    \",\" ...\n    <QUOTED_STRING> ...","errorCode":150

Mark Needham

01/06/2022, 12:51 PM

Can you share the query?

xtrntr

01/06/2022, 12:57 PM

Copy code

SELECT userid FROM table WHERE IN_SUBQUERY(cell_id, 'SELECT ID_SET(id) FROM dimTable WHERE IN_ID_SET(location, \'...\') = 1') = 1

Mark Needham

01/06/2022, 1:47 PM

you can escape single quotes with single quotes rather than backslahes

Mark Needham

01/06/2022, 1:48 PM

so do a double

''

instead of a

\'

xtrntr

01/06/2022, 10:59 PM

it works, thanks!