Machine Learning with ClickHouse Nikolai Kochetov, ClickHouse developer Experimental dataset NYC Taxi and Uber Trips › Where to download: https://www1.nyc.gov/site/tlc/about/tlc-trip-record-data.page ClickHouse stochasticLinearRegression(parameters)(target, x1, ..., xN) Available parameters: › learning_rate › l2_regularization › batch_size › optimizer: Adam, SGD, Momentum, Nesterov All parameters = df['total_amount'] # Initialize CatBoostRegressor model = CatBoostRegressor(iterations=1000, learning_rate=0.1, depth=6) # Fit model model.fit(train_data, train_labels, cat_features=[1]) # Save model

Machine Learning with ClickHouse Nikolai Kochetov, ClickHouse developer Experimental dataset NYC Taxi and Uber Trips › Where to download: https://www1.nyc.gov/site/tlc/about/tlc-trip-record-data.page ClickHouse stochasticLinearRegression(parameters)(target, x1, ..., xN) Available parameters: › learning_rate › l2_regularization › batch_size › optimizer: Adam, SGD, Momentum, Nesterov All parameters = df['total_amount'] # Initialize CatBoostRegressor model = CatBoostRegressor(iterations=1000, learning_rate=0.1, depth=6) # Fit model model.fit(train_data, train_labels, cat_features=[1]) # Save model

Extensions (Tanzu Greenplum) 0 Procedural Language, Machine Learning, and Geospatial Extensions 269 Procedural Language, Machine Learning, and Geospatial Extensions 0 Python Data Science Module Package Machine Learning and Deep Learning 383 Geospatial Analytics 384 Text Analytics 384 Programming Language Extensions 384 Why Greenplum Database in Integrated Analytics 384 Machine Learning and Deep Learning Learning using MADlib 385 Machine Learning and Deep Learning using MADlib 0 Machine Learning 386 Deep Learning 386 PivotalR 387 Installing MADlib 387 Installing the Greenplum Database MADlib Package

Greenplum) 0 Procedural Language, Machine Learning, and Geospatial Extensions 277 VMware Greenplum v6.19 Documentation VMware, Inc. 11 Procedural Language, Machine Learning, and Geospatial Extensions 0 Python Machine Learning and Deep Learning 392 Geospatial Analytics 393 Text Analytics 393 Programming Language Extensions 393 Why Greenplum Database in Integrated Analytics 393 Machine Learning and Deep Learning Learning using MADlib 394 Machine Learning and Deep Learning using MADlib 0 Machine Learning 395 Deep Learning 395 PivotalR 396 Installing MADlib 396 Installing the Greenplum Database MADlib Package

Installing Optional Extensions 0 Procedural Language, Machine Learning, and Geospatial Extensions 202 Procedural Language, Machine Learning, and Geospatial Extensions 0 Python Data Science Module Package Integrated Analytics 0 The Greenplum Database Integrated Analytics Ecosystem 318 Machine Learning and Deep Learning 318 Geospatial Analytics 319 Text Analytics 319 Programming Language Extensions 319 Documentation VMware, Inc. 14 Machine Learning and Deep Learning using MADlib 320 Machine Learning and Deep Learning using MADlib 0 Machine Learning 321 Deep Learning 321 PivotalR 322 Installing MADlib

Greenplum) 432 VMware Greenplum 6 Documentation VMware by Broadcom 21 Procedural Language, Machine Learning, and Geospatial Extensions 433 Data Science Package for Python 433 Data Science Package for Python Machine Learning and Deep Learning 905 Geospatial Analytics 905 Text Analytics 905 Programming Language Extensions 906 Why Greenplum Database in Integrated Analytics 906 Machine Learning and Deep Learning Learning using MADlib 907 Machine Learning 907 Deep Learning 908 PivotalR 908 Prerequisites 909 Installing MADlib 909 Installing the Greenplum Database MADlib Package 909 Adding MADlib Functions to

Loading Data 414 Installing Optional Extensions (VMware Greenplum) 414 Procedural Language, Machine Learning, and Geospatial Extensions 414 Data Science Package for Python 415 Data Science Package for Python Machine Learning and Deep Learning 876 Geospatial Analytics 876 Text Analytics 876 Programming Language Extensions 877 Why Greenplum Database in Integrated Analytics 877 Machine Learning and Deep Learning Learning using MADlib 878 Machine Learning 879 Deep Learning 879 PivotalR 879 Installing MADlib 880 Installing the Greenplum Database MADlib Package 880 Adding MADlib Functions to a Database 881 Upgrading

Loading Data 439 Installing Optional Extensions (VMware Greenplum) 439 Procedural Language, Machine Learning, and Geospatial Extensions 439 Data Science Package for Python 440 Data Science Package for Python Machine Learning and Deep Learning 896 Geospatial Analytics 896 Text Analytics 896 Programming Language Extensions 896 Why Greenplum Database in Integrated Analytics 897 Machine Learning and Deep Learning Learning using MADlib 898 Machine Learning 898 Deep Learning 899 PivotalR 899 Installing MADlib 900 Installing the Greenplum Database MADlib Package 900 Adding MADlib Functions to a Database 900 Upgrading

Loading Data 424 Installing Optional Extensions (Tanzu Greenplum) 424 Procedural Language, Machine Learning, and Geospatial Extensions 424 Data Science Package for Python 425 Data Science Package for Python Machine Learning and Deep Learning 868 Geospatial Analytics 868 Text Analytics 868 Programming Language Extensions 868 Why Greenplum Database in Integrated Analytics 869 Machine Learning and Deep Learning Learning using MADlib 869 VMware Tanzu Greenplum 6 Documentation VMware, Inc 37 Machine Learning 870 Deep Learning 871 PivotalR 871 Installing MADlib 871 Installing the Greenplum Database MADlib Package

Loading Data 273 Installing Optional Extensions (Tanzu Greenplum) 274 Procedural Language, Machine Learning, and Geospatial Extensions 274 Python Data Science Module Package 274 Python Data Science Modules Machine Learning and Deep Learning 387 Geospatial Analytics 387 Text Analytics 388 Programming Language Extensions 388 Why Greenplum Database in Integrated Analytics 388 Machine Learning and Deep Learning Learning using MADlib 389 Machine Learning 390 Deep Learning 390 PivotalR 390 Installing MADlib 391 Installing the Greenplum Database MADlib Package 391 Adding MADlib Functions to a Database 392 Upgrading