We frequently use the SHOW TABLES command to display a list of all the tables in the current database. If the list is too long,
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.
Change Column Position – Apache Impala & Apache Hive
Previous articles described how to insert columns between existing table columns in various RDBMSs. Currently, Apache Impala does not support this. You can, however, change
Adding multiple columns in between columns – MySQL
When working with several RDBMSs, even minor changes in syntax can cause difficulties. This is the first in a series of postings about how to
Adding Multiple Columns in Apache Impala
When you engage with several RDBMSs, even a small amount of change in syntax can cause confusion. This is the second in a series of
Adding multiple columns in a table – MySQL
When you engage with several RDBMSs, even a small amount of change in syntax can cause confusion. This is the first in a series of
Apache Impala DROP Statement
The DROP command aids in the deletion of database objects. This is a popular command in any RDBMS, and it should be used with caution
Big Data & SQL 