guanghwu opened a new issue, #15414:
URL: https://github.com/apache/druid/issues/15414

   Running a query like 
   ```
   select __time from my_table
   ```
   produces inconsistent results in native vs MSQ. 
   
   In native, the results have the `__time` as ISO strings like 
`2010-01-01T00:00:00.000Z`.
   
   In MSQ with a query context 
   ```
   {
     "useApproximateCountDistinct": false,
     "useApproximateTopN": false,
     "useNativeQueryExplain": true,
     "enableJoinFilterPushDown": true,
     "enableJoinFilterRewrite": true,
     "enableJoinFilterRewriteValueColumnFilters": false,
     "enableRewriteJoinToFilter": true,
     "joinFilterRewriteMaxSize": 10000,
     "durableShuffleStorage": true,
     "maxNumTasks": 8,
     "taskAssignment": "auto",
     "faultTolerance": true,
     "finalizeAggregations": true,
     "maxParseExceptions": 0,
     "selectDestination": "durableStorage",
     "executionMode": "ASYNC",
     "includeSegmentSource": "NONE",
     "rowsPerPage": 100000
   }
   ```
   the results are timestamps like `1262304000000`. It looks like the issue 
happens because of some property in the context above (not sure which one). 
Running an MSQ query without a context produces ISO strings like in native.


-- 
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.

To unsubscribe, e-mail: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to