Despite the fact that RDBMS continues to lead the business, NoSQL is rising in popularity. Those who are accustomed to RDBMS are frequently perplexed by
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.
Get expensive queries in ProxySQL
This article contains ProxySQL queries that aid in the retrieval of expensive inquiries or queries that take a lot of resources and should be modified
SHOW CREATE DATABASE in Apache Hive
In Apache Hive, unlike MySQL or any other RDBMS, there is no SHOW CREATE DATABASE statement. At the very least, not in a direct way.
Display Storage Location of the Table – Apache Hive
We’ll look at how to get the table’s storage location in this article. We don’t always want to put everything in the default warehouse; sometimes
SHOW CREATE VIEW in Apache Hive
The SHOW CREATE VIEW statement in MySQL displays the CREATE VIEW statement used to create the named view. If you want to do the same
Search A Specific Column in Tables – Apache Hive
We sometimes search for a column in the entire database, either to see how many tables a given column appears in or to see if
Big Data & SQL 