Broken group by function

11 views
Skip to first unread message

lee....@booking.com

unread,
Jan 14, 2019, 11:06:25 AM1/14/19
to Pinot Users
Hello!

   During our exploration of Pinot, we've noticed that if we pass a completely invalid group by function to a query, there is no obvious error that occurs:

SELECT distinctcounthll(column)
from table
group by FAKEFUNCTION(ts, '1:SECONDS:EPOCH', '1:HOURS:EPOCH', '4:HOURS')
top 100

The JSON returned doesn't seem to indicate that this operation isn't possible.  Is this expected?  Can we detect that an error occurred?  It looks like numDocsScanned is zero, is that good enough?

Thanks!

kishore g

unread,
Jan 14, 2019, 12:04:21 PM1/14/19
to lee....@booking.com, Pinot Users
We should be able to indicate that error back to the user easily. 



--
You received this message because you are subscribed to the Google Groups "Pinot Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pinot_users...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/pinot_users/8e79b1c2-a32c-4918-9eda-8532d83b5fee%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
Reply all
Reply to author
Forward
0 new messages