Syntax
# ncli --help postupgradeThis is run after performing the upgrade.
Command | Help Text |
---|---|
checkConfigFileAndRestore | Check if config files are intact after upgrade |
checkQos | Check if QOS is same for both preupgrade and postupgrade |
checkThreshold | Check if the threshold is same for both preupgrade and postupgrade |
cleanup | Do the clean up |
verifySqlhConnectivity | Check if you are connected to your Hadoop cluster |
verifyTdConnectivity | Check if you are connected to your Teradata box |
Example: checkConfigFileAndRestore command
ncli postupgrade checkConfigFileAndRestore postgresql.conf 100% 20KB 20.1KB/s 00:00 hosts 100% 128 0.1KB/s 00:00 resolv.conf 100% 132 0.1KB/s 00:00 coordinator.cfg 100% 9889 9.7KB/s 00:00 loader.cfg 100% 3351 3.3KB/s 00:00 queen-replacement.cfg 100% 20 0.0KB/s 00:00 worker.cfg 100% 5752 5.6KB/s 00:00 coordinator.profile 100% 1498 1.5KB/s 00:00 loader.profile 100% 290 0.3KB/s 00:00 worker.profile 100% 1174 1.2KB/s 00:00 ntp.conf 100% 1833 1.8KB/s 00:00 beehiveparams.cfg 100% 501 0.5KB/s 00:00 cgconfig.conf 100% 812 0.8KB/s 00:00 pg_hba.conf 100% 3386 3.3KB/s 00:00 postgresql.conf 100% 20KB 20.1KB/s 00:00 postgresql.conf 100% 20KB 20.1KB/s 00:00 hosts 100% 128 0.1KB/s 00:00 resolv.conf 100% 155 0.2KB/s 00:00 coordinator.cfg 100% 9889 9.7KB/s 00:00 loader.cfg 100% 3351 3.3KB/s 00:00 queen-replacement.cfg 100% 20 0.0KB/s 00:00 worker.cfg 100% 5752 5.6KB/s 00:00 coordinator.profile 100% 1498 1.5KB/s 00:00 loader.profile 100% 290 0.3KB/s 00:00 worker.profile 100% 1174 1.2KB/s 00:00 ntp.conf 100% 1833 1.8KB/s 00:00 beehiveparams.cfg 100% 501 0.5KB/s 00:00 cgconfig.conf 100% 812 0.8KB/s 00:00 pg_hba.conf 100% 3386 3.3KB/s 00:00 postgresql.conf 100% 20KB 20.1KB/s 00:00 ConfigFileCheck +--------+---------------------------------------------------+ | Node | Status | +--------+---------------------------------------------------+ | queen | All the Config files are intact after upgrade | | worker | All the Config files are intact after upgrade | +--------+---------------------------------------------------+
Example: checkQos command
ncli postupgrade checkQos QOS concurrency has not changed after upgrade
Example: checkThreshold command
ncli postupgrade checkThreshold Threshold has not changed
Example: cleanup command
ncli postupgrade cleanup clean up done
Example: verifySqlhConnectivity command
Bolded words are user input, which can be seen either at command call or while output is generated.
ncli postupgrade verifySqlhConnectivity Please enter table name: someTable Please enter user : someUser ####### Started to pre-check input parameters ######## ========= Started sqlh config validation test ========= ========= Passed: sqlh config validation test ========= ========= Started: hcatalog server hostname validation test========= ========= Passed: hcatalog server hostname validation test========= ========= Started: hiveserver2 hostname validation test========= ========= Passed: hiveserver2 hostname validation test========= ========= Started queen hive metastore access validation test ========= ========= Passed: metastore access test ========= ========= Started standalone program validation test ========= ========= Passed standalone program validation test ========= ========= Started clean up ========= ========= clean up finished ========= ####### Successfully validated sqlh config for server someRemoteSystem #######
Example: verifyTdConnectivity command
Bolded words are user input, which can be seen either at command call or while output is generated.
ncli postupgrade verifyTdConnectivity
Please enter tdpid: someTeradataSystem
*** Diagnosis from 111.222.333.444 ***
Checking Connectivity
Checking Connectivity with TDPID: someTeradataSystem
someTeradataSystem resolvable on the network
someTeradataSystem:1025 connection successful
Looking for cop entries
someTeradataSystemcop1 resolvable on the network
someTeradataSystemcop1:1025 connection successful
someTeradataSystemcop2 is not reachable
*** Diagnosis from 222.333.444.555 ***
Checking Connectivity
Checking Connectivity with TDPID: lnx2038
someTeradataSystem resolvable on the network
someTeradataSystem:1025 connection successful
Looking for cop entries
someTeradataSystemcop1 resolvable on the network
someTeradataSystem:1025 connection successful
someTeradataSystemcop2 is not reachable