The Apache Hive CAST function is a type conversion function that converts data types from one to another. It can convert a string to an
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.
Apache Impala – Limitations
Apache Impala is an open source massively parallel SQL query engine for data stored in a Hadoop-based cluster. Impala delivers Hadoop scalable parallel database technology,
ProxySQL – How It Works
Please read the previous post for a quick introduction to ProxySQL. As stated earlier, ProxySQL is a powerful software load balancer and an open-source database
ProxySQL – The Journey Begins
ProxySQL is a powerful software load balancer and an open-source database protocol aware proxy for MySQL that provides high performance, high availability, and high availability.
List tables in PostgreSQL
Unlike MySQL, Apache Hive, and Apache Impala, we can’t acquire a list of tables in PostgreSQL using the SHOW TABLES command. Use the below command
Apache Hive Database Size
We might need to know the database size for a variety of reasons, such as capacity planning, storage allocations, and so on. The following methods
Big Data & SQL 