Usefull commands.

Just a list of usefull commands in no particular order.

Test your IPV6

Teradata Mload locking your table?

Try this.

DROP SCHEMA.ET_YOUR_TABLE;
DROP SCHEMA.ML_YOUR_TABLE;
DROP SCHEMA.UV_YOUR_TABLE;
DROP SCHEMA.WT_YOUR_TABLE;

RELEASE MLOAD SCHEMA.YOUR_TABLE;

If you get this error add the extra option.

ERROR 2572: Mload table SCHEMA:YOUR_TABLE can not be released.

RELEASE MLOAD SCHEMA.YOUR_TABLE IN APPLY;

And the result should be "Release completed"

Fedora release upgrade via cli

Install the Fedora update utility, run:

sudo dnf install dnf-plugin-system-upgrade
sudo dnf upgrade --refresh

Start the upgrade procedure and download packages, run:

sudo dnf system-upgrade download --releasever=32

Reboot the box and complete upgrade, run:

sudo dnf system-upgrade reboot

Verify upgrades

SHA output length

By the definition in FIPS 180-4, published March 2012, there are

160 bits in the output of SHA-1
224 bits in the output of SHA-224
256 bits in the output of SHA-256
384 bits in the output of SHA-384
512 bits in the output of SHA-512
224 bits in the output of SHA-512/224
256 bits in the output of SHA-512/256

Hive SQL: get yesterday's date

Get yesterday's date

hive> select date_sub(to_date(from_unixtime(unix_timestamp())),1) ;
Total jobs = 1
Launching Job 1 out of 1
Number of reduce tasks is set to 0 since there's no reduce operator
Hadoop job information for Stage-1: number of mappers: 1; number of reducers: 0
2019-10-04 08:38:44,813 Stage-1 map = 0%,  reduce = 0%
2019-10-04 08:39:29,330 Stage-1 map = 100%,  reduce = 0%, Cumulative CPU 3.46 sec
MapReduce Total cumulative CPU time: 3 seconds 460 msec
Ended Job = job__185442
MapReduce Jobs Launched:
Stage-Stage-1: Map: 1   Cumulative CPU: 3.46 sec   HDFS Read: 292 HDFS Write: 11 SUCCESS
Total MapReduce CPU Time Spent: 3 seconds 460 msec
OK
2019-10-03
Time taken: 105.281 seconds, Fetched: 1 row(s)

For 30 days back run:


hive> select date_sub(to_date(from_unixtime(unix_timestamp())),30) ;

Or with a day column partitioned table:


hive> select * from table where day=>'date_sub(to_date(from_unixtime(unix_timestamp())),30)' ;

And don't forget the single quotation marks.

Reset Postgres user password, in case you forgot password.

Steps to follow in order to reset any Postgres database password. The pg_hba.conf (C:\Program Files\PostgreSQL\9.3\data) , in Windows. Open the file and change the METHOD from md5to trust:

# TYPE DATABASE USER ADDRESS METHOD
# IPv4 local connections:
host all all 127.0.0.1/32 trust
# IPv6 local connections:
host all all ::1/128 trust

Then, using pgAdmin III, You log in using no password and changed user postgres password by going to File -> Change Password. And don't forget to revert the values trust into md5.

Published: 16.11.2020