George Boole described an algebraic logic system in the mid-19th century. The BOOLEAN data type is named after him. Boolean data type is a data
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.
Checking the Condition Against Column Values – Hive
Similar to relational database systems like SQL Server, Oracle, MySQL, the CASE statement in Apache Hive verifies the conditions against the values of the columns.
Parsing Web URL Data In Apache Hive
A lot of data is generated daily from smartphone apps, blogs, social media networks, games, online shopping, electronic payment channels, etc. Data can be for
Compression Algorithms For ORC File Format
For detailed information about ORC file format, click here. ORC provides the best Hive performance overall. In addition, to specifying the storage format, you can
Optimized Row Columnar (ORC) File Format
The Optimized Row Columnar (ORC) file format is the most powerful way for improved performance and storage saving, of all file formats. It provides the
Conditional Statements in Apache Hive
The use of conditional statements is very frequent when it comes to data interpretation. Often data manipulation, too, relies on conditional statements. Operators such as
Big Data & SQL 