InDataDenysbyDenys Golotiuk·Nov 29, 2022Using partitions in ClickhouseClickhouse supports table partitioning which can be useful in cases we deal with serial data and need to work only with a moving window of…A response icon2A response icon2
InDataDenysbyDenys Golotiuk·Nov 21, 2022Estimating duplicates and deduplicating data in ClickhouseClickhouse has a way to quickly estimate number of duplicates in a table as well as remove duplicates so only unique rows remain. Popular…A response icon3A response icon3
InDataDenysbyDenys Golotiuk·Nov 11, 2022How to use window functions in MysqlUsing windows in Mysql is a way to query data based on a set of rows instead of a single row. This helps in comparative analysis, when we…
InDataDenysbyDenys Golotiuk·Nov 4, 2022Big data exploratory data analysis with ClickhouseAny analysis starts with exploratory stage — when we try to understand the big picture of the data itself. We usually do things like…
InDataDenysbyDenys Golotiuk·Nov 2, 2022Data cleansing and preparation for analysis with Python and PandasAny data usually (always?) contain errors. In order to do accurate analysis and build efficient ML models, data needs to be cleansed prior…A response icon1A response icon1
InDataDenysbyDenys Golotiuk·Oct 31, 2022Optimizing star-schema queries with IN queries and denormalizationMost data environments usually have 2 main groups of data objects. First — event based objects, usually organized into timeseries tables…
InDataDenysbyDenys Golotiuk·Oct 28, 2022Using projections to speedup queries in ClickhouseClickhouse is efficient enough so most analytical queries will execute fast in many cases without extra optimization activities. But, if…A response icon2A response icon2
InDataDenysbyDenys Golotiuk·Oct 26, 2022Working with JSON in ClickhouseThere’s plenty of cases when we can’t define data structure in advance due to its dynamic nature. Data objects can have different set of…A response icon1A response icon1
InDataDenysbyDenys Golotiuk·Oct 19, 2022Solving systems of linear equations using matrices and PythonMatrices stay at the very basis of all math used for ML. Let’s understand why it is so and how matrices can be used to solve systems of…
InDataDenysbyDenys Golotiuk·Oct 17, 2022Using EXPLAIN in Mysql to analyze and improve query performanceMysql EXPLAIN statement lets us understand efficiency of our queries and grasp ideas on possible ways to optimize it. Just creating indexes…A response icon6A response icon6