[GitHub] [incubator-pinot] HyunjoonCho opened a new issue #6307: Getting list of non singleFieldValue field using select / group by

[GitBox]

HyunjoonCho opened a new issue #6307:
URL: https://github.com/apache/incubator-pinot/issues/6307


   Hello, 
   I am trying to find which values are stored for a specific field.
   Works okay with singleField ones, but does not with multiples. 
   
   With below schema
   ```json
   {
     "schemaName": "metric",
     "dimensionFieldSpecs": [
       {
         "name": "name",
         "dataType": "STRING"
       },
       {
         "name": "tags",
         "dataType": "STRING",
         "singleValueField": false,
         "defaultNullValue": "null"
       }
     ],
     "metricFieldSpecs": [
       {
         "name": "value",
         "dataType": "LONG",
         "defaultNullValue": -1
       }
     ],
     "dateTimeFieldSpecs": [
       {
         "name": "timestampInEpoch",
         "dataType": "LONG",
         "format" : "1:MILLISECONDS:EPOCH",
         "granularity": "1:MILLISECONDS"
       }
     ]
   }
   ```
   
   ```
   select name from metric group by name
   ```
   gives me list of name field in the table
   
   However, 
   ```
   select tags from metric group by tags
   ```
   returns errorCode 200
   ```json 
   [
     {
       "errorCode": 200,
       "message": "QueryExecutionError:\njava.lang.RuntimeException: Caught 
exception while building data table.\n\tat
   
org.apache.pinot.core.operator.blocks.InstanceResponseBlock.<init>(InstanceResponseBlock.java:46)\n\tat
   
org.apache.pinot.core.operator.InstanceResponseOperator.getNextBlock(InstanceResponseOperator.java:37)\n\tat
 
   
org.apache.pinot.core.operator.InstanceResponseOperator.getNextBlock(InstanceResponseOperator.java:26)\n\tat
 
   
org.apache.pinot.core.operator.BaseOperator.nextBlock(BaseOperator.java:49)\n\tat
 
   
org.apache.pinot.core.plan.GlobalPlanImplV0.execute(GlobalPlanImplV0.java:48)\n\tat
 
   
org.apache.pinot.core.query.executor.ServerQueryExecutorV1Impl.processQuery(ServerQueryExecutorV1Impl.java:294)\n\tat
 
   
org.apache.pinot.core.query.executor.ServerQueryExecutorV1Impl.processQuery(ServerQueryExecutorV1Impl.java:215)\n\tat
 
   
org.apache.pinot.core.query.executor.QueryExecutor.processQuery(QueryExecutor.java:60)\n\tat
 
   
org.apache.pinot.core.query.scheduler.QueryScheduler.processQueryAndSerialize(QueryScheduler.java:155)\n\tat
 
   
org.apache.pinot.core.query.scheduler.QueryScheduler.lambda$createQueryFutureTask$0(QueryScheduler.java:139)\n\tat
 
   java.util.concurrent.FutureTask.run(FutureTask.java:266)\n\tat 
   
java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)\n\tat 
   
shaded.com.google.common.util.concurrent.TrustedListenableFutureTask$TrustedFutureInterruptibleTask.runInterruptibly(TrustedListenableFutureTask.java:111)\n\tat
 
   
shaded.com.google.common.util.concurrent.InterruptibleTask.run(InterruptibleTask.java:58)"
     }
   ]
   ```
   
   ```
   select COUNT(tags) from metric group by tags
   ```
   gives out count of individual tag - I guess
   
   Is there any workaround for this?
   Thank you 


----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org
For additional commands, e-mail: commits-h...@pinot.apache.org