The Relational Database Architecture is the simplest model, since it does not need any complex structuring and does not entail complicated architectural processes. The simplicity
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.
Regular Expression Extract (Regexp_Extract) In Apache Hive
Regular expression functions identify precise patterns of characters in the given string and returns the matching text item from the string/data. Syntax: REGEXP_EXTRACT(STRING subject, STRING
Revamp Your Resume To ATS Friendly
If you want to revamp your CV or if you want your resume optimized to be readable by ATS software, here is your chance to
Data Sampling Techniques – Apache Hive
Data sampling is the best practice to understand the data patterns and trends of large datasets by looking at the smaller portion of the data
Can We Create An External Table Using CTAS?
Can we create an external table using CTAS? The answer is NO. (Read till the end) As per the Hive’s documentation, CTAS has these restrictions:
Hive Internal Tables Using CTAS
In addition to previous implementations of the creation of internal tables (a.k.a. managed tables), another approach for creating internal tables is using the CTAS (create-table-as-select)
Big Data & SQL 