DEV Community

Kanishga Subramani profile picture

Kanishga Subramani

404 bio not found

Joined Joined on  github website
Day 100 of #100DaysOfClickHouse: Optimizing Data Lake Queries with ClickHouse® 26.3 LTS
kanishga_subramani_49ad73 profile

Day 100 of #100DaysOfClickHouse: Optimizing Data Lake Queries with ClickHouse® 26.3 LTS

#clickhouse #devops #database #analytics
Comments
6 min read

Want to connect with Kanishga Subramani?

Create an account to connect with Kanishga Subramani. You can also sign in below to proceed if you already have an account.

Create Account
Already have an account? Sign in
Day 99 - Efficient Random Sampling with system.numbers_mt: Parallel Number Generation in ClickHouse® 26.3
kanishga_subramani_49ad73 profile

Day 99 - Efficient Random Sampling with system.numbers_mt: Parallel Number Generation in ClickHouse® 26.3

#clickhouse #devops #analytics #database
Comments
4 min read
Day 98 of #100DaysOfClickHouse: ClickHouse® 26.3 JOIN Optimization – A Practical Guide to JOIN Types
kanishga_subramani_49ad73 profile

Day 98 of #100DaysOfClickHouse: ClickHouse® 26.3 JOIN Optimization – A Practical Guide to JOIN Types

#clickhouse #devops #analytics #database
Comments
6 min read
Day 97 of #100DaysOfClickHouse: Analyzing Memory Efficiency with Vertical Merges in ClickHouse® 26.3
kanishga_subramani_49ad73 profile

Day 97 of #100DaysOfClickHouse: Analyzing Memory Efficiency with Vertical Merges in ClickHouse® 26.3

#clickhouse #devops #database #analytics
Comments
5 min read
Day 96/100 – Standard SQL Time Functions in ClickHouse® 26.3: Better ANSI SQL Compatibility
kanishga_subramani_49ad73 profile

Day 96/100 – Standard SQL Time Functions in ClickHouse® 26.3: Better ANSI SQL Compatibility

#clickhouse #devops #database #analytics
Comments
4 min read
Day 95/100 – ClickHouse® 26.3 S3 Object Storage Read Enhancements: Faster Data Lake Queries
kanishga_subramani_49ad73 profile

Day 95/100 – ClickHouse® 26.3 S3 Object Storage Read Enhancements: Faster Data Lake Queries

#clickhouse #devops #analytics #database
Comments
5 min read
Day 94/100 – Automated Insert Batching in ClickHouse® 26.3: Higher Throughput with Asynchronous Inserts
kanishga_subramani_49ad73 profile

Day 94/100 – Automated Insert Batching in ClickHouse® 26.3: Higher Throughput with Asynchronous Inserts

#clickhouse #analytics #database #devops
Comments
6 min read
Day 93/100 – New Unicode String Functions in ClickHouse® 26.3: Better Text Search and Normalization
kanishga_subramani_49ad73 profile

Day 93/100 – New Unicode String Functions in ClickHouse® 26.3: Better Text Search and Normalization

#clickhouse #devops #analytics #database
Comments
5 min read
Day 92 of #100DaysOfClickHouse - Read-Only Tables in ClickHouse® 26.3
kanishga_subramani_49ad73 profile

Day 92 of #100DaysOfClickHouse - Read-Only Tables in ClickHouse® 26.3

#clickhouse #devops #analytics #database
2
Comments
4 min read
Day 91 of #100DaysOfClickHouse - Partition Pruning in ClickHouse®
kanishga_subramani_49ad73 profile

Day 91 of #100DaysOfClickHouse - Partition Pruning in ClickHouse®

#clickhouse #devops #analytics #database
Comments
4 min read
Day 90 - Data Loss Warning: Why You Cannot Downgrade from ClickHouse® 26.3
kanishga_subramani_49ad73 profile

Day 90 - Data Loss Warning: Why You Cannot Downgrade from ClickHouse® 26.3

#clickhouse #devops #analytics #database
2
Comments
5 min read
Day 89 - Leveraging WebAssembly (WASM) UDFs in ClickHouse® 26.3
kanishga_subramani_49ad73 profile

Day 89 - Leveraging WebAssembly (WASM) UDFs in ClickHouse® 26.3

#clickhouse #analytics #database #devops
2
Comments
5 min read
Day 88 - Upgrading to ClickHouse® 26.3 LTS: A Step-by-Step Safe Guide
kanishga_subramani_49ad73 profile

Day 88 - Upgrading to ClickHouse® 26.3 LTS: A Step-by-Step Safe Guide

#clickhouse #devops #analytics #database
Comments
5 min read
Day 87 - Standard-Compliant NOT Operator in ClickHouse® 26.3: Breaking Changes Explained
kanishga_subramani_49ad73 profile

Day 87 - Standard-Compliant NOT Operator in ClickHouse® 26.3: Breaking Changes Explained

#clickhouse #analytics #database #devops
Comments
5 min read
Day 86: Faster Map Key Lookups in ClickHouse® 26.3 with Bucketed Map Serialization
kanishga_subramani_49ad73 profile

Day 86: Faster Map Key Lookups in ClickHouse® 26.3 with Bucketed Map Serialization

#clickhouse #devops #analytics #database
Comments
6 min read
Day 85: Using naturalSortKey() in ClickHouse® to Sort Version Strings, Filenames, and Numeric Text Naturally
kanishga_subramani_49ad73 profile

Day 85: Using naturalSortKey() in ClickHouse® to Sort Version Strings, Filenames, and Numeric Text Naturally

#clickhouse #devops #analytics #database
Comments
5 min read
Day 84: EXPLAIN `pretty=1` and `compact=1` in ClickHouse® 26.3
kanishga_subramani_49ad73 profile

Day 84: EXPLAIN `pretty=1` and `compact=1` in ClickHouse® 26.3

#clickhouse #devops #analytics #database
Comments
6 min read
Day 83 of #100DaysOfClickHouse - JSONExtractString() Now Supports Native JSON in ClickHouse® 26.3
kanishga_subramani_49ad73 profile

Day 83 of #100DaysOfClickHouse - JSONExtractString() Now Supports Native JSON in ClickHouse® 26.3

#clickhouse #devops #database #analytics
1
Comments
4 min read
Day 82: Handling Schema Evolutions in ClickHouse® Distributed Clusters
kanishga_subramani_49ad73 profile

Day 82: Handling Schema Evolutions in ClickHouse® Distributed Clusters

#clickhouse #devops #database #analytics
1
Comments 2
6 min read
Day 81: Custom Compaction Strategies in ClickHouse®: Optimizing Background Merges for Better Performance
kanishga_subramani_49ad73 profile

Day 81: Custom Compaction Strategies in ClickHouse®: Optimizing Background Merges for Better Performance

#clickhouse #devops #analytics #database
Comments
6 min read
Day 80 of #100DaysOfClickHouse: ClickHouse® 26.3 LTS - New Features, Performance Improvements & Upgrade Guide
kanishga_subramani_49ad73 profile

Day 80 of #100DaysOfClickHouse: ClickHouse® 26.3 LTS - New Features, Performance Improvements & Upgrade Guide

#clickhouse #devops #database #analytics
Comments
5 min read
Day 79 – Materialized CTEs in ClickHouse® 26.3
kanishga_subramani_49ad73 profile

Day 79 – Materialized CTEs in ClickHouse® 26.3

#clickhouse #devops #database #dataengineering
Comments
4 min read
Day 78 of #100DaysOfClickHouse: Designing Multi-Tenant Architectures with ClickHouse®
kanishga_subramani_49ad73 profile

Day 78 of #100DaysOfClickHouse: Designing Multi-Tenant Architectures with ClickHouse®

#clickhouse #devops #database #dataengineering
2
Comments 2
5 min read
Day 77 of #100DaysOfClickHouse: Resolving Replication Conflicts in ClickHouse®
kanishga_subramani_49ad73 profile

Day 77 of #100DaysOfClickHouse: Resolving Replication Conflicts in ClickHouse®

#clickhouse #devops #database #dataengineering
1
Comments 2
6 min read
Day 76/100 - Working with ClickHouse® LowCardinality and Enum Types
kanishga_subramani_49ad73 profile

Day 76/100 - Working with ClickHouse® LowCardinality and Enum Types

#clickhouse #devops #database #dataengineering
Comments
5 min read
Day 75/100 - Bypassing the Page Cache for ClickHouse® I/O Operations
kanishga_subramani_49ad73 profile

Day 75/100 - Bypassing the Page Cache for ClickHouse® I/O Operations

#clickhouse #devops #database #dataengineering
Comments
6 min read
Day 74/100 - Cross-Datacenter Replication in ClickHouse®
kanishga_subramani_49ad73 profile

Day 74/100 - Cross-Datacenter Replication in ClickHouse®

#clickhouse #devops #database #dataengineering
Comments
6 min read
Day 73/100 - Using ClickHouse® for Vector Search and AI Workloads
kanishga_subramani_49ad73 profile

Day 73/100 - Using ClickHouse® for Vector Search and AI Workloads

#clickhouse #devops #database #dataengineering
Comments
5 min read
Day 72 - ClickHouse® Internals: How the Query Analyzer Works
kanishga_subramani_49ad73 profile

Day 72 - ClickHouse® Internals: How the Query Analyzer Works

#devops #clickhouse #analytics #database
Comments
4 min read
Day 71 - Advanced Partitioning Strategies for Petabyte-Scale Tables
kanishga_subramani_49ad73 profile

Day 71 - Advanced Partitioning Strategies for Petabyte-Scale Tables

#clickhouse #devops #database #analytics
Comments
4 min read
Day 70- Extending ClickHouse® with C++ UDFs
kanishga_subramani_49ad73 profile

Day 70- Extending ClickHouse® with C++ UDFs

#clickhouse #devops #database #analytics
Comments
6 min read
Day 69 - Anatomy of a ClickHouse® Vertical Merge
kanishga_subramani_49ad73 profile

Day 69 - Anatomy of a ClickHouse® Vertical Merge

#clickhouse #database #analytics #devops
Comments
7 min read
Day 68 of #100DaysOfClickHouse: Benchmarking ClickHouse® – Tools and Methodologies for Reliable Performance Testing
kanishga_subramani_49ad73 profile

Day 68 of #100DaysOfClickHouse: Benchmarking ClickHouse® – Tools and Methodologies for Reliable Performance Testing

#clickhouse #devops #database #analytics
1
Comments
5 min read
Day 67 of #100DaysOfClickHouse: Securing ClickHouse® with SSL/TLS and LDAP Authentication
kanishga_subramani_49ad73 profile

Day 67 of #100DaysOfClickHouse: Securing ClickHouse® with SSL/TLS and LDAP Authentication

#clickhouse #devops #database #dataengineering
Comments
5 min read
Day 66/100 - ClickHouse Keeper vs ZooKeeper: Migration and Benchmarks
kanishga_subramani_49ad73 profile

Day 66/100 - ClickHouse Keeper vs ZooKeeper: Migration and Benchmarks

#clickhouse #devops #database #dataengineering
Comments
6 min read
Day 65/100 - Implementing Exact-Once Semantics with ClickHouse® and Kafka
kanishga_subramani_49ad73 profile

Day 65/100 - Implementing Exact-Once Semantics with ClickHouse® and Kafka

#clickhouse #devops #database #dataengineering
Comments
6 min read
Day 64: ClickHouse® Query Cache – Configuration, Best Practices, and Common Pitfalls
kanishga_subramani_49ad73 profile

Day 64: ClickHouse® Query Cache – Configuration, Best Practices, and Common Pitfalls

#clickhouse #devops #analytics #database
Comments
5 min read
Day 63: Advanced ClickHouse® Dictionaries – Integrating External Data Sources for Faster Lookups
kanishga_subramani_49ad73 profile

Day 63: Advanced ClickHouse® Dictionaries – Integrating External Data Sources for Faster Lookups

#clickhouse #devops #database #analytics
Comments
5 min read
Day 62: Writing Custom ClickHouse® User-Defined Functions (UDFs) for Cleaner, Reusable SQL
kanishga_subramani_49ad73 profile

Day 62: Writing Custom ClickHouse® User-Defined Functions (UDFs) for Cleaner, Reusable SQL

#clickhouse #devops #database #dataengineering
5
Comments
6 min read
Day 61: Tuning ClickHouse® for Low-Latency Queries
kanishga_subramani_49ad73 profile

Day 61: Tuning ClickHouse® for Low-Latency Queries

#clickhouse #devops #database #analytics
Comments
4 min read
Day 60: ClickHouse® Query Profiling – Finding Performance Bottlenecks
kanishga_subramani_49ad73 profile

Day 60: ClickHouse® Query Profiling – Finding Performance Bottlenecks

#clickhouse #devops #analytics #database
Comments
4 min read
Day 59: High Availability (HA) and Disaster Recovery (DR) in ClickHouse®
kanishga_subramani_49ad73 profile

Day 59: High Availability (HA) and Disaster Recovery (DR) in ClickHouse®

#clickhouse #analytics #database #devops
Comments
6 min read
Day 58 - Optimizing ClickHouse® for High-Throughput Inserts
kanishga_subramani_49ad73 profile

Day 58 - Optimizing ClickHouse® for High-Throughput Inserts

#clickhouse #devops #analytics #database
Comments
5 min read
Day 57: Internals of ClickHouse® Data Parts and Merges – A Complete Guide
kanishga_subramani_49ad73 profile

Day 57: Internals of ClickHouse® Data Parts and Merges – A Complete Guide

#clickhouse #devops #analytics #dataengineering
Comments
6 min read
Day 56 – Mastering ClickHouse® AggregatingMergeTree: Build Faster Analytics with Pre-Aggregated Data
kanishga_subramani_49ad73 profile

Day 56 – Mastering ClickHouse® AggregatingMergeTree: Build Faster Analytics with Pre-Aggregated Data

#clickhouse #devops #database #dataengineering
Comments 2
5 min read
Day 55 of #100DaysOfClickHouse - Security Best Practices for ClickHouse® Deployments
kanishga_subramani_49ad73 profile

Day 55 of #100DaysOfClickHouse - Security Best Practices for ClickHouse® Deployments

#clickhouse #devops #dataengineering #analytics
1
Comments 2
4 min read
Day 54: Using ClickHouse® Python Clients Effectively: A Practical Guide
kanishga_subramani_49ad73 profile

Day 54: Using ClickHouse® Python Clients Effectively: A Practical Guide

#clickhouse #devops #database #dataengineering
Comments
5 min read
Day 53: ClickHouse® Data Sampling Explained – Query Billions of Rows Faster
kanishga_subramani_49ad73 profile

Day 53: ClickHouse® Data Sampling Explained – Query Billions of Rows Faster

#clickhouse #devops #database #dataengineering
Comments
5 min read
Day 52 of #100DaysOfClickHouse: ClickHouse® Geospatial Functions for Location Data
kanishga_subramani_49ad73 profile

Day 52 of #100DaysOfClickHouse: ClickHouse® Geospatial Functions for Location Data

#clickhouse #devops #analytics #dataengineering
Comments
4 min read
Day 51: ClickHouse® Materialized Views: Automating Data Transformations and Aggregations
kanishga_subramani_49ad73 profile

Day 51: ClickHouse® Materialized Views: Automating Data Transformations and Aggregations

#clickhouse #devops #database #dataengineering
1
Comments
6 min read
Day 50 - How to Migrate Data from MySQL to ClickHouse®: A Step-by-Step Guide
kanishga_subramani_49ad73 profile

Day 50 - How to Migrate Data from MySQL to ClickHouse®: A Step-by-Step Guide

#clickhouse #devops #database #dataengineering
1
Comments
5 min read
Day 49: Building Dashboards with ClickHouse® and Apache Superset
kanishga_subramani_49ad73 profile

Day 49: Building Dashboards with ClickHouse® and Apache Superset

#clickhouse #database #dataengineering #analytics
2
Comments
4 min read
Day 48 - Sharding Strategies in ClickHouse®
kanishga_subramani_49ad73 profile

Day 48 - Sharding Strategies in ClickHouse®

#clickhouse #devops #database #dataengineering
Comments
4 min read
Day 47 - ClickHouse® Memory Management and Tuning
kanishga_subramani_49ad73 profile

Day 47 - ClickHouse® Memory Management and Tuning

#clickhouse #devops #database #dataengineering
Comments
6 min read
Day 46: A Guide to ClickHouse® Window Functions
kanishga_subramani_49ad73 profile

Day 46: A Guide to ClickHouse® Window Functions

#clickhouse #devops #database #dataengineering
1
Comments
5 min read
Day 45: Using ClickHouse® for Log Analytics and Observability
kanishga_subramani_49ad73 profile

Day 45: Using ClickHouse® for Log Analytics and Observability

#clickhouse #devops #database #dataengineering
1
Comments
5 min read
Day 44 – Exploring ClickHouse® System Tables for Troubleshooting
kanishga_subramani_49ad73 profile

Day 44 – Exploring ClickHouse® System Tables for Troubleshooting

#clickhouse #devops #database #dataengineering
2
Comments
4 min read
Day 43 – ClickHouse® Join Types and Performance Implications
kanishga_subramani_49ad73 profile

Day 43 – ClickHouse® Join Types and Performance Implications

#clickhouse #devops #database #dataengineering
1
Comments
6 min read
Day 42: Exploring ClickHouse® Table Engines Beyond MergeTree
kanishga_subramani_49ad73 profile

Day 42: Exploring ClickHouse® Table Engines Beyond MergeTree

#clickhouse #devops #analytics #database
3
Comments
5 min read
Day 41: Monitoring ClickHouse® Performance Metrics
kanishga_subramani_49ad73 profile

Day 41: Monitoring ClickHouse® Performance Metrics

#clickhouse #devops #database #dataengineering
1
Comments
4 min read
loading...