Shantanu's Blog
Database Consultant
May 01, 2024
Remote Desktop to Ubuntu Server
›
Ubuntu Desktop requires downloading about 500 MB of packages and an additional 2 GB of disk space. If that's too much, you can install a...
April 29, 2024
Partitioning and bucketing S3 data
›
Let's assume we need to optimize this query. The data is stored in S3 (around a few TB) SELECT * FROM "bucketing_blog"."n...
November 18, 2023
awk Case Study - 10
›
Formats its input into lines that are at most 60 characters long # fmt - format # input: text # output: text formatted into lines of <= 6...
November 17, 2023
awk Case Study - 9
›
Cliche generator, which creates new cliches out of old ones. The input is a set of sentences like # cat cliche.txt A rolling stone:gathers ...
awk Case Study - 8
›
Isolate the words and aggregate the count for each word in an associative array. A word is a field without the punctuation marks like ? or ,...
›
Home
View web version