Help Center/
MapReduce Service/
Component Operation Guide (LTS)/
Using HetuEngine/
HetuEngine SQL Syntax/
SQL Syntax/
DDL Syntax/
SHOW CREATE TABLE
Updated on 2024-05-29 GMT+08:00
SHOW CREATE TABLE
Syntax
SHOW CREATE TABLE table_name
Description
This statement is used to display the SQL creating statement for a specified data table.
Example
To display the SQL statements that can be used to create the table orders:
CREATE TABLE orders ( orderkey bigint, orderstatus varchar, totalprice double, orderdate date ) WITH (format = 'ORC', location='/user',orc_compress='ZLIB',external=true, "auto.purge"=false); show create table orders; Create Table ------------------------------------------------- CREATE TABLE hive.default.orders ( orderkey bigint, orderstatus varchar, totalprice double, orderdate date ) WITH ( external_location = 'hdfs://hacluster/user', format = 'ORC', orc_compress = 'ZLIB', orc_compress_size = 262144, orc_row_index_stride = 10000, orc_stripe_size = 67108864 ) (1 row)
Parent topic: DDL Syntax
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot