Alex Pelagenko
Alex Pelagenko
You are right, queries should not fail, thanks for clarifying. As with any database direct file system manipulation is discouraged that's why I do not see this issue as a...
You can do ```SQL SELECT symbol, price, cast(timestamp AS long) / 1000L FROM trades; ``` to get millisecond from epoch
#### [PR Coverage check] :heart_eyes: **pass** : 20 / 23 (86.96%) #### file detail | |path|covered line|new line|coverage| |----|----|----|----|----| |:large_blue_circle:|io/questdb/griffin/SqlParser.java|8|10|80.00%| |:large_blue_circle:|io/questdb/griffin/model/CreateTableModel.java|8|9|88.89%| |:large_blue_circle:|io/questdb/griffin/SqlCompilerImpl.java|4|4|100.00%|
#### [PR Coverage check] :heart_eyes: **pass** : 4 / 6 (66.67%) #### file detail | |path|covered line|new line|coverage| |----|----|----|----|----| |:large_blue_circle:|io/questdb/Bootstrap.java|4|6|66.67%|
#### [PR Coverage check] :heart_eyes: **pass** : 105 / 105 (100.00%) #### file detail | |path|covered line|new line|coverage| |----|----|----|----|----| |:large_blue_circle:|io/questdb/griffin/engine/functions/groupby/CountDistinctUuidGroupByFunction.java|1|1|100.00%| |:large_blue_circle:|io/questdb/griffin/engine/groupby/SampleByInterpolateRecordCursorFactory.java|1|1|100.00%| |:large_blue_circle:|io/questdb/cairo/map/Unordered8Map.java|4|4|100.00%| |:large_blue_circle:|io/questdb/griffin/engine/table/AsyncGroupByNotKeyedRecordCursor.java|1|1|100.00%| |:large_blue_circle:|io/questdb/std/AllocatorArena.java|63|63|100.00%| |:large_blue_circle:|io/questdb/griffin/engine/groupby/GroupByRecordCursorFactory.java|1|1|100.00%| |:large_blue_circle:|io/questdb/std/AllocatorFactory.java|6|6|100.00%| |:large_blue_circle:|io/questdb/std/AllocatorImpl.java|23|23|100.00%| |:large_blue_circle:|io/questdb/griffin/engine/table/AsyncGroupByRecordCursor.java|1|1|100.00%| |:large_blue_circle:|io/questdb/griffin/engine/groupby/AbstractNoRecordSampleByCursor.java|1|1|100.00%| |:large_blue_circle:|io/questdb/griffin/engine/functions/groupby/CountDistinctLong256GroupByFunction.java|1|1|100.00%|...
#### [PR Coverage check] :heart_eyes: **pass** : 668 / 724 (92.27%) #### file detail | |path|covered line|new line|coverage| |----|----|----|----|----| |:large_blue_circle:|io/questdb/cairo/wal/DefaultWalListener.java|0|1|00.00%| |:large_blue_circle:|io/questdb/cairo/wal/WalUtils.java|9|19|47.37%| |:large_blue_circle:|io/questdb/cairo/wal/seq/TableTransactionLogV2.java|234|256|91.41%| |:large_blue_circle:|io/questdb/cairo/wal/seq/TableTransactionLog.java|76|83|91.57%| |:large_blue_circle:|io/questdb/cairo/wal/seq/TableTransactionLogV1.java|136|149|91.28%| |:large_blue_circle:|io/questdb/griffin/engine/functions/catalogue/WalTransactionsFunctionFactory.java|39|41|95.12%| |:large_blue_circle:|io/questdb/cairo/wal/WalPurgeJob.java|79|80|98.75%| |:large_blue_circle:|io/questdb/std/str/Path.java|9|9|100.00%| |:large_blue_circle:|io/questdb/cairo/wal/WalTxnDetails.java|54|54|100.00%| |:large_blue_circle:|io/questdb/PropServerConfiguration.java|2|2|100.00%| |:large_blue_circle:|io/questdb/cairo/wal/WalWriter.java|1|1|100.00%|...
#### [PR Coverage check] :heart_eyes: **pass** : 4151 / 5257 (78.96%) #### file detail | |path|covered line|new line|coverage| |----|----|----|----|----| |:large_blue_circle:|io/questdb/griffin/engine/functions/cast/CastGeoHashToGeoHashFunctionFactory.java|0|82|00.00%| |:large_blue_circle:|io/questdb/cutlass/http/client/ser/JsonToTableSerializer.java|0|5|00.00%| |:large_blue_circle:|io/questdb/griffin/engine/functions/regex/MatchCharFunctionFactory.java|0|1|00.00%| |:large_blue_circle:|io/questdb/cairo/vm/api/MemoryA.java|0|3|00.00%| |:large_blue_circle:|io/questdb/griffin/engine/functions/bind/Long256BindVariable.java|0|1|00.00%| |:large_blue_circle:|io/questdb/cairo/vm/api/MemoryR.java|0|2|00.00%| |:large_blue_circle:|io/questdb/griffin/engine/functions/catalogue/FunctionListFunctionFactory.java|0|2|00.00%| |:large_blue_circle:|io/questdb/griffin/engine/functions/UntypedFunction.java|0|3|00.00%| |:large_blue_circle:|io/questdb/griffin/engine/functions/regex/NotMatchCharFunctionFactory.java|0|1|00.00%| |:large_blue_circle:|io/questdb/griffin/JsonPlanSink.java|0|4|00.00%| |:large_blue_circle:|io/questdb/griffin/engine/functions/rnd/RndStrFunctionFactory.java|0|1|00.00%|...
#### [PR Coverage check] :heart_eyes: **pass** : 38 / 57 (66.67%) #### file detail | |path|covered line|new line|coverage| |----|----|----|----|----| |:large_blue_circle:|io/questdb/ReloadingPropServerConfiguration.java|34|53|64.15%| |:large_blue_circle:|io/questdb/PropBootstrapConfiguration.java|1|1|100.00%| |:large_blue_circle:|io/questdb/cairo/DefaultCairoConfiguration.java|3|3|100.00%|
Thanks for submitting the issue, very cool charts. What date and timezone is pictured? Is it one table or all tables?
> Is it a good idea to place this map into `TableSequencerAPI`, so that we don't have one more higher-level object? So far, yeah, this map can serve one more...