The following command will import data from MySQL into Hbase columnar database for a few specified columns from a certain table. Connect to MySQL and
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.
Number of Tables in Hive Database
In previous postings, I demonstrated how to retrieve metadata from the INFORMATION SCHEMA table in MySQL. It’s now time to check Apache Hive for the
Table Last Modified Date – MySQL
INFORMATION SCHEMA (also referred as system catalog) gives you access to database metadata and MySQL server information like the name of a database or table,
Number of Views and Tables In Each Database – MySQL
INFORMATION SCHEMA (also referred as system catalog) gives you access to database metadata and MySQL server information like the name of a database or table,
Search If A Specific Column is Used in Stored Procedure or Functions – MySQL
INFORMATION SCHEMA (also referred as system catalog) gives you access to database metadata and MySQL server information like the name of a database or table,
Find A Column in Tables – MySQL
INFORMATION SCHEMA (also referred as system catalog) gives you access to database metadata and MySQL server information like the name of a database or table,
Big Data & SQL 