Usually, several stored procedures will be provided to DBAs to deploy in the Production environment. Some of the existing stored procedures need to be replaced
Import from Excel – Named Sheet
This article is to let you know how to import Excel data into SQL Server. First of all download a set of components i.e OLE
Generate multiple CSV data files from SQL
Assume that there are thousands of rows in a table and the rows need to be split and saved in different CSV files based on
SQL Server – Parsing, Casting and Conversion
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
Big Data & SQL 