this query success
`{
"query":" select material_id,sum(new_device) as
new_device,(100.0*sum(click))/sum(impressions) as
ctr,(100.0*sum(installs))/sum(click) as cr from ad_material where __time >
TIMESTAMP '2018-07-31 00:00:00' and __time < TIMESTAMP '2018-08-19 23:59:59'
and lang **in ('ar', 'de', 'en', 'es', 'fr', 'id', 'it', 'ja', 'ko', 'nl',
'pl','ar', 'de', 'en', 'es', 'fr', 'id', 'it', 'ja')** group by material_id"
}`
this query error
`
{
"query":" select material_id,sum(new_device) as
new_device,(100.0*sum(click))/sum(impressions) as
ctr,(100.0*sum(installs))/sum(click) as cr from ad_material where __time >
TIMESTAMP '2018-07-31 00:00:00' and __time < TIMESTAMP '2018-08-19 23:59:59'
and lang in ('ar', 'de', 'en', 'es', 'fr', 'id', 'it', 'ja', 'ko', 'nl',
'pl','ar', 'de', 'en', 'es', 'fr', 'id', 'it', 'ja', 'ko') group by
material_id"
}
`
error
`{
"error": "Unknown exception",
"errorMessage": "Cannot build plan for query: select
material_id,sum(new_device) as new_device,(100.0*sum(click))/sum(impressions)
as ctr,(100.0*sum(installs))/sum(click) as cr from ad_material where __time >
TIMESTAMP '2018-07-31 00:00:00' and __time < TIMESTAMP '2018-08-19 23:59:59'
and lang **in ('ar', 'de', 'en', 'es', 'fr', 'id', 'it', 'ja', 'ko', 'nl',
'pl','ar', 'de', 'en', 'es', 'fr', 'id', 'it', 'ja', 'ko')** group by
material_id",
"errorClass": "io.druid.java.util.common.ISE",
"host": null
}`
Pls help me.
[ Full content available at:
https://github.com/apache/incubator-druid/issues/6209 ]
This message was relayed via gitbox.apache.org for [email protected]
