SQL Server’s mathematical functions assist in calculating values. The functions will assist with fundamental addition, subtraction, multiplication, and division, among other things. Let’s take a
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
Listing HDFS Commands in Terminal
The below command allows us to see the Hadoop HDFS file operations such as modifying file permissions, reading file contents, creating files or directories, moving
Check Directory Size in HDFS
In Cloudera virtual machines, the command syntax for retrieving the directory size in HDFS is listed below. hadoop fs -du -s -h /directory Examples: hadoop
IDENTITY usage in SELECT INTO – SQL Server
The IDENTITY function can be defined for an identity column when the table is created and for a new column when the table is altered.
DAY, MONTH, YEAR functions in SQL Server
The DAY, MONTH, YEAR functions can be used to extract the day, month, and year from a date. These features are most commonly used in
TIMEFROMPARTS in SQL Server
It may be necessary to integrate the several elements of the time into one. In such cases, SQL Server’s TIMEFROMPARTS function will come in handy.
Big Data & SQL 