As stated in the previous article – XPath_Short, XPath_Int, XPath_Long, XPath_Float, XPath_Double, XPath_Number, and XPath_String are the XPath UDFs available in Apache Hive that helps in
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.
Using XPath to read XML in Hive
XPath is used to navigate through elements and attributes in an XML document. XPath Short, XPath Int, XPath Long, XPath Float, XPath Double, XPath Number,
SQL Server – Partitions on Existing Tables
About the fact that my site’s name is Big Data & SQL, I don’t write much regarding SQL. It’s because I don’t want to repeat
Complex Data Types – STRUCT within ARRAY -2
Related to the previous post, the following is another example of complex data types being used within another complex data type. We’ll deal with STRUCT
Complex Data Types – STRUCT within ARRAY -1
We’ve learned how to deal with each complex datatype separately so far, and we’ve even looked into the possibilities of including all complex data types
Complex Data Types – Part-5
Previous posts explained how to deal with Complex Data Types Array, Map, Struct individually. In this post, we will learn how to handle them when
Big Data & SQL 