There will be some situations where we need to compare two dates during the data analysis, to verify how many specified time intervals exist between
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.
Finding the length of a string – Apache Hive & Apache Impala
The LENGTH() function returns the length of a string. Both leading and trailing spaces at the begin and end of the string is included when
Adding and Substracting Months to a Date – Apache Hive & Apache Impala
We addressed in the previous post that “Date” is the most significant column that helps to explain patterns, trends and even business. From diagnostic analysis
Concatenating Columns In Apache Hive & Apache Impala
The CONCAT function in Apache Hive incorporates two or more strings into a single string. This function’s behavior is the same as in relational database
Contact Us
To your inquiries, we are incredibly sensitive and appreciate your questions. In the event of technological challenges and support, get in contact with us.
LOCATE Function in Apache Hive & Apache Impala
The LOCATE function is also helpful when looking for a substring in a string, similar to the INSTR function. Note: The below specified function is
Big Data & SQL 