Stories about the terminal, Athena and S3

September 9, 2024

It's surprising, today I think I did a lot of things. I sat in front of the desktop for about 4 hours continuously, focusing.

But, strangely, by the evening, I couldn't remember anything about the results of the work I had accomplished during the day.

Ok, but at least, I still remember somethings:

  1. If we got an error like below when run the command sudo apt update in Ubuntu. That's because the version of Ubuntu is end of life support, so we must update /etc/apt/sources.list file.
Reading package lists… Done
E: The repository 'http://security.ubuntu.com/ubuntu hirsute-security Release' no longer has a Release file.
N: Updating from such a repository can't be done securely, and is therefore disabled by default.
  • Backup current file cp -p /etc/apt/sources.list /etc/apt/sources.list.old
  • Replace old content in sources.list with the new like below.
deb http://old-releases.ubuntu.com/ubuntu/ hirsute main restricted universe multiverse
deb http://old-releases.ubuntu.com/ubuntu/ hirsute-updates main restricted universe multiverse
deb http://old-releases.ubuntu.com/ubuntu/ hirsute-backports main restricted universe multiverse
deb http://old-releases.ubuntu.com/ubuntu/ hirsute-security main restricted universe multiverse

  1. ls command don't show the hidden directory/ file. Using ls -a to show all.

  2. AWS Athena has the term 'table', 'database' but it doesn't like the traditional RDBMS, it just is the schema to define the struct of the data and it's stored in S3.

The pricing of Athena is based on the number of bytes read.

  1. S3 lifecycle rule: Standard-IA after 30 days, Glacier after 60 days.