| -- Test SHOW CREATE TABLE on a table name of format "db.table". |
| |
| CREATE DATABASE tmp_feng comment 'for show create table test'; |
| SHOW DATABASES; |
| CREATE TABLE tmp_feng.tmp_showcrt1(key string, value int); |
| CREATE TABLE tmp_feng.tmp_showcrt2(key string, value int) skewed by (key) on ('1','2'); |
| CREATE TABLE tmp_feng.tmp_showcrt3(key string, value int) skewed by (key) on ('1','2') stored as directories; |
| CREATE TABLE tmp_feng.tmp_showcrt4(s1 struct<p1:string>, s2 struct<p2:array<map<int, uniontype<struct<a:int, b:string>, array<struct<c:int, d:string>>>>>>); |
| USE default; |
| SHOW CREATE TABLE tmp_feng.tmp_showcrt1; |
| SHOW CREATE TABLE tmp_feng.tmp_showcrt2; |
| SHOW CREATE TABLE tmp_feng.tmp_showcrt3; |
| SHOW CREATE TABLE tmp_feng.tmp_showcrt4; |
| DROP TABLE tmp_feng.tmp_showcrt1; |
| DROP TABLE tmp_feng.tmp_showcrt2; |
| DROP TABLE tmp_feng.tmp_showcrt3; |
| DROP TABLE tmp_feng.tmp_showcrt4; |
| DROP DATABASE tmp_feng; |
| |