Apr 15, 2025 Β· 9 min read Β· A containerized data platform stack featuring distributed processing, SQL analytics, and data visualization. The project setup is also available on my Github. Happy reading! β¨ Overall Architecture π Key Features ComponentDescription S3 Bucke...
Join discussion
Oct 22, 2024 Β· 17 min read Β· μ μ ANSI SQL μ μ΄λμ λ μκ³ μμ. ANSI SQL μ λͺ¨λ Syntax λ₯Ό λ€λ£¨μ§λ μμ. ANSI SQL μμ μ¬μ©νλ κΈ°λ³Έμ μΈ Function λ€μ λν΄μ μ§μμ κ°μ§κ³ μμ. ANSI SQL SELECT λ°μ΄ν°λ₯Ό μ‘°νν λ κ°μ₯ κΈ°λ³Έμ μΈ κ΅¬λ¬Έμ λλ€. -- Syntax SELECT column1, column2 FROM table_name; -- Example: μ§μλ€μ μ΄λ¦κ³Ό λμ΄λ₯Ό μΆμΆν©λλ€. SE...
Join discussion
Oct 14, 2024 Β· 8 min read Β· Lambda Architecture κ΅¬μ± μμ Batch Layer μ κΈ°μ μΌλ‘ λλμ Historical Data λ₯Ό μ²λ¦¬ν©λλ€. (μ: Daily λλ Hourly) μ΄λ₯Ό ν΅ν΄ λμ μ νλμ λ°μ΄ν° Completeness (μμ μ±) μ 보μ₯νλ©°, 볡μ‘ν Data λ³νμ μ²λ¦¬ν©λλ€. Speed Layer μ€μκ° Data λ₯Ό μ²λ¦¬νμ¬ low-latency μκ°μ κ²°κ³Όλ₯Ό μ 곡ν©λλ€. Batch Layer κ° λμΌν Data λ₯Ό μ²λ¦¬ν ...
Join discussionOct 10, 2024 Β· 19 min read Β· Understanding the Clear Reasons for Using Trino Since the installation and configuration methods of Trino vary depending on how you use it, it's essential to first clearly understand the reasons for using it. Determine if you need to fetch data from...
Join discussion
Sep 27, 2024 Β· 19 min read Β· Trino μ¬μ© μ΄μ λ₯Ό λͺ ννκ² νμ νκΈ° Trino λ μ¬μ©νλ λ°©λ²μ λ°λΌμ μ€μΉ, κ΅¬μ± λ°©λ²μ΄ λ€λ₯΄κΈ° λλ¬Έμ μ¬μ©νλ μ΄μ λ₯Ό λͺ ννκ² νμ νλ κ²μ λ¨Όμ μνλμ΄μΌ ν©λλ€. λ€μν Data Source (MySQL, PostgreSQL, HDFS, Amazon S3, Cassandra, Kafka λ±)λ‘λΆν° λ°μ΄ν°λ₯Ό κ°μ Έμ νλμ Query λ‘ ν΅ν©νμ¬ λΆμν νμκ° μλ μ§ νμ Business Intelligence Platform...
Join discussion
Aug 26, 2024 Β· 2 min read Β· Explore how Trino and DbVisualizer can transform your data management and visualization. This guide provides essential steps and tips for using Trino's SQL query engine with DbVisualizer's interface. Trino and DbVisualizer Integration Trino is an ope...
Join discussion
May 24, 2024 Β· 14 min read Β· In this post, we want to compare Trino, the popular distributed query engine that runs analytical queries over big volumes of data with interactive latencies with StarRocks. Sources of Information Weβve consulted StarRocks committers (Heng Zhao, Star...
Join discussion
Oct 2, 2023 Β· 11 min read Β· Unlock the potential of Trino and DbVisualizer in our latest blog post. Explore Trino's distributed SQL query capabilities and harness DbVisualizer's intuitive interface for data exploration, visualization, and optimization. Read now to unleash the p...
Join discussion