tried it on quickstart and seems to work ```select playerID

Question

tried it on quickstart and seems to work ```select playerID league playerName sum hits from baseballStats group by playerID league playerName select league playerID playerName sum hits from baseballStats group by league playerID playerName```

kish · Answer

Saw this exception in server log when this query was executed ```2020 05 26 14 51 45 822 ERROR InstanceResponseBlock pqr 14 Caught exception while building data table java lang ClassCastException java lang Double cannot be cast to java lang String at org apache pinot core operator blocks IntermediateResultsBlock setDataTableColumn IntermediateResultsBlock java 290 ~ pinot all 0 4 0 SNAPSHOT jar with dependencies jar 0 4 0 SNAPSHOT 6f840db6c84c69d2ebf137f1407332b517ce9322 at org apache pinot core operator blocks IntermediateResultsBlock getResultDataTable IntermediateResultsBlock java 264 ~ pinot all 0 4 0 SNAPSHOT jar with dependencies jar 0 4 0 SNAPSHOT 6f840db6c84c69d2ebf137f1407332b517ce9322 at org apache pinot core operator blocks IntermediateResultsBlock getDataTable IntermediateResultsBlock java 229 ~ pinot all 0 4 0 SNAPSHOT jar with dependencies jar 0 4 0 SNAPSHOT 6f840db6c84c69d2ebf137f1407332b517ce9322 at org apache pinot core operator blocks InstanceResponseBlock lt init gt InstanceResponseBlock java 43 ~ pinot all 0 4 0 SNAPSHOT jar with dependencies jar 0 4 0 SNAPSHOT 6f840db6c84c69d2ebf137f1407332b517ce9322 at org apache pinot core operator InstanceResponseOperator getNextBlock InstanceResponseOperator java 37 ~ pinot all 0 4 0 SNAPSHOT jar with dependencies jar 0 4 0 SNAPSHOT 6f840db6c84c69d2ebf137f1407332b517ce9322 at org apache pinot core operator InstanceResponseOperator getNextBlock InstanceResponseOperator java 26 ~ pinot all 0 4 0 SNAPSHOT jar with dependencies jar 0 4 0 SNAPSHOT 6f840db6c84c69d2ebf137f1407332b517ce9322 at org apache pinot core operator BaseOperator nextBlock BaseOperator java 49 ~ pinot all 0 4 0 SNAPSHOT jar with dependencies jar 0 4 0 SNAPSHOT 6f840db6c84c69d2ebf137f1407332b517ce9322 at org apache pinot core plan GlobalPlanImplV0 execute GlobalPlanImplV0 java 48 ~ pinot all 0 4 0 SNAPSHOT jar with dependencies jar 0 4 0 SNAPSHOT 6f840db6c84c69d2ebf137f1407332b517ce9322 at org apache pinot core query executor ServerQueryExecutorV1Impl processQuery ServerQueryExecutorV1Impl java 220 ~ pinot all 0 4 0 SNAPSHOT jar with dependencies jar 0 4 0 SNAPSHOT 6f840db6c84c69d2ebf137f1407332b517ce9322 at org apache pinot core query scheduler QueryScheduler processQueryAndSerialize QueryScheduler java 152 ~ pinot all 0 4 0 SNAPSHOT jar with dependencies jar 0 4 0 SNAPSHOT 6f840db6c84c69d2ebf137f1407332b517ce9322 at org apache pinot core query scheduler QueryScheduler lambda$createQueryFutureTask$0 QueryScheduler java 136 ~ pinot all 0 4 0 SNAPSHOT jar with dependencies jar 0 4 0 SNAPSHOT 6f840db6c84c69d2ebf137f1407332b517ce9322 at java util concurrent FutureTask run FutureTask java 266 1 8 0 232 at java util concurrent Executors$RunnableAdapter call Executors java 511 1 8 0 232 at shaded com google common util concurrent TrustedListenableFutureTask$TrustedFutureInterruptibleTask runInterruptibly TrustedListenableFutureTask java 111 pinot all 0 4 0 SNAPSHOT jar with dependencies jar 0 4 0 SNAPSHOT 6f840db6c84c69d2ebf137f1407332b517ce9322 at shaded com google common util concurrent InterruptibleTask run InterruptibleTask java 58 pinot all 0 4 0 SNAPSHOT jar with dependencies jar 0 4 0 SNAPSHOT 6f840db6c84c69d2ebf137f1407332b517ce9322 at shaded com google common util concurrent TrustedListenableFutureTask run TrustedListenableFutureTask java 75 pinot all 0 4 0 SNAPSHOT jar with dependencies jar 0 4 0 SNAPSHOT 6f840db6c84c69d2ebf137f1407332b517ce9322 at java util concurrent ThreadPoolExecutor runWorker ThreadPoolExecutor java 1149 1 8 0 232 at java util concurrent ThreadPoolExecutor$Worker run ThreadPoolExecutor java 624 1 8 0 232 at java lang Thread run Thread java 748 1 8 0 232 ```