The PRINTF function returns the formatted input according to the printf-style format string. When using hive scripts, this would be beneficial. Syntax: printf(String format, Obj…
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.
Collection Functions in Hive
The following built-in collection functions in Apache Hive. Size(Map<K.V>): Returns the number of elements in the map type. Example: SELECT mobile,places_lived,SIZE(mobile), SIZE(places_lived) FROM ExplodeTest2; Size(Array<T>):
Table Generting Functions in Hive – Explode
Normal user-defined functions take in a single input row and output a single output row. In contrast, table-generating functions transform a single input row to
Case Conversion in Apache Hive & Apache Impala
Apache Hive provides many features that SQL developers are familiar with. The behavior in much of the functions is the same. Such functions help to
Best Example For Repeat Function In Apache Hive & Impala
When the new business rules are introduced, it might be necessary to perform any cleanup or transformations on existing data. The below is an use
Padding Functions in Apache Hive & Apache Impala
The padding functions are used to fill the left or right side of a string with a specific set of characters. These functions are useful
Big Data & SQL 