Up and Running with ClickHouse | Learn and Explore ClickHouse, It's Robust Table Engines for Analytical Tasks, ClickHouse SQL, Integration with External Applications, and Managing the ClickHouse Server (English Edition)

Vijay Anand R

ISBN 10: 9391392245 ISBN 13: 9789391392246

Editore: BPB Publications, 2021

Lingua: Inglese

Print on Demand

Condizione: Nuovo Brossura

Lista dei preferiti

Venduto da preigu, Osnabr�ck, Germania

Venditore AbeBooks dal 5 agosto 2024

Valutazione del venditore 5 su 5 stelle

Visualizza gli articoli del venditore

Mostra tutte le copie di questo libro

Nuovi - Brossura

Condizione: Nuovo

Prezzo:

EUR 48,40

Spedizione EUR 70,00
Spedito da Germania a U.S.A.

Quantit�: 5 disponibili

Aggiungere al carrello

Lista dei preferiti

Riguardo questo articolo

Codice articolo 120852248

Contatta il venditore

Segnala questo articolo

Dati bibliografici

Titolo

Editore

BPB Publications

Data di pubblicazione

2021

Lingua

Inglese

ISBN 10

9391392245

ISBN 13

9789391392246

Rilegatura

Taschenbuch

Condizione

Neu

Dimensioni

Peso

532 grammi

Cataloghi dei venditori

B�cher

Descrizione articolo

Riassunto

Create scalable, fault-tolerant, and reliable online analytical applications with a feature-rich DBMS designed for speed.

Key Features

● Hands-on approach towards learning ClickHouse from basic to advanced level.

● Numerous examples demonstrating how to use ClickHouse for analytical tasks.

● Straightforward explanations for complex concepts on ClickHouse and its vast features.

● Integration with a variety of technologies such as MySQL, PostgreSQL, Kafka, and Amazon S3.

Description

This book provides a hands-on approach for data professionals to onboard ClickHouse and empowers the readers to perform real-time analytics using ClickHouse SQL.

The readers will understand the fundamentals of database technologies and frequently used relational database concepts such as keys, database normalisation etc. The readers will learn to query the data using SQL (ClickHouse dialect), configure databases and tables in ClickHouse and use the various types of core table engines available in ClickHouse, including the MergeTree and Log family engines. The readers will be able to investigate and practically integrate ClickHouse with various external data sources and work with unique table engines shipped with ClickHouse. With help of the examples provided, readers will be able to gain experience in configuring the ClickHouse setup and perform administrative tasks in the ClickHouse Server.

Throughout this journey, readers will reinforce their learning by using numerous working examples and the question and answer section at the end of each chapter. By the end of this book, readers will be able to apply their knowledge and utilize ClickHouse in real-world applications.

What you will learn

● Querying the tables in ClickHouse and performing analytical tasks using ClickHouse SQL.

● Integrating and running queries with popular RDBMS, including MySQL and PostgreSQL.

● Integrating with cloud storage and streaming platforms such as S3 and Kafka.

● Working with Core engines and special engines.

● Configure the ClickHouse setup and carry out administrative tasks.

Who this book is for

This book is intended for data engineers, application developers, database administrators and software architects who want to learn ClickHouse.

Table of Contents

1. Introduction

2. The Relational Database Model and Database Design

3. Setting up the Environment

4. ClickHouse SQL

5. SQL Functions in ClickHouse

6. SQL Functions for Data Aggregation

7. Table Engines - MergeTree Family

8. Table Engines - Log Family

9. External Data Sources

10. Special Engines

11. Configuring the ClickHouse Setup – Part 1

12. Configuring the ClickHouse Setup – Part 2

Informazioni sull'autore

Vijay Anand is a technology professional based out of Chennai who works on solving data engineering and data science problems. He has worked across multiple domains, including sports analytics and telecom. He is currently working as a technical lead for the world's leading manufacturer of construction and mining equipment. He has done his masters from Vrije Universiteit, Brussel. His areas of interest include database design, building software solutions, machine learning, and data science.

Le informazioni nella sezione "Su questo libro" possono far riferimento a edizioni diverse di questo titolo.

Descrizione libreria

preigu betreibt einen Onlineversandhandel mit �ber 1 Mio. Produkten in verschiedenen Sortimenten. Das Kernsortiment besteht aus B�chern, Medien und Spielwaren. Ein gelungenes Einkaufserlebnis ist das Ziel einer jeden Bestellung bei preigu, denn der Kunde und seine Zufriedenheit stehen an erster Stelle. preigu setzt daher auf einen kompetenten Kundenservice, funktionierende Prozesse und schnelle Reaktion.

Visita la pagina della libreria

Informazioni sull'azienda del venditore

preigu GmbH & Co. KG
Lengericher Landstra�e 19, Osnabr�ck, 49078, Germany

Condizioni di vendita e spedizione

Condizioni di vendita

Standard Business Terms and customer information

I. Standard business terms

� 1 Basic provisions

(1) The following terms and conditions of business apply for all contracts concluded with us as the supplier (preigu GmbH & Co. KG) via the websites AbeBooks and/or ZVAB. Unless otherwise agreed, the inclusion of your own terms and conditions is explicitly rejected.

(2) A ?consumer' in the sense of the following regulations is every natural person who concludes a legal transaction which, to an overwh...

Ulteriori informazioni

Diritto di recesso

Instructions for revocation

Right of withdrawal for the sale of goods

Revocation right for consumers
(A ‘consumer' is any natural person who concludes a legal transaction which, to an overwhelming extent, cannot be attributed to either his commercial or independent professional activities.)

Instructions for revocation

Revocation right
You have the right to revoke this contract within 14 days without specifying any reasons.
The revocation period is 14 days with effect from the day,

on which you or a third party nominated by you, which is not the carrier, had taken possession of the products, provided you had ordered one or more products within the scope of a standard order and this/these product/products is/are delivered uniformly;
on which you or a third party nominated by you, which is not the carrier, had taken possession of the last product, provided you had ordered several products within the scope of a standard order and these products are delivered separately;
on which you or a third party nominated by you, which is not the carrier, had taken possession of the last part delivery or the last unit, provided you had ordered a product, which is delivered in several part deliveries or units;

To exercise your right of withdrawal, you must inform us (preigu GmbH & Co. KG, Lengericher Landstr. 19, 49078 Osnabr�ck, Telephone number: +49 (0) 541 / 580 72 84, E-Mail address: mail@preigu.de) by means of a clear declaration (e.g. a letter sent by post, or an e-mail) of your decision to withdraw from this contract. You can use the attached model withdrawal form for this purpose, which is, however, not mandatory.

You can also exercise your right of withdrawal online by clicking on a button labelled accordingly (such as ‘Withdraw from contract' or similar) on the AbeBooks/ZVAB website. If you use this online function, you will immediately receive a confirmation of receipt on a durable medium (e.g. via email) containing information on the content of the withdrawal notice, as well as the date and time of its receipt.

In order to safeguard the revocation period, it is sufficient that you send the notification about the exercise of the revocation right before the expiry of the revocation period.

Consequences of the revocation

If you revoke this contract, we shall repay all the payments, which we received from you, including the delivery costs (with the exception of additional costs, which arise from that fact that you selected a form of delivery other than the most reasonable standard delivery offered by us), immediately and at the latest within 14 days from the day on which we received the notification about the revocation of this contract from you. We use the same means of payment, which you had originally used during the original transaction, for this repayment unless expressly agreed otherwise with you; you will not be charged any fees owing to this repayment.

We can refuse the repayment until the products are returned to us or until you have furnished evidence that you have sent the products back to us, depending on whichever is earlier.

You must return or transfer the products to us immediately and, in any case, at the latest within 14 days with effect from the day on which you inform us of the revocation of this contract. The deadline is maintained if you send the products before the expiry of the 14 day deadline.

You bear the direct costs for returning the products.

You must pay for any depreciation of the products only if this depreciation can be attributed to any handling with you that was not necessary for checking the condition, features and functionality of the products.

Criteria for exclusion or expiry

The revocation right is not available for contracts

for delivery of products, which are not prefabricated and for whose manufacturing an individual selection or stipulation by the consumer is important or which are clearly tailored to the personal requirements of the consumer;
for delivery of products, which can spoil quickly or whose use-by date would be exceeded quickly;
for delivery of alcoholic drinks, whose price was agreed at the time of concluding the contract, which however can be delivered 30 days after the conclusion of the contract at the earliest and whose current value depends on the fluctuations in the market, on which the entrepreneur has no influence;
for delivery of newspapers, periodicals or magazines with the exception of subscription contracts. The revocation right expires prematurely in case of contracts
for delivery of sealed products, which are not suitable for return for reasons of health protection or hygiene if their seal has been removed after the delivery;
for delivery of products if they have been mixed inseparably with other goods after the delivery, owing to their condition;
for delivery of sound or video recording or computer software in a sealed package if the seal has been removed after the delivery.

Specimen - revocation form

(If you wish to revoke the contract, please fill up this form and send it back to us.)

To preigu GmbH & Co. KG, Lengericher Landstr. 19, 49078 Osnabr�ck, Email address: mail@preigu.de :
I/we () herewith revoke the contract concluded by me/ us () regarding the purchase of the following products ()/
the provision of the following service ()
Ordered on ()/ received on ()
Name of the consumer(s)
Address of the consumer(s)
Signature of the consumer(s) (only in case of a notification on paper)
Date

(*) Cross out the incorrect option.

Condizioni di spedizione

Tariffe di spedizione da Germania a U.S.A.

Tariffe di spedizione da Germania a U.S.A.
Quantit� dell'ordine	Da 60 a 60 giorni lavorativi	Da 60 a 60 giorni lavorativi
Primo articolo	EUR 70.00	EUR 70.00

I tempi di consegna sono stabiliti dai venditori e variano in base al corriere e al paese. Gli ordini che devono attraversare una dogana possono subire ritardi e spetta agli acquirenti pagare eventuali tariffe o dazi associati. I venditori possono contattarti in merito ad addebiti aggiuntivi dovuti a eventuali maggiorazioni dei costi di spedizione dei tuoi articoli.

Informazioni dettagliate sul venditore