Shell yesterday’s date

The date command in SH is pretty powerful. Here’s you can get yesterday’s date - something I find myself doing frequently for things like get data from an API for the last day, etc.

$ date +%Y-%m-%d --date=yesterday
2014-02-05
 
2
Kudos
 
2
Kudos

Now read this

Hive doesn’t like the carriage return character

Have you ever run in to a situation where you count the number of rows for a table in a database, then dump it to CSV and then load it to HIVE only to find that number has changed? Well, you probably have carriage returns in your fields.... Continue →