title: HIVE CREATE TABLE sematicException 0:0
body: <p><strong>HI, all :</strong><br>
  i am newbie at hive, i got this error when i was creating a table using "select from " syntax,<br>
  <strong>my input is as following:</strong><br></p>
  
  <pre><code>`hive&gt;create table longyuan_web.tmp_recent_week_data_cookies as 
   select u from longyuan_web.ods_mbw_user_pv where dt&gt;='2018-07-19' 
   and dt&lt;='2018-07-25'and  platform='31' 
   and u is not null and length(u)&gt;=32
   and os='ios' group by u`
  </code></pre>
  
  <p><strong>i get this error:</strong><br>
  <code>FAILED: SemanticException 0:0 Error creating temporary folder on: hdfs://hadoop-bd-ns01/hive/warehouse/longyuan_web.db. Error encountered near token 'TOK_TMP_FILE</code>'</p>
  
  <p>i am pretty sure i am on the right cluster and the original table is also on this  cluster<br>
  <strong>what this 'TOK_TMP_FILE'?</strong> <br>
  <strong>thank you so much</strong>!!</p>