[GitHub] ly923976094 commented on issue #3469: Query problems with offline data and real-time data

[GitBox <gi...@apache.org>]

ly923976094 commented on issue #3469: Query problems with offline data and real-time data
URL: https://github.com/apache/incubator-pinot/issues/3469#issuecomment-438248442
 
 
   > 大家好：
   > 无法一起查询离线和实时数据，查看示例https://github.com/apache/incubator-pinot/wiki/How-To-Use-Pinot
   
   例如：select count(*) from test
   {
       "aggregationResults": [
       {
           "function": "count_star",
           "value": "14"
       }],
       "exceptions": [],
       "numServersQueried": 3,
       "numServersResponded": 3,
       "numDocsScanned": 14,
       "numEntriesScannedInFilter": 14,
       "numEntriesScannedPostFilter": 0,
       "totalDocs": 32,
       "numGroupsLimitReached": false,
       "timeUsedMs": 6,
       "segmentStatistics": [],
       "traceInfo": {}
   }
   
   select count(*) from test_OFFLINE
   {
       "aggregationResults": [
       {
           "function": "count_star",
           "value": "18"
       }],
       "exceptions": [],
       "numServersQueried": 2,
       "numServersResponded": 2,
       "numDocsScanned": 18,
       "numEntriesScannedInFilter": 0,
       "numEntriesScannedPostFilter": 0,
       "totalDocs": 18,
       "numGroupsLimitReached": false,
       "timeUsedMs": 29,
       "segmentStatistics": [],
       "traceInfo": {}
   }
   
   select count(*) from test_REALTIME
   {
       "aggregationResults": [
       {
           "function": "count_star",
           "value": "14"
       }],
       "exceptions": [],
       "numServersQueried": 1,
       "numServersResponded": 1,
       "numDocsScanned": 14,
       "numEntriesScannedInFilter": 0,
       "numEntriesScannedPostFilter": 0,
       "totalDocs": 14,
       "numGroupsLimitReached": false,
       "timeUsedMs": 5,
       "segmentStatistics": [],
       "traceInfo": {}
   }
   
   The result is that the offline data cannot be found directly by the table name of test

----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@pinot.apache.org
For additional commands, e-mail: dev-help@pinot.apache.org