Just a list of usefull commands in no particular order.
Test your IPV6
Teradata Mload locking your table?
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
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
For 30 days back run: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)
Or with a day column partitioned table:hive> select date_sub(to_date(from_unixtime(unix_timestamp())),30) ;
And don't forget the single quotation marks.hive> select * from table where day=>'date_sub(to_date(from_unixtime(unix_timestamp())),30)' ;
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:
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.# 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