[SPARK-2817] [SQL] add "show create table" support

In spark sql component, the "show create table" syntax had been disabled.
We thought it is a useful funciton to describe a hive table.
@chenghao-intel 
1 how about move it after define the testTmpDir? 
2 may I add some code in reset function to delete the temporal folder after unit test finished?