Sometimes the data stores in the table in a different format in comparison to the real data type it belongs to. The date might be
Clearing Screen – HDFS Terminal, Hive, Impala
Sometimes we may need to clear the screen or console window of commands or any output generated from the previous task. The following commands are
Sqoop Complete Tutorial Part-5
This is the continuation part of “Sqoop Complete Tutorial”. If you want to read – Part-1, please click here. Part-2, please click here. Part-3, please
SQL Server Error Log – Search
The SQL Server error log contains user-defined events and certain system events you can use for troubleshooting. The errors and the informational data will be
Find a specific column from the database objects
There are many ways to find out a specific column from the database objects like Tables and stored procedures. 1) Red Gate’s SQL Search:This tool
Status of SQL Server Agent
SQL Server Agent is a Microsoft Windows service that executes scheduled jobs and DBAs need to ensure the Agent is running. There are several methods to
Big Data and SQL 