title: Why hive doesn't allow create external table with CTAS?
body: <p>In hive, create external table by CTAS is a semantic error, why?
  The table created by CTAS is atomic, while external table means data will not be deleted when dropping table, they do not seem to conflict.</p>