Hi Ayushi,
I tried reproducing the same error with both sharded and un-sharded collection and in the different modes like drill-embedded, drill-localhost, As you said it is working fine with un-sharded collections but as soon as we shard and make the same query it breaks. In my case, It is throwing typecast exception. I also tried building binaries from source and executed the same set of operations. It gives the same error.
I’ve reported this issue to the Drill team and hopefully it will be resolved in the upcoming release.
Thanks!
Viraj