title: create table as select Join statement not working in hive
body: <p>With the command: </p>
  
  <pre><code>hive -e "create table C as 
           (select * from A a 
           left join T t on a.seller_id = t.seller_id 
           where day=31 and month=1 and year=31)"
  </code></pre>
  
  <p>I get the following error:</p>
  
  <blockquote>
    <p>cannot recognize input near 'left' 'join' 'T' in join type specifier</p>
  </blockquote>