SHOW CREATE Statement in Apache Impala

In this post, we will be discussing the most frequently used admin commands specifically the SHOW commands. SHOW is a command that displays information about active connections and database objects.

In order to get the CREATE TABLE statement, use the following command.
SHOW CREATE TABLE [database_name].table_name

In order to get the CREATE VIEW statement, use the following command.
SHOW CREATE VIEW [database_name].view_name

In order to get the CREATE FUNCTION statement, use the following command. (Ref)
SHOW CREATE FUNCTION [database_name].function_name

The statement SHOW CREATE DATABASE isn’t accessible. However, there is a workaround that will be described in more detail in future publications.

Hope you find this article helpful.

Please subscribe for more interesting updates.